Structurally, the property is in pretty good shape EXCEPT one problem that I cannot properly assess: the plumbing will not hold pressure.

This is a family property for which I will be paying 3/4 of the most recent assessment value.

Also , I would love to connect with any agents who specialize in STR market in Boston Mass area. airdna is pretty accurate . lenders use it to assess rental comps for short terms rentals when financing a short term rental  I use it for DSCR loans as well; it is accurate yet conservative because it gives you the median 50 percentile for the area based on comps.

This is a family property for which I will be paying 3/4 of the most recent assessment value.

Reward: Assess whether the uncertainty surrounding the current occupants, title clarity, and liens aligns with your risk tolerance.

I am trying to assess whether I should take it solo , leave it or scout an experienced partner.

Owners were charged an assessment (several thousand dollars) in 2023 to put into reserves, as per the new rules after the Surfside collapse.

It would be a good idea to assess your tolerance to risk and then plan something like that, but using a heloc is going to be around 9-11% in this market so to pay something off with lower interest rate to borrow more might not make much sense.

Given that I would pay 3/4 of the property's assessed value I think this could be a great opportunity.

Not questioning your judgement/assessment, just trying to understand the situation to best advise you.