When i replace water heaters i replace all the short pipes.   

I've also leveraged that capability to build some pretty cool dashboard on my end to occupancy, revenue, and cancellation rates across all platforms. 

Your new pocket neighborhood sounds really cool.

I'm new to the real estate investment game and I'm a bit nervous about dipping my toes into unknown waters. 

Your best bet is a property on water and sewer in a non HOA community and either convert the garage to an ADU or Build a separate ADU .

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

If you want to check out a pretty cool interactive map that shows tax data for every state, and even county, check this out from SparkRentalhttps://sparkrental.com/states-with-the-lowest-property-taxe...

Is the paint latex, oil or water based?

The behemoth cabins in the Smokies are super cool, but other than high season, it's mostly weekends.

City water with one main at the street and how will they bill.