If you do the work on the front end, you can save all those taxes paid and get some additional benefits from holding the properties, and still achieve your freedom level. 

Depending on the LTV, FICO and PPP you may achieve a low 7% rate on a 30 yr fixed loan 

This assumes the market rent for the unit I will be moving into.My goals from entering real estate are 1. add diversification in my investments (right now heavily invested in stocks) and 2. house hack, so that tenants pay part of the mortgageIn my current market, I have two options: a. buy older houses, renovate, bring the rent to market --> this will cashflow, but needs a lot of time investment which I don't haveb. buy turnkey properties: --> renovated and already occupied by tenants but may not be cash flow positive.I found a property that's type B.

Being able to host 6-8 guests over 4-6 would be a smaller 2 bedroom unit.   I

Yep as said above, DSCR is typically the way to still achieve 30 year amortization, fixed rate at 75-85 LTV. 

I’m looking for advice on how to setup a structured partnership with my in-laws so that both parties achieve their goals.

Purchase price: $171,000 Cash invested: $34,000 Bought a 2 unit as a househack, living in the upper and renting out the lower unit. I

If the 2-4 unit is inferior and the home they are leaving is superior bigger in sqft/gla it usually gets flagged.

Quote from @Brooke Roundy: I have a four unit building in Cleveland, one unit is an STR listed on Airbnb and the rest are LTRs.

I looked at almost every market in florida before I relocated from columbus ohio because miami Dade County has the most net migrations in the entire United States for one county. we build it in columbus ohio and it is worth approx 215k a door but down here all you'd have to do is change the assemblies and in miami that triplex would be worth more than 300k per door so closer to 900k depending on where you built it. new construction single family homes are going for around 330 per sq ft in the same area and a triplex is considered residential. by building codes a 4 unit is commercial I'd recommend 3 unit first or going as many units as possible if you have backing or your own cash. for each one we do we recommend 100k of liquidity.