In Illinois it must be a licensed plumber for non owner occupied properties. 

What are rights of owner vs tenants if new buyer wants to occupy one of the units as a condition of purchase?

However, finding a single-family home (SFH) with existing tenants who are open to an owner moving in might be a bit challenging.

We've seen competitor contracts that put 100% of managing utilities on the owner. 

Many owners foolishly waive this for S8 tenants.5) Time remaining on lease (many owners dump their properties when they find out existing S8 tenant will NOT renew their lease)We currently manage almost 100 S8 leases in Metro Detroit area, so we are very familiar with all this.

But this owner also has 355k Instagram followers because they have a unique property and have built a following for it.Granted, Cincinnati is not the peak of vacation destinations, and my friends that own Airbnb's here are going okay (at best).  

@Chris Schoonhoven, Columbus Ohio is a great RE market.Speaking of Hilltop, you need to find the sweet spot, I own duplex there and is one of my favorite, not really in Westgate, but that particular block is nice with home owners who take care of their properties, purchasing price is low, tenants there are low-income working class, I did serious tenants screening, and am very happy with the ones I have, it produce the most profit out of all my investments.

Ask to speak with some of their current owners and current/former tenants.

I would work with the property owner and see if we can work out a negotiation charging the tenant for a fair amount and the remainder be paid by the landlord.

On the numbers, once we leave it will cash flow nicely especially once we refi down to hopefully a 5.5% rate next year as its owner occupied.