As you know there are hundreds of housing submarkets and conditions can simultaneously be different in different areas.
This is all being driven by demographics. The baby boomers are either retired or within 5-7 years of retirement.
I/we do not need a 2700 sq ft 4 bedroom house anymore.
The 30 somethings are not having kids. If they do they are having one or max two. They do not want a big house. Eliminate the formal dining room and the living room. That is also why formal dining room used furniture is WORTHLESS. You have to give away china cabinets now. Not as bad as a piano though.
You’re right. Housing, like politics, it’s local.