It changed my mindset and removed the emotion of being a home owner.

Don't emotionally attach yourself to a property.

Don't burn a long term neighbor relationship over what is likely a temporary tenant.On the other hand, if your neighbor is a screwball, it makes things a lot tougher but active diplomacy should still be the first line of defense here.

All of a sudden, my attorney and realtor notify me that the previous temporary Certificate of occupancy expired since January and I have to apply for a new one.

We bought several properties, but it was a major emotional discussion every single time. 

You know your own situation best, but that certainly sounds like asking for trouble--emotional, financial, logistical. 

Offer some temporary discount pricing so you can get some 5 Star reviews.

Since you're moving so far away, you might want to look for a temporary place.

Don't get emotional or raise your voice.

Even though they got the HUD sheets, they did not want to pay the costs out of their share.Property is VERY hard to split when people are emotionally involved.Is a shared property with kids worth it?