Dramatic footage shows cars submerged in the street