I have purchased turnkeys over the years and have had mixed results.

This area has a unique mix of affordability, beauty, and rental potential that makes it a standout choice for real estate investment.

I have a 100 unit portfolio based in Louisville and Lexington KY mixed between SFH, and 4-8 unit apts.Biggest help for me was their ability to insure closer to the purchase price instead of replacement cost. the team is great and I’ve been happy with the claims process. 

The other two have a mix of ideas.   

For the mixed-use building idea, you’re right to be cautious about vacancies as a remote investor.

Pairing that with relationship-building will help you uncover off-market opportunities and find local experts who can guide you.For meetups, here are a few ideas:Indianapolis Real Estate Investors Association (Indy REIA): They have a mix of virtual and in-person events and are a good starting point for networking with other investors in the Indy market.Louisville Real Estate Investors Group (REIG): A similar organization for the Louisville market, with educational and networking opportunities.Check out BiggerPockets Meetups: Many cities have local meetups organized by investors active on BiggerPockets, and they often include virtual options.Facebook Groups: Look for local investing groups like "Indianapolis Real Estate Investors" or "Louisville REI."

We mix it up with performing and non performing loans and we have some performing that are short term bridge loans as my confidence in reperforming paper is low based on the re default rate risk.One last thing to touch on, there was a comment that I am one of Marco’s henchman.

I like the location and the price is 650kFor mixed use properties as you describe (and I'd assume is located on SW 10th St.), I'd recommend that the residential units fully cash flow the loan as my experience is that mixed use properties are tougher to finance as most lenders tend to prefer one or the other and something in the middle gets more difficult.For example, and granted I don't know anything about the area/neighborhood, I would expect this property (https://www.realtor.com/realestateandhomes-detail/111-NW-Har...) to be easier to finance than the mixed-use property you mentioned. 

Depending on local regulations, you can mix up STR/MTR/LTR. 2) Get systems in place in those exact cities; 2 PMs preferably via NARPM, 2 high quality inspectors, and rotating book of handyman, 1 lawyer, and a credit union contact for leverage along with investor friendly nationwide lenders.

Detroit has a mix of affordability and strong rental demand, with properties under $200k that can cash flow if approached correctly.