However after being directed to Metro Water, They mention that the nearest services, are a 1000 ft away.

My only backup plan if I can't get verified funds is to assume the worst and to drop my counter offer even lower than my original due to the risk I would be taking on, and then when I do my in person inspection try and guess what rents are fair market for the empty units, and ask as many tenants as I can what they pay in rents monthly.

From 75%-80% the hit drops to 3.375% & from 70.1-to 75% it drops to 2.125%.

I've had my contractor pour a leveling liquid over sections of floor and then run LVP or carpet overtop to correct for a few inches (1-3 inches) in drop in a room or two.

Regarding your 2nd floor kitchen faucet that is experiencing low water pressure, it's likely a simple fix such as the faucet aerator (a screen that helps create a smooth stream of water).

...in its simplest form, you just divvy up the water bill 10 ways....watch water usage drop.  

Instead, you want to find out about the property owners in the area and keep in touch with them long term via periodic calls/messages, emails, drop-bys, mailers, etc.- FSBO: Free seller leads on Zillow.

Drop the Zen nonsense, start embracing Karen. 

Side note, if you can breakeven on long term rent, then you will cashflow when rates drop and your home will likely go up in value when the market responds!

I'll add, in investing you have to follow your gut and if you're already calling it "very questionable", drop it and move on.