I am in the Alternative Investment space and help investors transition from active real estate to passive using trapped equity so it is driving me crazy to be sitting on a huge amount of trapped equity. 

Also look at job growth and alternative inventory growth.

In the United States in 2024, mortgage rates are generally tied to the overall bond market, as most residential mortgages, including conventional qualifying mortgages for owner-occupants, residential investment mortgages (DSCR loans), and even other alternative residential mortgages (non-QM), are securitized.

Still looking for alternatives outside of an excel sheet.

Great alternative.

However, I've encountered a setback as my initial lender has withdrawn (100%LTV), necessitating the search for alternative financing.

But what if you purchase with alternate financing (sub to, assumable (look at VA but requires OO), owner financing, etc) and only did buy, rehab, rent, and repeat (one less R)?  

For conventional financing, condos need to be 'warrantable' if the condo or HOA doesn't meet those guidelines it is 'non-warrantable' and there are alternative or Non-QM (non conventional) lenders that offer financing.

Is there an alternative finance method to buy the property?

Equally important - would this return be greater than your other alternatives, such as the equities market, private lending, investing in a private fund, etc, once you account for the work and risk?