They do NOT capture the reality of every market condition, every strategy option, every goal objective.

It is all about know what comps to choose, and how to value or devalue certain features, and understanding the condition scale etc.I would be leery though of placing it under contract with a buyer who has not seen the property.

For something undervalued on the MLS you would probably have to find something that condition will limit the financing options.  

As I said above I'm a newbie, but I'd look into buying a multi family home in the area you want to live. Rent

I can't comment on condition of the mechanics but judging from the pictures the exterior looks to be in great shape.

The basics are you find someone who will sell a house at a discount because of the condition of the home or some other special situation like death or divorce. 

We've really updated/remodeled and made our current home awesome and in move-in ready condition (new carpets, paint, fireplace, remodeled kitchen, remodeled bathrooms, custom tile, etc...).

The condition of the house, the property size, location, age of the house, finish work, etc. all weigh in to valuations.

Structures are like people in that the inner condition is reflected in the outer condition, thus any readily apparent deferred maintenance is a harbinger for more problems waiting beneath the surface.

I suggest you not go 30  years with a note going to an estate, your high school buddy may very well look you up with an unpleasant attitude messing up his parent's estate in their elder years, but check with an attorney familiar with estate requirements.......you can also address such issues with a conditional demand feature, if this happens then they can demand full payment in 6 months for example.