A rising tide lifts all boats. 

As the questions rise, I will absolutely be reaching out to the BP community.

Even with multiple units, with current interest rates and a competitive market (prices have continued to rise even with higher interest rates) think the Madison market is a stronger long term ownership strategy, where the bulk of your return will come when you sell from appreciation in rents and property value. 

From my research Poughkeepsie looks like an area on the rise. 

I don't know if this is a recent trend that's come about with the rise in popularity of laundromats, but I've noticed more "fix & flip" situations on the market - mats being sold by owners who have owned for 1-3 years and put some significant improvements in.

How come data driven method did not see that construction costs will only rise?

I always ask the question of a new investor: "Do you want to go the traditional route and pay 20% down for a property that cash flows $100 to $200 a month" which is relatively easy to do and buy 1 house and then wait a couple of years until you have enough for the next property, with rising real estate costsor "Do you want to learn how to buy multiple houses using Creative Finance that cash flow $300 - $500 a month with no limit on the number of houses you can buy" but requires learning how and taking advantage of the rising real estate values?

I’m not sure if the metric has changed much with inflation and rising costs but I’ve repeatedly heard that $200 per door is a good cash flow.

A duplex or SFH purchased around that time would likely have appreciated by 5-10%, depending on the neighborhood, and rents in Oceanside and Carlsbad have continued to rise steadily, offering a solid ROI.One client I worked with last year ran into similar frustrations with bidding wars.

I think the most interesting trend I've seen in the last 25 years has been the rise of good realtors like yourself who understand the power of the 1031.