We then stayed in that one (though it wasn't bad - just needed some cosmetic updates) for 7 years, just moved out, kept it as a long term rental, and moved into another major fixer in our STR market across the country near Acadia National Park in Maine.

Stick to Iowa and possibly eastern Nebraska.

Was this appraisal ordered through a big AMC like appraisal nation who most DSCR lenders would accept a transfer from?

I'm in Orlando and a full time Realtor and serve on the board of CFRI, the local chapter of the National REIA.

You'll find lots of content there from investing in turn key properties (I have have 15 REI Nation SFRs) to passive multifamily (have a $3M+ stake in 1500+ units) to renewable energy (energea.com).

The metro area population of Montgomery in 2022 was 367,000, a 1.94% increase from 2021.In a number crunch of 300 cities using 10 metrics ranging from home prices to tax rates to vacancy levels, WalletHub determined that Montgomery, Alabama, was the nation’s most affordable city for homebuyers.

The STR arena is highly complex and  significantly down in multitudes of markets across the nation.

Rahul, I have about 10 you can talk to. you'll also want to have an equity partner with new build experience so you can get the best terms. most of ours are national lenders. we doing joint parnterhsips for new builds and take a small interest in a single purpose entity for example:Rahuls New Build LLC (95% owner)Pink Development and Construction LLC (5% owner, no voting or distribution rights)Take title to "Miami New Build Limited Partnership LLC" which is a single purpose entity. 

Egress window will be a must, because that is part of national fire code.

Medical/physician programs are typically best for primary or investment purchases..check in with @Joseph Chiofalo he is a national lender and refinance savant that's worked closely with me for over two decades.