I would like to know if you would advise such an investment which has to be managed mostly remotely.

i hear hostaway works good. i just manage my own on 2 OTA platforms. pretty much all is streamlined on there. just have to keep up responsiveness and price optimization. but you could always hire out to a co-host if that would be worth your time. 

Finding new tenants during the colder months can be challenging, and we aim to avoid any prolonged vacancy periods.Enhanced Flexibility for Tenant Management: Another factor influencing our decision is the greater flexibility it offers our property manager, ****, to effectively manage and find tenants during the summer months.

Start driving to them and talking to the owners and not the managers.  

Other smaller areas in Texas can work as well.Do you mean turnkey meaning all-in-one so the turnkey company handles property management, tenant leasing, etc?

Will you self manage or hire a PM?

Then find a good property manager and realtor to work with.As others mentioned, you could also buy a place for yourself and rent out a suite or rooms (if you are open to having roommates).

Thought is triple+ cash flow with just one insurance, maintenance, and management cost.

I am making this my big push, as it is a win-win right now, alongside my property management business.

As others have mentioned (besides the essentials like rates, mortgage, and maintenance), it's important to consider utilities, insurance, property management fees, taxes, furnishing, marketing, and legal requirements.