It would be our second up down house hack, however, with interest rates in the high 6's, it would probably not cash flow after moving out.

A lot of people sleep on properties that have been sitting, but where some profitable opportunities are.That said, I’ve been spending a lot of time working directly with investors and sourcing off-market multifamily deals—ones that never make it to Zillow or Redfin.

Other then that you can sit tight and let your primary appreciate, save more and explore pulling a HELOC to tap into it.

And how does the time the Airstream is just sitting in my driveway at my primary residence count?

You can have the most beautiful kitchen, floors, and an overall great rehab, if sales are declining in the area or properties with similar rehabs are sitting on the market for several months, the appraiser will cut your value. 

We usually sit in the back room at a round table and energetically discuss real estate - you will immediately figure it out, everyone does :)

I had a lot of rain water drainage issues in the past for which I built a french drain /trench drain on the side and back which stopped those drainage water issues flooding my backyard and crawlspace areas(at one point lot of drainage street rain water used to sit many days in crawlspace which used to be pumped out by handyman).

Get it under agreement for less than asking price and offer to bring the loan current and have them carry that loan.The way I see it is they are just getting MLS properties under agreement - the last five I looked at had been sitting on the market for more than 150 days (overpriced) because the payoff of the loan would not be satisfied at lower price point. 

I wonder if there is any data on how many homes are currently sitting vacant and in need of rehab to help offset that housing shortage! 

I am currently living out of state so I have hired a property management company to handle this task, however, my home is still sitting vacant with very few prospective tenants.