What sort of info / resources would be most beneficial?

With the community destroyed, your tenant has no choice but to move somewhere they can live and work today.

We don't know what states the properties reside.Florida, Georgia, Hawaii, Illinois, Indiana, Montana, South Dakota, Virginia have different laws.Oh, and by the way, an attestation to the insurer and others (mortgagee) will not change premiums nor constitute a “sale.”There are considerations such as the loss of asset protection after judgment (beneficial interest is personal property, not real property), but if the property is clear of a mortgage and the concern is title theft (a concern you raised), then putting the property into a land trust is probably a lower cost alternative to maintaining a debt (which irritates the wife). 

Trying to make good choices and allow our tenants to also have some good choices along way.

- Are there specific market conditions or trends in 2024 in Charlotte or Louisville that might influence your choice?

Both seem to be great choices :) 

But the market shares of those alternative choices matter.

Mountains and Beaches will always be a solid choice.

Even better, email the listing agent with your offer (beneficial to you because in real estate it needs to be in writing) and copy your agent on the email. 

Hi Robin,I do a fair bit of business as a lender in South Carolina; a lot of short-term rental investors tend to focus on the Charleston & Myrtle Beach areas, but if you are looking for properties that are still reasonably priced and don't mind some renovations, Columbia can be a great choice