Buildings and cars were left surrounded by sludge after stormy weather hit