You'd be surprised how much the water quality can change, even 100m down the road.

My bore water is drinking quality, yet 100m away in the new estate behind my place, all the houses are getting stained brown from the rusty bore water.

It can sometimes be blamed on the pipes leaving hard deposits, depending on what they are made out of and how old they are.