Having said that I have been investing and rehabbing properties for over 25 years so I feel pretty confident on what needs to be done and I know how it should be done.

Make sure you build a solid core-4 team so you can be confident throughout the whole process. 

Ideally, I'm looking for a general contractor or developer willing to engage in a revenue split arrangement or someone interested in a long-term land lease.Does anyone have advice on how to navigate this situation?

I am confident in the debt raising aspect.

I would not engage with this ex-tenant. 

To start modest and build confidence, start with tiny, reasonable investments, like house hacking.

Following David Green's Core 4 strategy (realtor, contractor, property manager, and lender) gives confidence to invest anywhere.

I'm eager to connect with like-minded individuals and continue learning and growing in the real estate market.I am interested in buy and hold or fix & flip deals of SFH up to $250K all in.Looking forward to engaging and building connections with the community!

You should engage a civil engineer to complete a survey and they will be able to tell you based on the  zoning and dimensional requirements whether the subdivision is plausible.

I am confident I can get the deposit from them but at this point do I even want to?