B.C. Housing Affordability

B.C. Housing Affordability is an open dataset from Government of British Columbia with 6 files (CSV, PDF, HTML); catalogue record updated 2026-08-26. On CanQuery you can open 3 CSV or Excel files as tables, filter, chart and export up to 10,000 rows as CSV and follow the original downloads.

Note: the best method to download the .csv file is to right click on the ‘Access/Download’ link on the box to the right, and then select ‘Save link as’ to download the .csv file directly. This data provides a quarterly overview of housing affordability for homeowners in B.C. and in its major cities (census metropolitan areas and census agglomerations). Housing affordability is measured using the Mortgage Payment Percent of Income (MPPI) which is calculated every quarter based on: • A hypothetical new home buyer earning the median after-tax income for the quarter • The median home sale price in a region • A 25-year variable-rate mortgage • The minimum down payment • The mortgage rate set at the average quarterly prime interest rate By combining home prices, income levels, and mortgage rates, the MPPI produces a full picture of housing affordability over time. A higher MPPI means it is less affordable to buy a home. For more information see: Summary Report: https://www2.gov.bc.ca/assets/gov/data/statistics/economy/building-permits/housing_affordability_bc_update.pdf Technical Note:…

Publisher

Government of British Columbia

Resources

6

Catalogue metadata updated

2026-08-26