As mentioned it's been 15+ years since I've been there. Yes, the end of the sand dune road ends in water. It does continue on dry land for a while past the flooded section but eventually ends in a swamp.
If you go down the sand dune road from Carranza rd, just before where it's flooded, you...