I am sure someone has worked out the best workflows, triggers, messaging etc....

In Phoenix, I might call up a friend who invests in mixed-use properties south of Roosevelt Row, and that friend might know a local title rep who’s been working with out-of-state buyers who like to pull the trigger fast.

Another consideration is that if you do a 1031 exchange back out of CA the state is a "claw-back" state so CA will try to get their capital gains eventually.

I’ve always wanted to renovate my investment properties, but it’s so hard to pull the trigger.

I am not saying they are not important considerations but there should be more to your analysis.You also rattled off two NW Philadelphia neighborhoods in East Falls and Mount Airy.

There's also a considerable risk that the person you're dealing with isn't actually the owner of the property.

But how can you transfer a property into an LLC later without triggering the due-on-sale clause?

I have seen your posts on BP regarding Tulum for almost a year now and am curious if you pulled the trigger or if you are still analyzing Tulum. 

There is no question that investors not moving into Real Estate AI-Tools are going to be left behind in consideration of the availability of data, and how AI is using that data to analyze and prove value. 

If you fully understand the process, the potential for profit can be considerable but if you do not, it can be bad - real bad.