Is this a LT residential interest or more like a shared sober house living situation?

It's actually harder if you are currently living in the property, want to cash out, and then have it as a rental as you haven't proven to the bank that the property will cash flow $600 a month on top of the NEW mortgage costs. 1.

Book recommendation #1: Hands Off Investor by @Brian Burke https://store.biggerpockets.com/products/the-hands-off-inves...Book recommendation #2: Lend to Live https://store.biggerpockets.com/products/lend-to-livePodcast Recommendation: PassivePockets podcast is focused on passive investing in syndications - https://passivepockets.com/podcast/Passive investing summit: PassivePockets Summit May 2-3rd in Columbus https://get.biggerpockets.com/passivepocketsevent/I make these recommendations specifically since you mentioned passive real estate investing, and syndications or hard money lending are really the two most passive ways to invest in real estate. 

Foreign citizen currently living in Miami.Any recommendations in general?

I live in the Metro Atlanta area (near Gwinnett, Walton, and Rockdale counties) and am open to opportunities in other areas as well.I’m just starting my real estate investing journey with a focus on wholesaling.

Unless you want to live in that district, I would avoid any and all purchases in an area like that.

Preferably out of state near Charlotte NC where our daughter lives.  

(They did multiple inspections, also came for several full afternoons to just poke around the house while we were living there.) 

I live in a small town in eastern Arizona, about 7000 people, and we have a pretty serious shortage of rental properties.

Where I live, we still have a severe shortage of homes--median time on market is still 7 days and it would likely be shorter if not for delayed negations being the norm.