Also would greatly appreciate recommendations for agents, lenders, and property managers in the OKC area as well. 

Quote from @Paul LaValley: I live in Tucson and know Tucson really really well so I want to start here and then jump up to include Phoenix area. 

If you find something that works well as a short-term rental, but doesn't work well for you as a home, you'll have money but be dissatisfied when you live there.You don't even need it to produce a profit.

While this trend is already common in downtown areas, will it start reshaping more traditional suburban neighborhoods as well?

My experience with PPR has been consistent with yours, as well as the search to find them.  

After much research, I am interested in any insight or information on Clarksville Tennessee.

Thank you Jay 👋 Do you invest in real estate as well as act as an agent?

Unless you are unknowledgable, my bet is you could make more from rent than sale, and still have the benefits of owning the original home while you go do something else.The 25K you have left in property will be netting you(gross) of $350 mo or 4200 per year.

Well, he spent all the money in the account, a lot of personal expenses and paid himself money.

You'll get to write off any home expenses against your rental income as well.