They almost flooded the entire ceiling the first day because they couldn't even figure out how to turn the water all the way off.I am looking for an answer on how I can deal with this.

You mentioned the roof and AC being new and i'm assuming they're in good condition.10% should be enough to cover the random water heater that goes or any other lesser headache. 

I recall when I first dipped my toes into out-of-state properties; it felt like navigating uncharted waters, but it opened up some incredible opportunities.Between BRRRR and turnkey, it really boils down to how hands-on you want to be.

One of the tenants hung a picture on a wall, puncturing a water pipe.

Lack of water?   

I have a lot I have purchased in Cancun and am needing to submit plans for the construction of the home itself fairly soon and am like a fish out of water.

However, upon finally gaining access to the home it appeared that the water was running from every faucet in the house.

Muddy up the waters more than that and it can become impossible to leverage.  

The biggest danger is a leaking tank that causes water damage, but it hasn't happened to me yet.

Here are the numbers I know so far:Rents4 units all currently occupied on one year leases- #1: 1/1 $995 monthly- #2: 1/1 $995 monthly- #3: 1/1 $995 monthly- #4: 2/1 $1,100 monthly- Gross rents: $4,085 monthlyExpenses- $12,070 taxes annually- $350 monthly insurance (my estimate, they have liability only right now)- $175 monthly landscaping- $120 water (electrical on separate meters, tenant pays)- Total expenses: $1,651 monthlyNOI around $2,434 before vacancy, maintenance, and management (although i would likely self-manage these)Property needs about $50K in other repairs and udpates from what I can see.