You'll likely want someone that can handle A to Z with marketing, pricing, cleaning, maintanence, decor, websites, reviews etc.

I'm not the first to build to this design and type of community so I'll be reaching out to the experts when the time comes.

Not in San Antonio, but Scott Horne out of Garland is an expert and runs a title company.

Any advice on potential MTR markets near Houston and surrounding areas?

If you get greedy and put #3 in front of #1 or #2 you can get burned like any other market. 

There are several articles that do an exceptional job of explaining who, what, where, why and how tax payers qualify for the ‘STR Loophole’ listed here:The Short Term Rental Tax Loop Hole: A Game Changer for W-2 Wage EarnersThe Short Term Tax Rental Loop Hole: What Investors need to know The implications on the Oregon and California Coastal STR market is a strengthening buyer pool for luxury rentals in the $750-1.5M+ range.

Part of this is due to marketing and pre-marketing of the home - an agent is your marketer.

You plan to outperform the experts that do it for a living?

And yet every retirement expert tells you to sink every dollar you can afford in to these accounts. 

They’ve already made a name for themselves in Mexico with projects that blend eco-friendly practices and thoughtful design, and now they’re bringing that expertise to one of the most popular markets in the U.S.For investors, this could be an exciting opportunity to work with a developer who consistently delivers quality and strong returns.Check it out:  Travel weekly by Northstar