So here are my questions:- Can we co-host a mid term rental in Texas or would this be considered Property Managing since a lease is involved?

Has anyone been using a chat bot to assist them or their property manager(s) in their day-to-day operations?  

that is going to require a lot of data and database management and offmarket deals are all case-by-case so it almost certainly wouldn't be easy to productize (i.e. you probably couldn't get AI to do this). 

Then some time on understanding risk and how to manage potential downside vs expected upside.

My property manager has the property listed on most of the major booking sights, so I am comfortable with their efforts.

What made this opportunity particularly enticing was my prior experience managing this exact duplex for the same investor over a span of three years.The property itself is a 1950s duplex that underwent significant renovations in 2017.

We currently manage them ourselves.

Managed property purchase.Negotiated water rights to be transferred in the sale.

I have hesitation with out-of-state investing, and I would like  be hands on with my rentals as well as not use a property manager.

Even if you create a non-CA LLC, if you are managing the business from California, you will likely be deemed to be "doing business" in California and therefore likely subject to CA taxes.