House hacking cash flow increases depending on how little space you can live in for a year (or more).I can't speak to Minneapolis inventory directly, but multi inventory is low in a lot of places.

Property Details- Size: 64,000 SF Class A mixed-use building - Commercial Space: 25,000 SF - Residential Space: 39,000 SF (32 duplex apartments, 2BD/2BA) - Parking: 165 spaces Vacancy and Rental Status35% of the prime commercial space (about 10,000 SF) was vacant and not marketed for rent online. 13 of the 32 duplex apartments were rented at 35% discount to comps What made you interested in investing in this type of deal?

Note investors who think learning from people who scam others out of millions is a good idea and a way to have a good reputation in the space. 

Property Details- Size: 64,000 SF Class A mixed-use building - Commercial Space: 25,000 SF - Residential Space: 39,000 SF (32 duplex apartments, 2BD/2BA) - Parking: 165 spaces Vacancy and Rental Status35% of the prime commercial space (about 10,000 SF) was vacant and not marketed for rent online. 13 of the 32 duplex apartments were rented at 35% discount to comps What made you interested in investing in this type of deal?

He received quotes to remove the texture ceiling, paint the interior, purchase and install new kitchen cabinets and counters (including completing the design), picked out 2 floorings to get quotes which will be provided this week, and determined furnace is beyond saving (I will likely get HVAC quote for him).  

However, this is a totally new space to me- Any advice for how to go about looking for a lawyer who works with individual investors and won't break the bank?

If you're going to rent the space or sell it as livable space, it will need to meet code.

I usually recommend clients a pretty easy cosmetic rehab which is refinish floors, replace cabinets with modern white ones, add a white stone, new appliances, new bathroom vanity/mirror/light fixture and add in unit laundry. 

It's a great way to give them a better sense of the space, especially if they're on the fence about booking.

You could always do a house hack in a multifamily space.