If you acutally have clogged hot water pipes your water would look like red mud. 

My goal is to rent and sit on it, but my fear is that it will be undesirable in the long run due to it being the only multi-home in the neighborhood.Any tips are much appreciated. 

I have a feeling the old cast iron air vents, to the sewer lines, terminating in the back garden dirt against the basement wall may have allowed mud/debris to run down into the sewer line & subsequently block it.Guess we were lucky...but definitely not responsible.

I would say to find a good realtor you trust that can steer you away from the many undesirable neighborhoods here.

The only adding we did was a front porch roof, and we took the existing foundation for the back porch and storage room and converted it into a laundry/mud room.

As for Valley Ranch, I work on that development and I'd hardly consider it investor friendly due to all the new home construction, you're buying at retail prices and getting saddled with all the high MUD taxes that come with new developments.

I would rather buy in a good location with good tenant pool for lower returns, than in an undesirable area with high on paper returns (which can often turn out to be lower returns in reality). 

Usually, the pre-rental medical screening tests that you put your prospective tenants through would have caught this and any other undesirable diseases they might have. 

Typically I install laminate through living rooms, bedrooms and common areas, tile in the bathrooms and mud room/entry foyers.

Would be pretty easy since it doesn't appear to be taped and mudded yet.