Prices in metros that were once affordable are climbing and increasingly pricing out buyers from the market. Inflation, now at a nearly four-decade high, is worsening the impact.