Tough to give an opinion without having some more info on the property, area, and of course who you're trying to appeal to with a waterfront property (yourself, potential renters...?)

that's a gift to the City.in WA state the purchase prices are higher, but so are the potential ARVs.go watch every single one of Tarl Yarber's YouTube videos on flipping and BRRRRing in WA and then come back here with questions.good luck

The involvement of onsite management, often seen as a potential red flag, can lead to the property failing crucial qualification tests.

Columbus offers a lot of potential for future growth with many big-tech companies either moving into the market or expanding their business here, which is contributing to rapid economic development.

Also, I only buy in areas with potential price appreciation in the future.

That said, I see a lot of potential for things to go wrong and get messy here.

My deal is a triplex with a potential Subject-To or anything else creative I can do.VA loan 2.6% 28 years left341k left on loanCurrent property value 400kmortgage is $2046Owner is going overseas in end of December and either needs to sell, do creative deal or get a property manager. 

It's not so hard to manage an LTR from close by but if you're thinking of being more than an hour away, you might also need to factor in PM costs which might take away from your potential cash flow. 

Will that revenue be divided evenly among the 7+ potential streams listed here?

This is potentially a win-win the seller gets a little cash and you get a property with clean title at a reduced cost.