The root cause for the low affordability seems to be that most people don't want to sell a house purchased at 3% interest and have to pay for a new one at 6%.
That and zoning restrictions too contribute for the lack of supply.
Anyhow, interest rates are the root cause now. Who in their right mind would do the trade I've described?