The borough with the highest property prices in London, Kensington and Chelsea, had an average price for a flat that was about ******* British pounds higher than the London average. London is the most populous metropolitan area in the UK, and living in it comes with a price tag. Unsurprisingly, the most expensive boroughs in terms of real estate prices are located in the heart of the metropolis: Kensington and Chelsea, the City of Westminster, and the City of London. In Kensington and Chelsea, home to several museums such as the Natural History Museum, the Victoria and Albert Museum, and the Science Museum, as well as galleries and theaters, the average price of apartments was over a million British pounds. How have residential property prices developed in recent years? The average house price in England declined slightly in 2023 after increasing year-on-year since 2008. The housing market in Wales also experienced a mild correction, but prices in Scotland and Northern Ireland continued to grow. Since 2015, the base year of the UK House Price Index, house prices in London have risen by over ** percent. In London, the cost of a flat decreased by *** percent year-on-year as of June 2024. However, some of the most expensive boroughs recorded a decline of over ** percent. Are residential property prices in London expected to grow in the future? Despite property prices declining in 2023, the market is forecast to continue to grow in the next five years, according to a March 2023 forecast. Some of the reasons for this are the robust demand for housing, the chronic shortage of residential properties and the anticipated decline in mortgage interest rates.

Update 29-04-2020: The data is now split into two files based on the variable collection frequency (monthly and yearly). Additional variables added: area size in hectares, number of jobs in the area, number of people living in the area.

Context

I have been inspired by Xavier and his work on Barcelona to explore the city of London! 🇬🇧 💂

Content

The datasets is primarily centered around the housing market of London. However, it contains a lot of additional relevant data: - Monthly average house prices - Yearly number of houses - Yearly number of houses sold - Yearly percentage of households that recycle - Yearly life satisfaction - Yearly median salary of the residents of the area - Yearly mean salary of the residents of the area - Monthly number of crimes committed - Yearly number of jobs - Yearly number of people living in the area - Area size in hectares

The data is split by areas of London called boroughs (a flag exists to identify these), but some of the variables have other geographical UK regions for reference (like England, North East, etc.). There have been no changes made to the data except for melting it into a long format from the original tables.

Acknowledgements

The data has been extracted from London Datastore. It is released under UK Open Government License v2 and v3. The underlining datasets can be found here: https://data.london.gov.uk/dataset/uk-house-price-index https://data.london.gov.uk/dataset/number-and-density-of-dwellings-by-borough https://data.london.gov.uk/dataset/subjective-personal-well-being-borough https://data.london.gov.uk/dataset/household-waste-recycling-rates-borough https://data.london.gov.uk/dataset/earnings-place-residence-borough https://data.london.gov.uk/dataset/recorded_crime_summary https://data.london.gov.uk/dataset/jobs-and-job-density-borough https://data.london.gov.uk/dataset/ons-mid-year-population-estimates-custom-age-tables

Cover photo by Frans Ruiter from Unsplash

Inspiration

The dataset lends itself for extensive exploratory data analysis. It could also be a great supervised learning regression problem to predict house price changes of different boroughs over time.

This statistic shows the average price of flats and maisonettes in the Greater London (United Kingdom) from the first quarter of 2012 to the fourth quarter of 2015, according to the Halifax house price index. In the fourth quarter of 2014, the average price of a flat or maisonettes in Greater London was 329.9 thousand British pounds (GBP). By the end of the fourth quarter of 2015, the price increased to 385.3 thousand GBP.

The average price of houses bought by first-time buyers was notably lower than houses purchased by repeat buyers in London in 2023. Homebuyers spent on overage 383,000 British pounds when purchasing their first property in 2023. For repeat buyers, this figure amounted to 657,000 British pounds in that year. In London, the average house price was about 590,000 British pounds in 2023.

Analysis of ‘Housing Prices in London’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/arnavkulkarni/housing-prices-in-london on 28 January 2022.

--- Dataset description provided by original source is as follows ---

Content

This dataset comprises of various house listings in London and neighbouring region. It also encompasses the parameters listed below, the definitions of which are quite self-explanatory. • Property Name • Price • House Type - Contains one of the following types of houses (House, Flat/Apartment, New Development, Duplex, Penthouse, Studio, Bungalow, Mews) • Area in sq ft • No. of Bedrooms • No. of Bathrooms • No. of Receptions • Location • City/County - Includes London, Essex, Middlesex, Hertfordshire, Kent, and Surrey. • Postal Code

Inspiration

This dataset has various parameters for each house listing which can be used to conduct Exploratory Data Analysis. It can also be used to predict the house prices in various regions of London by means of Regression Analysis or other learning methods.

--- Original source retains full ownership of the source dataset ---

The monthly house price index in London has been steadily increasing in recent years. In June 2024, the index reached 129.9, up from 129 a year before. Nevertheless, prices widely varied in different London boroughs, with Kensington and Chelsea being the priciest boroughs for an apartment purchase.

According to the forecast, house prices in London are expected to fall slightly in 2024, followed by a recovery in the following years. The decline can be explained with the cost of living crisis and the dramatic increase in borrowing costs. As the economy recovers in the next five-years, house prices for mainstream properties are forecast to rise by almost ** percent. In 2023, the average house price in London ranged between ******* British pounds and *** million British pounds, depending on the borough. Barking and Dagenham, Bexley, Newham, and Croydon were some of the most affordable boroughs to buy a house.

This statistic illustrates the monthly average rental price for one bedroom apartment in a new development in 2013, by London boroughs. By far the most expensive boroughs in London with respect to monthly rental of new apartments were Camden, with ***** British pounds (GBP) monthly per one bedroom flat and Westminster, with ***** GBP. For comparison, London-wide average monthly rental price for one bedroom new apartment was ***** GBP in 2013.

Through reading this publication you will:

• gain an understanding of how house prices are set in economics terms, how they are measured, and why the cost of housing matters for London’s economy and its residents

• see whether incomes and earnings in London have kept pace with the costs of home ownership in London, and see how affordability may be affected by future changes in interest rates

• find out about the drivers of demand for residential property in London, and how the supply of homes has responded to changing conditions

This page is no longer being updated. Please use the UK House Price Index instead.

Mix-adjusted house prices, by new/pre-owned dwellings, type of buyer (first time buyer) and region, from February 2002 for London and UK, and average mix-adjusted prices by UK region, and long term Annual House Price Index data since 1969 for London.

The ONS House Price Index is mix-adjusted to allow for differences between houses sold (for example type, number of rooms, location) in different months within a year. House prices are modelled using a combination of characteristics to produce a model containing around 100,000 cells (one such cell could be first-time buyer, old dwelling, one bedroom flat purchased in London). Each month estimated prices for all cells are produced by the model and then combined with their appropriate weight to produce mix-adjusted average prices. The index values are based on growth rates in the mix-adjusted average house prices and are annually chain linked.

The weights used for mix-adjustment change at the start of each calendar year (i.e. in January). The mix-adjusted prices are therefore not comparable between calendar years, although they are comparable within each calendar year. If you wish to calculate change between years, you should use the mix-adjusted house price index, available in Table 33.

The data published in these tables are based on a sub-sample of RMS data. These results will therefore differ from results produced using full sample data. For further information please contact the ONS using the contact details below.
House prices, mortgage advances and incomes have been rounded to the nearest £1,000.
Data taken from Table 2 and Table 9 of the monthly ONS release.

Download from ONS website

Median price paid for residential property in England and Wales, for all property types by lower layer super output area. Annual data..

Median price paid for residential property in England and Wales by property type and electoral ward. Annual data.

Median price paid for residential property in England and Wales, by property type and administrative geographies. Annual data.

Graph and download economic data for Housing Inventory: Median Listing Price per Square Feet Year-Over-Year in London, KY (CBSA) (MEDLISPRIPERSQUFEEYY30940) from Jul 2017 to Dec 2024 about London, square feet, KY, listing, median, price, and USA.

Housing Index in the United Kingdom decreased to 511.60 points in June from 511.80 points in May of 2025. This dataset provides - United Kingdom House Price Index - actual values, historical data, forecast, chart, statistics, economic calendar and news.

Graph and download economic data for All-Transactions House Price Index for New London County, CT (ATNHPIUS09011A) from 1977 to 2024 about New London County, CT; Norwich; CT; HPI; housing; price index; indexes; price; and USA.

This dataset provides information about the number of properties, residents, and average property values for Price Road cross streets in London, AR.

Graph and download economic data for Housing Inventory: Median Listing Price Month-Over-Month in New London County, CT (MEDLISPRIMM9011) from Jul 2017 to Dec 2024 about New London County, CT; Norwich; CT; listing; median; price; and USA.

An experimental price index tracking the prices paid for renting property from private landlords in the United Kingdom