Stafford Road was flooded and around 9,000 homes were left without water