I've found the easiest solution is to have a really strong banking relationship and then they will be able to provide non-standard offerings. 

If I were you I would house hack in RI, specifically in Providence in as good an area as you can afford. 

And, when there is a vacancy, can the remaining units provide enough cash flow to cover all costs?

When you do a traditional 1031 exchange you have 45 day identification period, to provide a list of potential replacement properties and 180 days to close on a replacement.

I’m local to the Amarillo area and would be glad to provide local market knowledge if that would be helpful.  

For your first guests, go the extra mile—leave a welcome note, provide thoughtful amenities, and ensure the place is spotless.After their stay, send a friendly message like, “Thanks for staying!

I have helped Dozens of local and OOS investors buy and sell traditional investments, acquire 'house hacks' and STRs, as well as assist OOS investors with tenant turnovers, getting properties rent ready and placing tenants.Reach out anytime to discuss the KC metro and how it fits into your REI goals of providing generational wealth and eventual financial freedom

Hey Kyle, refinancing might not provide significant benefits at the moment, especially with rates where they are.

Private money lenders or construction loan specialists, on the other hand, are faster and more flexible, though their rates and terms will likely be less favorableFor a more rural area, local banks will almost certainly understand the market better, but connecting with private lenders who specialize in spec homes could provide more agility.

We use Propstream but I am looking for some added info that Propstream does not easily provide  @Sean OToole is the owner and he has built an incredible platform..