Housing affordability dynamics: New insights from the last decade