A credit report goes back 7 years.

I’m waiting to hear back from a city representative to see if it’s possible to divide the lot into multiple lots and put a mobile home on each lot.Once the land is paid off and divided, is it possible to use each lot as collateral for its individual mobile home? 

Don't trust what ANYONE tells you about a market without solid data to back it up - this includes claims about how many transactions they've done or a single example (that's often from several years ago). 

.• Use some equity from the sale to make this transition smoother.I’m torn between maintaining our current home as an asset and buying  a new smaller house to use as a rental after we move back in versus simplifying and focusing on a single upgraded property Considering factors like market trends, potential equity growth, and quality of life, which path do you think would be most beneficial?

Definitely focusing on offmarket or even on market multifamily homes (minimum 4 units). started off in real estate development last 2 years but the paydays are brutal building then waiting to sell.So now looking to switch up strategies to purchase cashflowing properties and then get back to ground up construction or even possible fix and flips. 

But assuming thsi is something you plan to pay back in 2-3 months the interest rate shouldn’t matter.

Going back to a W2 is not what I want to do, at least not in my old industry. 

Simple - reply back with what you just noted.

And if you build it the right way, you can always fall back on the long term rental strategy here too.Location is always key here.

Fortunately, I was thinning my herd back in I think 2014 or so by getting rid of a few (experimental) investments in cheaper neighborhoods.