How long has this asset been on the market and why are they selling?

You will subject to the lending market at the time near to the balloon expiration.I would negotiate for the recurring option to extend the loan an additional year at the cost of a 0.75% rate increase.

So, as an example, if you look today and you see that various sources lead you to believe that you can rent it for $1500/ month, that number can change quickly in a week (let alone 3 months) based on other factors in your local area - such as a similar property suddenly gets put on the market for rent.In addition, there are different ways to approach your rental amount. 

Does Central Ma have a decent market to start looking for deal for BRRRR?

Cody sure knows marketing as I am now in his marketing funnel and have had 1 conversation with his sales department.

Are there any tools/strategies to calculate a high appreciation market vs high cash flow market?   

But I would not be surprised a bit to learn that more than 3 of every 4 Wholesalers may not have survived the major market change that took place in the post-Covid years.

Review all househack/multifamily listings that come on the market so you can get a sense of the inventory. 

In general I find national firms especially the big boys, the CBREs, JLLs, etc of the world tend to have exponentially higher valuations on listings than the market will actually pay. 

When interest rates went up, I was having to leave too much capital in deals in my target market, usually more than my acquisition outlay and rent-ready repairs.