After doing some more water testing I am now convinced that I have identified the source of the foggy water. It's phosphates and not "dirty" sand.
Each time I have had the foggy water phosphates have been slightly elevated. Ammonia = 0, Nitrites = 0, Phosphates = .25 to .50 when the water is "foggy". Phosphates = 0 when the water is crystal clear.