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.

Additionally, the retail sector continues to reel under the pressure of an accelerated shift to online shopping, further exacerbated by the economic repercussions of global challenges.Moreover, the financing landscape has tightened, with rising interest rates putting additional pressure on property owners struggling to meet their financial obligations.

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.

Not only that but I also would like to connect with everyone, investors, private lenders, loan officers, tax consultants, attorneys, contractors, property managers ETC.