I wouldn't do just a condo. you could build your own triplex and convert to condos as a "development partner" or on your own if you aren't experienced and full return of capital. my suggestion would be to invest near the urban core over suburban deals and avoid older housing stock like columbus has more than 100 year old houses. anything pre 1950 I wouldn't touch 

Goal (in order of priority): 1) Convert upstairs of detached storage unit in back into 3 bed/2bath (for the downstairs, keep as garage on one side and rec room on other side), 2) convert detached garage in front into 1 bed/1bath for our grandma, and 3) eventually add a prefab home on the lot.From our research so far, I believe we'll have to do an SB 9 lot split in order to legally build all structures (but we're not sure if we want to do this now, or just convert the back unit into an ADU first then do SB 9 later).

Hello Beth, this is where the learning takes place, the more at-bats you have with this type of potential client gets you prepped and that is how you can convert more sales.

Jury is still out on the MTR which I converted from an STR.

As an example in a different real estate “product”, we owned a 70 unit motel that we had converted to mostly low income housing.  

I would probably keep the other house regardless of what I do because of the low interest rate.I am now wondering if I should hire a Qualified Intermediary (my realtor calls this an "Accomodater") so I have the option to buy a one level rental, stay where I am at, and if in the future I am unable to live in the two level home I am currently living in (our second home that is my primary residence), convert the rental to a primary residence.

Consider converting one property into an STR while retaining the others as LTRs to establish a stable income base, taking into account your willingness to manage STR responsibilities, local regulations, and financial projections for each property scenario.

I have a once triplex converted to a duplex that I’m turning back into a triplex . hope that didn’t get too confusing.So I’m trying to figure out the best way to supply all 3 units with sufficient hot water in the most economical way of course.

This could potentially add some cash flow to your house hacking position if you convert 1 or 2 of the units to that strategy.It sounds like you're handy enough to rehab some units if need be and/or do most minor maintenance, so you can cut down on that % reserve.Anyway, good luck man!

Assuming that you converted your property into a rental after you moved, you will still owe taxes on depreciation recapture, as explained by @Basit Siddiqi