More than three inches of rain has fallen in some places in just 24 hours with streets becoming submerged and homes being swamped