So the goal is to sell the property but remain as a tenant. 

Perhaps possibility but the complexities of showing and selling/renting all at the same time can make your head spin.

My partner and I are very interested in single family homes, As we enter into a volatile real estate market we are focused on families and creating wealth through selling affordable homes.

Then sell it to them at a slightly higher price?

Could be a national lender or a site that sells your info for solicitation. 

I was told by an agent Knoxville new build don't sell to investor because of limited inventory. 

You could build or flip less expensive units and sell them to your clients/occupants over time.

You can also sell the property to a landlord.  

Flexibility in lease terms can be a big selling point.Hope this gives you a solid starting point!

I may not be the most polished investor but I'm also not going to try and sell you on anything either haha.