Our water has done this in the past.
It started a few years ago, We had several foster kids and the four of us and we used lots and lots of water, not really thinking about the results. We had the water hose on in the back garden and i went into the house and turned on the tap and has red sandy water. Well, i called the well place that had done work for us in the past and they were not really concerned about it because we still had wate and had not lost any real pressure. We had gotten a hole in the lining of the pressure tank that had collect sand is what they said...so we replaced the pressure tank and after a couple of days, the water was just ok, so i called back and they came out and added a filter inside the house off of the pressure tank and they told us to take it easy on the water for a few days and let it settle and they said that we should not be washing cars and watering the garden and such for a while. they also said that we would not run out of water but we were using too much to fast for it to fill up (what ever that means) but we did take it easy and Well everything seemed to be better and back to normal. later, about 3 months after that, i come home, get some water and it is red dirty again so i decide to find out what the problem is and i walk through the house and someone has left the water on in the bathroom sink and we had been gone for hours. I call hubby, he comes home and changes filter and it is back to normal. Well, with kids (and hubby) this type of thing happens so i just watch out and watch the water. We are in an underground river and it is suppost the be the main source for half of the county we live in so we were told that if we run out of water, so will half the county. I watch the filter and make sure we have no wasted running water and it has been several years with no real problems. When our filter is full and hasnt been changed, it will seem cloudy and as soon as we change it, it is normal again. So, if you have a filter, i would change it and if you dont, i would invest in a good household filter.
Belinda