The emotional content is high with a lot to lose on both sides.  

This is why Market Analysis, with NO emotional rationalizations, is so important, before you buy. 

Our insurance did not cover moving the tenants out along with their temporary housing.

Emotional purchases are bad investments.

In general medical professionals are looking for smaller units (studio/1 bedrooms) not 2+ bedrooms- In order to understand corporate demand you should research the types of corporations in the market and figure out if they bring traveling / temporary workers to the area because not all corporations do- You didn't mention colleges but if there's higher education nearby this can also be a driver of MTR demand.

I am not trying to grill you, I am trying to help you and others reading this.Really let go of any reservations and emotions you have reading my message.

It’s literally the first website that comes up when you google emotional support certification.

He played on my emotions - it's easier than finding properties and dealing with tenants, PMs, etc.

By what you have said, it sounds like you are thinking about this place as an owner (emotionally) vs a realtor (sorry if I am reading into this, but your statements about charm etc.).  

It is tough to go through the whiffs on these contracts, but I am understanding this is part of the process and need to really get my emotions out of it.