Severn Trent Water say a road closed after a water mains burst in Derby should re-open next Tuesday.
Mansfield Road in Chester Green has been shut since the incident in the early hours of Sunday morning.
The 10-inch pipe fractured, sending a jet of water into the air, flooding nearby homes.
Leigh Gregory's home was one of those most badly damaged. He, his wife and three children were trapped in an upstairs room for six hours when water started cascading into the house. They're currently staying in a local hotel and hope to move into temporary accommodation next week. But it could be months before they can move back into their home.
Businesses have also been affected by the road closure. The landlord at the Coach and Horses pub, which looks out onto the scene of the mains burst, says it's been very quiet, even on Wednesday night when it would normally have been full for the Germany-England football match.
Severn Trent is pledging to compensate businesses who have suffered a loss of takings. The company has also laid on a free shuttle bus to help residents get in and out of Chester Green, after normal services were disrupted.