Comparative analysis of Rightmove, Halifax, ONS, and Nationwide house price indices for July 2025, including regional performance and market implications

UK house price, regional house prices, rents and yields

Explore the Nationwide House Price Index (HPI) — one of the UK's most trusted measures of housing market performance. View interactive charts, monthly data, and long-term property price trends from Nationwide Building Society.

The UK housing market continued to show significant regional variations in 2025, with London maintaining its position as the most expensive city for homebuyers. The average house price in the capital stood at ******* British pounds in February, nearly double the national average. However, the market dynamics are shifting, with London experiencing only a modest *** percent annual increase, while other cities like Belfast and Liverpool saw more substantial growth of over **** percent respectively. Affordability challenges and market slowdown Despite the continued price growth in many cities, the UK housing market is facing headwinds. The affordability of mortgage repayments has become the biggest barrier to property purchases, with the majority of the respondents in a recent survey citing it as their main challenge. Moreover, a rising share of Brits have reported affordability as a challenge since 2021, reflecting the impact of rising house prices and higher mortgage rates. The market slowdown is evident in the declining housing transaction volumes, which have plummeted since 2021. European context The stark price differences are mirrored in the broader European context. While London boasts some of the highest property prices among European cities, a comparison of the average transaction price for new homes in different European countries shows a different picture. In 2023, the highest prices were found in Austria, Germany, and France.

Explore the Halifax House Price Index (HPI) — one of the UK’s leading indicators of housing market trends. Interactive charts, drawdown data, and monthly updates from Halifax, part of Lloyds Banking Group.

Explore the official UK House Price Index (UK HPI) from HM Land Registry, ONS, and government partners. View interactive charts, monthly price data, and national and regional housing market trends across the UK.

Last updated on 22 Feb 2025

Introduction

This dataset provides comprehensive information on property sales in England and Wales, sourced from the UK government's HM Land Registry. Although the government site claims to update on the same day each month, actual updates can vary. To bridge this update variation gap, our fully automated ETL pipeline retrieves the official government data on a daily basis. This ensures that the dataset always reflects the most current transaction data available.

ETL Process

Our ETL (Extract, Transform, Load) process is designed to automate the data update and publishing workflow: 1. Extract:
The pipeline uses web scraping to retrieve the latest data from the official government website. This step is necessary as the site does not offer an API. 2. Transform:
Before loading the data, the ETL pipeline processes the dataset to ensure consistency and usability. As part of the transformation stage, the first column (Transaction_unique_identifier) is removed. This column is dropped during staging to focus on the most relevant transactional information. The column removal successfully reduces the data file size from almost 6GB to 3.1GB, and therefore will greatly increase the data analysis efficiency, and reduces the chance of kernal error/restart. 3. Load:
Finally, the transformed data is loaded into the dataset.

The transformed data is loaded into the dataset in two parts: - Complete Data (pp-complete.csv): This file encompasses all records from January 1995 to the present. The complete data file is replaced during each update to reflect any corrections or additional historical data. The first column is price. - Monthly Data: A separate monthly file is amended each month. This monthly archive ensures a complete record of updates over time, allowing users to track changes and trends more granularly.

Summary of Results

The dataset (pp-complete.csv) contains records of property sales dating back to January 1995, up to the most recent monthly data. It covers various types of transactions—from residential to commercial properties—providing a holistic view of the real estate market in England and Wales.

Column Descriptions

The original data includes the following columns: - Transaction_unique_identifier
- price
- Date_of_Transfer
- postcode
- Property_Type
- Old/New
- Duration
- PAON
- SAON
- Street
- Locality
- Town/City
- District
- County
- PPDCategory_Type
- Record_Status - monthly_file_only

Note: As part of the transformation process, the Transaction_unique_identifier column is removed from the final published pp-complete.csv data file. Therefore the first column of the pp-complete.csv file is price.

Address data Explanation - Postcode: The postal code where the property is located. - PAON (Primary Addressable Object Name): Typically the house number or name. - SAON (Secondary Addressable Object Name): Additional information if the building is divided into flats or sub-buildings. - Street: The street name where the property is located. - Locality: Additional locality information. - Town/City: The town or city where the property is located. - District: The district in which the property resides. - County: The county where the property is located. - Price Paid: The price for which the property was sold.

Legal and Ethical Considerations

Ownership and Attribution This dataset is the property of HM Land Registry and is released under the Open Government Licence (OGL). If you use or publish this dataset, you are required to include the following attribution statement:

>"Contains HM Land Registry data © Crown copyright and database right 2021. This data is licensed under the Open Government Licence v3.0."

Usage Guidelines

The data can be used for both commercial and non-commercial purposes.

The OGL does not cover third-party rights, which HM Land Registry is not authorized to license. For any other use of the Address Data, you must contact Royal Mail.

Suggested Usages

Market Trend Analysis: Understand the ups and downs of the property market over time. Investment Research: Identify potential areas for property investment. Academic Studies: Use the data for economic research and studies related to the housing market. Policy Making: Assist government agencies in making informed decisions regarding housing policies. Real Estate Apps: Integrate the data into apps that provide property price information services.

By using this dataset, you agree to abide by the terms and conditions as specified by HM Land Registry. Failure to do so may result in legal consequences.

Housing market: property sales based on Land Registry data, by district, from 1996 (quarterly) 1-5 Geographies: Local Authority District (LAD), Government Office Region (GOR), National Geographic coverage: England Type of data: Administrative data

House prices vary widely in the United Kingdom (UK), but housing in certain cities and counties is substantially pricier than in others. Surrey, for example, concentrated four of the most expensive towns to buy a home, including Virginia Water, Cobham, and Esher. With an average house price of over *********** British pounds as of June 2024, housing in these towns cost roughly **** times the national average. How did house prices change since the COVID-19 pandemic? Since the start of the coronavirus (COVID-19) pandemic, demand for housing has been especially high, causing house prices to soar. Among major UK cities, the house price increase was most prominent in Belfast, where it rose by *** percent in 2024. According to the UK House Price Index, the average annual house price increase on a national level was even higher. How long does it take to sell a house? With the demand for housing going strong and inventory running low, aspiring homeowners need to act faster than ever when making an offer on a home. The average number of days on market has continued shortening since the start of 2021 and was a little over a month as of October 2021. Surprisingly, selling a property took the longest in the UK’s most competitive market - London.

The data in this data set was provided by HM Treasury and details mortgage completions on properties supported by Help to Buy: mortgage guarantee completions, by local authority, England. The data set covers the period 8 October 2013 to 30 June 2014.

introduction

This dataset provides comprehensive information on property sales in England and Wales, as sourced from the UK government's HM Land Registry. It offers valuable insights into property transactions, including sale prices, locations, and types of properties sold. This dataset is particularly useful for analysts, researchers, and businesses looking to understand market trends, property valuations, and investment opportunities in the real estate sector of England and Wales.

Summary of Results

The dataset contains records of property sales dating back to January 1995, up to the most recent monthly data. It covers various types of transactions, from residential to commercial properties, providing a holistic view of the real estate market in England and Wales.

Column Descriptions

colnames=['Transaction_unique_identifier', 'price', 'Date_of_Transfer', 'postcode', 'Property_Type', 'Old/New', 'Duration', 'PAON', 'SAON', 'Street', 'Locality', 'Town/City', 'District', 'County', 'PPDCategory_Type', 'Record_Status - monthly_file_only' ]

Address data Explaination Postcode: The postal code where the property is located. PAON (Primary Addressable Object Name): Typically the house number or name. SAON (Secondary Addressable Object Name): Additional information if the building is divided into flats or sub-buildings. Street: The street name where the property is located. Locality: Additional locality information. Town/City:The town or city where the property is located. District: The district in which the property resides. County:The county where the property is located. Price Paid:The price for which the property was sold.

Legal and Ethical Considerations

Ownership and Attribution

This dataset is the property of HM Land Registry and is released under the Open Government Licence (OGL). If you use or publish this dataset, you are required to include the following attribution statement:

"Contains HM Land Registry data © Crown copyright and database right 2021. This data is licensed under the Open Government Licence v3.0."

Usage Guidelines

The data can be used for both commercial and non-commercial purposes.

The OGL does not cover third-party rights, which HM Land Registry is not authorized to license. For any other use of the Address Data, you must contact Royal Mail.

##Suggested Usages Market Trend Analysis: Understand the ups and downs of the property market over time. Investment Research: Identify potential areas for property investment. Academic Studies: Use the data for economic research and studies related to the housing market. Policy Making: Assist government agencies in making informed decisions regarding housing policies. Real Estate Apps: Integrate the data into apps that provide property price information services.

By using this dataset, you agree to abide by the terms and conditions as specified by HM Land Registry. Failure to do so may result in legal consequences.

Compare UK interest rates and mortgage rates alongside house prices. Interactive charts showing the Bank of England base rate versus 2-year, 5-year, and SVR mortgage rates, with historical HPI trends.

Purpose-built residential buildings are different by design compared to for sale residential buildings. They suggest more communal space and facilities that can be shared by the site residents. In 2019, retirement living was the largest segment in the operational (co-living) real estate sector with a market value of *** billion British pounds of investment in 2019. Purpose-built student accommodation (PBSA) was the segment with the largest investment volume in 2018.

Needham Market, Suffolk property and local residence statistical data. View in-depth data for Needham Market & surrounding areas.

Market Harborough Great Bowden & Arden, Leicestershire property and local residence statistical data. View in-depth data for Market Harborough Great Bowden & Arden & surrounding areas.

Wickham Market, Suffolk property and local residence statistical data. View in-depth data for Wickham Market & surrounding areas.

Market Harborough Little Bowden, Leicestershire property and local residence statistical data. View in-depth data for Market Harborough Little Bowden & surrounding areas.

Mildenhall Kingsway & Market, Suffolk property and local residence statistical data. View in-depth data for Mildenhall Kingsway & Market & surrounding areas.

North Walsham Market Cross, Norfolk property and local residence statistical data. View in-depth data for North Walsham Market Cross & surrounding areas.