'It caused sheds to collapse and back gardens to fill. Residents were evacuated via police cars and fire engines'