Your photos are also dark which makes it less inviting and cozy for potential guests. 

Many times, when i replace a water heater and take a look into some of the short pipes that connect, they are approx 80 percent closed. 

However once all was complete, the tub and toilet water still had a yellowish tent to them.

Sounds like you stopped water which is most important.

The setup for a bullish Spring real estate season is palpable.Let’s get into it.Project Update: North Nashville Duplex Construction has begun on a cozy duplex I picked up in North Nashville a couple months ago, a lovely little transitioning neighborhood just an 8-min Uber to downtown (yes “cozy” is real estate parlance for small, but it will be cozy!).

Same property listed water bill paid by landlord so how much does it cost to put individual meters for each property so cost can be moved to tenants? 

I'd personally say pulling your water heater out and replacing with a wall mount on demand one, would be worth the cost to have in unit washer dryer if you are staying there or renting it, it would be worth it.its always worth doing the big stuff well and correct even if you are cleaning up after someone, the long term hold always prevails, its just a little frustrating front sometimes, but hang in there!

I just don't want to buy that close to the water due to flooding concerns.  

What happens if the water service line has to be replaced?

That's easy compared to trying to fight and erroneous $13k water bill (a real issue we had) or an insurance policy tripling (that too).