so after what 26 years it paid off but it for ME was a process.. and let me tell you so many of the BP folks have started in RE post 08 when O8 hit if I did not have this banker I would have cratered he carried me through when any other regional bank would and did kick me to the curb..

(note this is my 10 seconds opinion after looking at the map... note.. do not take it forgranted.. i maybe wrong... since I am personally not familiar with this area, but rule of thumb... is... typically the first impression is right... think of Hurricanes....)In regards to figuring out which property has good appreciation and all that jazz... just hit up loopnet analyze bunch of listings and you will get the gist of it... or feel free to check out my blog.. to see how newbie like me navigates the waters within the first 2 months and 8 days in the journey of commercial real estate...  

I use two of my Studio/Efficiency apartments as Airbnb units for the last couple of years.

I'm aware that "re-training" (as @Brandon Turner would say) will be part of the work involved in getting this property churning at full efficiency, however I think I have more important decisions to make (see below). 

@Dennis Johnson to add to what @Chris Tracy said, which was spot on, his first point - you never have to feel guilty by hitting them with 21 questions, that's what you're paying them for!

Hit or missIf I got this offer I would be insulted you're trying to bring emotions into a purely business decision.

Her hubby is super frugal and risk averse so even that “small” loss hits hard.Jay Hinrichs agree that the realtor is also at fault here.

Not enough information to even offer any intelligent answer, but there's not too much real estate hitting a 2% rule (I prefer guideline, but anyway) these days except in war zones. 

Plus in a downturn, condo and townhouse values tend to get hit the hardest first. 

Hell, maybe you can market the property as a duplex with the basement situation fixed, and bring in more at sale.As everyone else has stated, it sounds like your capital expenses are going to hit the fan very soon here.