From what I’ve seen, if one wants a long term rental, Redmond and Prineville would be a better bet.

My additional concern is that if I long term a tenant in the top, would the noise of a family scare off my Airbnb tenants below? 

Additionally, and perhaps and even bigger factor, is that all QOZ real estate investments will involve either ground-up development or "substantial improvement". 

If I buy betting the neighborhood will improve, the increase in revenue is totally dependent on outside factors over which I have no control.  

Not really your target respondent (not in major resort area), but I don't find it much additional work to list on ABB, along with VRBO/HA.

Best bet, if you’re motivated, search, or have someone knowledgeable search the all the recorded documents, mtg, foreclosure action, etc.  

Additionally, finding the right investor focused RE agent will help you to analyze deals, keep you apprised of off market deals, and allows you to keep a pulse of the market conditions. 

I bet we can meet at Salt Hill Pub.

The cost of living is an interesting one - as in my view it supports a decision to move somewhere, or perhaps a business decision to open a satellite office, etc - however it does not typically 'drive' that decision.One of the key and most important advantages that Iowa has from a labor perspective, and I believe why the DSM market is a great fit for insurance/finance - is that the typical resident knows central Iowa and is 'content' - this doesn't mean that they are settling, as I do believe the DSM market is a 'special' place once you get to know it - however I'd put a strong bet as compared to other metros that if you polled people, the question 'Do you see yourself moving in the next few decades or do you ever yearn to move?'

Tons of entertaining space in the basement in addition to the 5th bedroom and full bath.