My nearest diving place is 600 km (372 miles) away home. Its a stone quarry with fresh water. Nice, not much to see, no more than 12 mts (40 feet) depth .
The second nearest is a quarry with fresh water 800 km (500 miles) away. Water cristal clear, green, hardly any fish to see.
The third place is a beach, 1100 km (680 miles). Sea water at least. There is a wreck (a small fishing ship) and several specific spots to dive.
There use to be some other stone quarries that are no longer in use owing to darkness/no more visibility. Those places became ruined because of the lack of maintenance and infraestructure.
The place that I dove and is the best for me, because is far away but still accesable is Bombinhas in Brasil. It's 1600 km (1000 miles) away home. This needs an intermediate stop overnight to go by car.