Middle-income households are being squeezed out of the market, even as listing inventory rebounds from its post-pandemic lows.