In addition, I will also be paying much closer attention to water flow patterns and signs of erosion around our next investment!  

Given this is where my major operating expenses fell (beyond taxes and insurance), keeping this cost lower, by average, helps my cash flow.I invest in older neighborhoods, so the 2-4 unit properties, typically have single water meter, maybe single electric, and many have radiator heat with a single boiler.  

With the lower price point rentals, you basically just tread water.

The rental might be vacant for a month,(8% loss) or a tenant might not pay for a month while you pay to evict them.(8-16% loss)  A $1,000 appliance/water heater, or a $8k rook or hvac unit might go out.(5-40% loss)  You should be paying a PM 8%.

Over a weekend during which my tenant was not home, the condo became flooded and water went through the flooring and flooded the office below.  

An alternative to batteries is a "water battery". 

That certificate would show open taxes, water, housing violations, citations, condemnations, receiverships, construction liens and other municipal liens.

You might need a 2nd well if you're not on city water. 

I estimate high of what the bill would be and put it on their lease, I have not had any issues this way and if the water bill goes up, I will increase on the next lease. 

If the security deposit is not going to cover the the water bill or damages, try to scare him into covering the balance by hinting at sending him to collections and it will appear on any future credit pulls he may have done.