Marcus: two cashflow plays and one house hack, as we discussed. The Lowell house is the one I'd move on. Rank them, say what you think, and message Jordan about any one.
Not in the right order?
The one to buy if you plan to live in it. Strongest street of the three, strongest appreciation story, and the basement apartment pays most of the mortgage. Move fast; it will not last the weekend.
Strongest long-term cashflow of the three at the lowest price, and the only one where short-term rental is allowed by right. The plumbing is the known cost; everything else is cosmetic.
Under contract at $560K. The transferable STR license is rare and worth the premium; the foundation letter is the only contingency that matters.