It’s interesting to look at places like Westchester that were already upscale decades ago. Here’s the first listing I found in Scarsdale, NY, which has been an affluent Wall Street suburb forever: https://www.redfin.com/NY/Scarsdale/12-Stoneleigh-Rd-10583/h.... Sold for $645k in 2003 and $1.25 million this year. That’s 3% appreciation per year over the last 23 years. It’s exactly the rate of inflation.
Hudson Valley real estate is the best kept secret in the US. Plenty of places with good schools and a sub-1hr train commute to Manhattan can be had for under $500k still. Westchester is cooked, but add 15-30 mins north to your commute and it's still extremely accessible.