We have a house in the neighborhood who's owner recently passed.

I do like the efficiency of pricelabs in terms of easily monitoring your comps (if you use the Neighborhood tab and load in your comps)

Even though they are the expert, you still need to ensure they fit you well.

Multifamily pricing is really high in the A and B neighborhoods around Scottsdale and Phoenix.

I would research and drill down what is required from each and see if it even fits you.

I'm in the midst of renovating a property in a high end neighborhood.

I may have more strict requirements for my operations today but just means I need to look around more for a market that fits my current position. 

I plan on expanding to a PPC budget very soon.For BP, my goal is to not only learn and connect with any and everyone but also contribute wherever I see fit.

Given this is first investment, I would like to keep it local.Any suggestions on neighborhood with good rental cash flow in Middlesex county ?

I generally rule out most single family homes as viable rentals, as prices are pretty high relative to rents, so aside from some downtown neighborhoods, typically you do not find large areas of single family rental neighborhoods (a median sale price on a 3 bed, 2 bath home so far this year in Dane County on MLS sales data is at $430k).