Will tenants accommodate this?

Your expense ratio will be higher than a MH park (which average about 40%) depending on how many transient spaces you still have, the hours of operation you keep for your onsite staff to accommodate new arrivals, and the amenities at the park that create additional expense.

Long story short, I am hoping that someone in this community would know of someone, somewhere in NC that has land to sell or lease that has some framework done to accommodate a tiny house on wheels.

You can either have a mobile notary come to you to accommodate a signing, and then the notary will mail back docs to the title company. 

It appears to me that the occupants might just ride this out to the very end to get free accommodation which is not ideal at all.

A large portion of the traffic will be tourists; I'm looking at accommodation, food and beverage industries first. 

The safe harbor provides that the IRS will not challenge the qualification of property as either replacement property or relinquished property, or the treatment of the accommodation party as the property owner under the like-kind exchange rules, if property is held in a qualified exchange accommodation arrangement (QEAA).

OOS investor is no problem although as you've learned many local banks won't accommodate. 

When we looked at the house the tenants seemed very nice and accommodating.

Homes are being built everywhere to accommodate Atlanta's positive net migration.There were 7,849 closings for Residential Single Family Detached in July 2021.