I went to class one night a week at a local brokerage close to me and studied the rest online at home with my text books and online practice tests and video classes

I have friends in the area who are renting out bedrooms for $400 per month in an apartment so it seems like just another way to improve the cash flow of the property. 

In addition, I think there is still a lot of opportunity for improving the product.BTW I recently looked at Mileage IQ and other competitors in the Apple store. 

I was practicing driving for dollars and I found an abandoned home in San Diego yesterday.

Rental arbitrage is a widely accepted practice done by landlords, property owners, and investors all over the country.

It might help you sell the house since you can indicate that it has been upgraded.I would do what is necessary but not go overboard.If you have galvanized, replacing the water line from the street to the house makes a hug improvement on water pressure as galvanized will rust and restrict the flow of water over time.I believable you just need to have working plumbing with good water pressure for the appraisal.I would be more worried about plumbing issues or old piping showing up on a buyers inspection than it affecting an appraisal.

Large private water companies (those with revenues of at least $250,000) are regulated by the Public Service Commission (PSC) and subject to the Home Energy Fair Practices Act (HEFPA).

The blame for poor situations isn't to be shifted or avoided but accepted and then used to as a catalyst to improve. 

Disclaimer: While I’m an attorney licensed to practice in PA, I’m not your attorney.

Suggest you invest inspection with a foundation contractor give you practical aspects of foundation.