The first is when people realize that without tax offsets the appetite for their real estate plummets. It’s already started at the high end and is working it’s way down to the standard northeast 4/3/2.5 suburbs.
The second reckoning will come after the tippping point of high income earners leave for low/no tax States like Florida and Nevada. What remains will be an eroded income tax base with decades of unfunded pension obligations. They’ll raise taxes further to compensate for the spread in a vicious cycle that will push out more of the tax base. Fun times ahead.