You already have shown you're extreme penny-pinchers just by the fact you're a DIY.

I think the difficult part with your advice is that New England multi family market is extremely competitive so going after something worth 1M might be risky because people are just through junk out with a price tag and the CF doesn’t mAtch up all the time.

Ideally buying out the third partner's interest would not trigger a 'sale' and a change in the basis for the remaining two partners. 

This will require the seller to be extremely motivated, and to place A LOT of trust in you.

Purchase 1-2 motorhomes and rent them out through outdoorsy type hosted sites (yes I am aware that this will never appreciate  and will depreciate quickly) these do extremely well where we live.Thank you for reading and responding, my wife and I appreciate your time! 

Someone that knows rents, knows their market extremely well and someone that knows how to win offers in this crazy market.  

Airdna lists revenue growth potential as being extremely low, and I tend to agree with them.

This will not trigger "due on sale" clauses. 

I can explain why in more detail if you like to talk about it.All good questions but please be careful not to fall into the "analysis - paralysis trap".I recommend getting support from a mentor and together developing an action plan rather than aiming to learn everything yourself before you pull the trigger on the first deal.

Construction in this area is just extremely expensive.