The price of terraced housing in Bromley rose by *** percent year-on-year in May 2025, making it the borough with the highest price increase in London. At about ******* British pounds, the most affordable borough in London to purchase a terraced house was Barking and Dagenham. The same borough also had the cheapest average price for semi-detached homes in London.

The house price index in London reached 99.1 index points in May 2025, which was an increase of 2.2 percent year on year. The house price index (HPI) is an easy way of illustrating trends in the house sales market and help simplify house purchase decisions. By using hedonic regression, the index models property price data for all dwellings and shows how much the price has changed since January 2023. Average house prices in Londnon boroughs Location plays a huge role in the price of a home. Kensington and Chelsea and City of Westminster are undoubtedly the most expensive boroughs in London, with an average house price that can exceed one million British pounds. In comparison, a house in Barking and Dagenham cost approximately one third. Nevertheless, the housing market is the busiest in the boroughs with average house prices. How have regional house prices in the UK developed? House prices in other UK regions have risen even more than in London. In Northern Ireland, the house price index reached nearly 120 index points in May 2025, ranking it among the regions with the highest property appreciation. The UK house price index stood at 103 index points, suggesting an increase of 51 percent since 2015.

The average price of a detached house in Kensington and Chelsea, London's most expensive borough, increased by ****percent year-on-year in May 2025. Homebuyers spent on average approximately *****million British pounds to buy a detached house in Kensington and Chelsea. Detached houses are those that are not attached to any other dwellings. Finding such property available for purchase in London is not only hard but out of reach for the vast majority.

Art Presence & Property Prices in London

Quantifying the Relationship with Online Data

By [source]

About this dataset

This dataset explores the potential relationship between art presence and property prices in London neighborhoods. We conducted an analysis to investigate this by measuring the proportion of Flickr photographs with the keyword ‘art’ attached. We then compared that data to residential property price gains for each Inner London neighborhood, seeking out any associations or correlations between art presence and housing value. Our findings demonstrate the impact of aesthetics on neighborhoods, illustrating how visual environment influences socio-economic conditions. With this dataset, we aim to show how online platforms can be leveraged for quantitative data collection and analysis which can visualize these relationships so as to better understand our urban settings

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset can be used to investigate the relationship between art presence and property prices in London neighborhoods. The dataset includes three columns – Postcode.District, Rank.Mean.Change, and Proportion.Art.Photos – which provide quantitative analyses of the association between art presence and price gains for London neighborhoods.

To use this dataset, first identify the postcode district for which you wish to access data by referencing a street list or PostCodeSearcher website that outlines postcodes for each neighborhood in London(http://postcodesearcher.com/london). This will allow you to easily find properties within each neighborhood as there are specific postcode districts that demarcate boundaries of particular areas (for example W2 covers Bayswater).

Once you have identified a postcode district of interest, review the ‘Rank.Mean Change’ column to explore how residential property prices have changed relative to other areas in Inner London since 2010-13 using fractions (1 = highest gain; 25 = lowest gain). Focusing on one particular location will also provide an idea about their current pricing level compared with others in order to evaluate whether further investment is worthwhile or not based on its past history of growth rates . It is important to note that higher rank numbers indicate higher price gains while lower rank numbers indicate lower price gains relative with respect from 2010-13 timeframe therefore comparing these values across many neighborhoods gives an indication as what area offers more value growth wise over given time period..

Finally pay attention how much did art contributes as far change in property price goes? To answer this question , review ‘Proportion Art Photos’ column which provides ratio of Flickr photographs associated with keyword 'art' attached within given regions helps identify visual characteristics within different localities.. Comparing proportions across various locations provide detail information regarding how much did share visual aesthetic characterstics impacts change in pricings accross different region.. For example it can give us further understandings if majority photographs are made up of urban landscape , abstracts or simply portrait presences had any role play when we look at relativity gains over past few years? Such comparisons help inform our understanding about potential impact art presence can have on changes stay relatively stable even during volatile market times..

By combining this data with other datasets related to demographics, infrastructure and socioeconomics present within londons different areas we can gain further insight which then allows us making informed decisions when it comes investing particular locations .

Research Ideas

• Use this dataset to develop a predictive analytics model to identify areas in London most likely to experience an increase in residential property prices associated with the presence of art.
• Use this dataset to develop strategies and policies that promote both artistic expression and urban development in Inner London neighborhoods.
• Compare the presence of art across inner London boroughs, as well as against other cities, to gain insight into the socio-economic conditions related to the visual environment of a city and its impact on life quality for citizens

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

**License: [CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication](https://creativecommons.org/publicd...

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 Power BI project analyzes London housing data to uncover patterns and trends in pricing, borough-wise distribution, affordability, and market growth over time. The dashboard is designed for anyone interested in property investment, urban planning, or simply understanding how the London housing market behaves.

✅ Key Features:

📍 Borough-wise Price Distribution Understand how average property prices vary across different London boroughs.

📈 Trend Analysis Visualize long-term price trends with dynamic line and area charts to observe how the market has evolved over time.

🧮 Affordability Index A calculated metric to measure housing affordability based on price vs income estimations.

🏘️ Property Type Breakdown Interactive visuals showing trends across Flats, Detached, Semi-Detached, and Terraced houses.

🗓️ Time Filters & Slicers Easily filter by year, month, or borough to explore specific time periods or locations.

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

This table shows the average House Price/Earnings ratio, which is an important indicator of housing affordability. Ratios are calculated by dividing house price by the median earnings of a borough.

The Annual Survey of Hours and Earnings (ASHE) is based on a 1 per cent sample of employee jobs. Information on earnings and hours is obtained in confidence from employers. It does not cover the self-employed nor does it cover employees not paid during the reference period. Information is as at April each year. The statistics used are workplace based full-time individual earnings.

Land Registry housing data are for the first half of the year only, so that they comparable to the ASHE data which are as at April.
Prior to 2006 data are not available for Inner and Outer London.

The lowest 25 per cent of prices are below the lower quartile; the highest 75 per cent are above the lower quartile.
The "lower quartile" property price/income is determined by ranking all property prices/incomes in ascending order.
The 'median' property price/income is determined by ranking all property prices/incomes in ascending order. The point at which one half of the values are above and one half are below is the median.

Regional data has not been published by DCLG since 2012. Data for regions has been calculated by the GLA. Data for 2014 has been calculated by the GLA.

Link to DCLG Live Tables

🇬🇧 United Kingdom English This table shows the average House Price/Earnings ratio, which is an important indicator of housing affordability. Ratios are calculated by dividing house price by the median earnings of a borough. The Annual Survey of Hours and Earnings (ASHE) is based on a 1 per cent sample of employee jobs. Information on earnings and hours is obtained in confidence from employers. It does not cover the self-employed nor does it cover employees not paid during the reference period. Information is as at April each year. The statistics used are workplace based full-time individual earnings. Pre-2013 Land Registry housing data are for the first half of the year only, so that they are comparable to the ASHE data which are as at April. This is no longer the case from 2013 onwards as this data uses house price data from the ONS House Price Statistics for Small Areas statistical release. Prior to 2006 data are not available for Inner and Outer London. The lowest 25 per cent of prices are below the lower quartile; the highest 75 per cent are above the lower quartile. The "lower quartile" property price/income is determined by ranking all property prices/incomes in ascending order. The 'median' property price/income is determined by ranking all property prices/incomes in ascending order. The point at which one half of the values are above and one half are below is the median. Regional data has not been published by DCLG since 2012. Data for regions has been calculated by the GLA. Data since 2014 has been calculated by the GLA using Land Registry house prices and ONS Earnings data. Link to DCLG Live Tables An interactive map showing the affordability ratios by local authority for 2013, 2014 and 2015 is also available.

📹Project Video available on YouTube - https://youtu.be/q-Omt6LgRLc

🖇️Connect with me on LinkedIn - https://www.linkedin.com/in/rohit-grewal

London Housing Price Dataset

The dataset contains housing market information for different areas of London over time. It includes details such as average house prices, the number of houses sold, and crime statistics. The data spans multiple years and is organized by date and geographic area.

This data is available as a CSV file. We are going to analyze this data set using the Pandas DataFrame.

Using this dataset, we answered multiple questions with Python in our Project.

Q. 1) Convert the Datatype of 'Date' column to Date-Time format.

Q. 2.A) Add a new column ''year'' in the dataframe, which contains years only.

Q. 2.B) Add a new column ''month'' as 2nd column in the dataframe, which contains month only.

Q. 3) Remove the columns 'year' and 'month' from the dataframe.

Q. 4) Show all the records where 'No. of Crimes' is 0. And, how many such records are there ?

Q. 5) What is the maximum & minimum 'average_price' per year in england ?

Q. 6) What is the Maximum & Minimum No. of Crimes recorded per area ?

Q. 7) Show the total count of records of each area, where average price is less than 100000.

Enrol in our Udemy courses : 1. Python Data Analytics Projects - https://www.udemy.com/course/bigdata-analysis-python/?referralCode=F75B5F25D61BD4E5F161 2. Python For Data Science - https://www.udemy.com/course/python-for-data-science-real-time-exercises/?referralCode=9C91F0B8A3F0EB67FE67 3. Numpy For Data Science - https://www.udemy.com/course/python-numpy-exercises/?referralCode=FF9EDB87794FED46CBDF

These are the main Features/Columns available in the dataset :

1) Date – The month and year when the data was recorded.

2) Area – The London borough or area for which the housing and crime data is reported.

3) Average_price – The average house price in the given area during the specified month.

4) Code – The unique area code (e.g., government statistical code) corresponding to each borough or region.

5) Houses_sold – The number of houses sold in the given area during the specified month.

6) No_of_crimes – The number of crimes recorded in the given area during the specified month.

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

The average price of a semi-detached house in Camden, London's third most expensive borough, increased by *** percent year-on-year in May 2025. Despite a decline of ****percent, Hammersmith and Fulham saw some of the most expensive semi-detached homes prices in London. At the other end of the spectrum was Barking and Dagenham - the most affordable and only borough where homebuyers could purchase a property for under ******* British pounds. Semi-detached homes are those that were built as one of two properties that share a common wall.

Summary statistics for housing transactions by local authority in England and Wales, on an annual basis, updated quarterly using HM Land Registry Price Paid Data. Select values from the Year and Month dimensions for data for a 12-month period ending that month and year (e.g. selecting June and 2018 will return the twelve months to June 2018).

FOCUSONLONDON2011: HOUSING:AGROWINGCITY With the highest average incomes in the country but the least space to grow, demand for housing in London has long outstripped supply, resulting in higher housing costs and rising levels of overcrowding. The pressures of housing demand in London have grown in recent years, in part due to fewer people leaving London to buy homes in other regions. But while new supply during the recession held up better in London than in other regions, it needs to increase significantly in order to meet housing needs and reduce housing costs to more affordable levels. This edition of Focus on London authored by James Gleeson in the Housing Unit looks at housing trends in London, from the demand/supply imbalance to the consequences for affordability and housing need. PRESENTATION: How much pressure is London’s popularity putting on housing provision in the capital? This interactive presentation looks at the effect on housing pressure of demographic changes, and recent new housing supply, shown by trends in overcrowding and house prices. Click on the start button at the bottom of the slide to access. View Focus on London - Housing: A Growing City on Prezi FACTS: Some interesting facts from the data… ● Five boroughs with the highest proportion of households that have lived at their address for less than 12 months in 2009/10:

FOCUSON**LONDON**2011: HOUSING:A**GROWING**CITY

With the highest average incomes in the country but the least space to grow, demand for housing in London has long outstripped supply, resulting in higher housing costs and rising levels of overcrowding. The pressures of housing demand in London have grown in recent years, in part due to fewer people leaving London to buy homes in other regions. But while new supply during the recession held up better in London than in other regions, it needs to increase significantly in order to meet housing needs and reduce housing costs to more affordable levels.

This edition of Focus on London authored by James Gleeson in the Housing Unit looks at housing trends in London, from the demand/supply imbalance to the consequences for affordability and housing need.

REPORT:

Read the report in PDF format.

https://londondatastore-upload.s3.amazonaws.com/fol/fol11-housing-cover-thumb.jpg" alt="">

PRESENTATION:

How much pressure is London’s popularity putting on housing provision in the capital? This interactive presentation looks at the effect on housing pressure of demographic changes, and recent new housing supply, shown by trends in overcrowding and house prices. Click on the start button at the bottom of the slide to access.

View Focus on London - Housing: A Growing City on Prezi

HISTOGRAM:

This histogram shows a selection of borough data and helps show areas that are similar to one another by each indicator.

Histogram

MOTION CHART:

This motion chart shows how the relationship, between key housing related indicators at borough level, changes over time.

Motion Chart

MAP:

These interactive borough maps help to geographically present a range of housing data within London, as well as presenting trend data where available.

MAP

DATA:

All the data contained within the Housing: A Growing City report as well as the data used to create the charts and maps can be accessed in this spreadsheet.

FACTS:

Some interesting facts from the data…

● Five boroughs with the highest proportion of households that have lived at their address for less than 12 months in 2009/10:

1. Westminster – 19 per cent
2. Wandsworth – 17 per cent
3. Camden – 16 per cent
4. Lambeth – 14 per cent
5. Southwark – 13 per cent

-31. Harrow – 6 per cent

-32. Havering – 5 per cent

● Five boroughs with the highest percentage point increase between 2004 and 2009 of households in the ‘private rented’ sector:

1. Newham – 17 per cent
2. Greenwich – 11 per cent
3. Enfield – 10 per cent
4. Camden – 9 per cent
5. Harrow – 8 per cent

-32. Islington – 1 per cent

-33. Bexley – 1 per cent

● Five boroughs with the highest percentage difference in median house prices between 2007 Q4 and 2010 Q4:

1. Kensington & Chelsea – 29 per cent
2. Westminster – 19 per cent
3. Camden – 15 per cent
4. Islington – 14 per cent
5. Southwark – 10 per cent

-31. Newham – down 9 per cent

-32. Barking & D’ham – down 9 per cent

The monthly house price index in London has increased since 2015, albeit with fluctuation. In August 2025, the index reached 99.1, which is a slight decrease from the same month in 2024. Nevertheless, prices widely varied in different London boroughs, with Kensington and Chelsea being the priciest boroughs for an apartment purchase.

The borough with the highest property prices in London, Kensington and Chelsea, had an average price for a flat exceeding *** million British pounds. 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 have risen notably over the past decade, despite a slight decline in 2023. While London continues to be the hottest market in the UK, price growth in the capital has moderated. Conversely, prices in the more affordable cities, such as Belfast and Liverpool, have started to rise at a faster pace. Are residential property prices in London expected to grow in the future? Despite property prices declining in 2024, the market is forecast to continue to grow in the next five years, according to a October 2024 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.

The ward profiles and ward atlas provide a range of demographic and related data for each ward in Greater London. They are designed to provide an overview of the population in these small areas by presenting a range of data on the population, diversity, households, life expectancy, housing, crime, benefits, land use, deprivation, and employment. Indicators included here are population by age and sex, land area, projections, population density, household composition, religion, ethnicity, birth rates (general fertility rate), death rates (standardised mortality ratio), life expectancy, average house prices, properties sold, housing by council tax band, tenure, property size (bedrooms), dwelling build period and type, mortgage and landlord home repossession, employment and economic activity, Incapacity Benefit, Housing Benefit, Household income, Income Support and JobSeekers Allowance claimant rates, dependent children receiving child-tax credits by lone parents and out-of-work families, child poverty, National Insurance Number registration rates for overseas nationals (NINo), GCSE results, A-level / Level 3 results (average point scores), pupil absence, child obesity, crime rates (by type of crime), fires, ambulance call outs, road casualties, happiness and well-being, land use, public transport accessibility (PTALs), access to public greenspace, access to nature, air emissions / quality, car use, bicycle travel, Indices of Deprivation, and election turnout. The Ward Profiles present key summary measures for the most recent year, using both Excel and InstantAtlas mapping software. This is a useful tool for displaying a large amount of data for numerous geographies, in one place. The Ward Atlas presents a more detailed version of the data including trend data and generally includes the raw numbers as opposed to percentages or rates. The Instant Atlas reports use HTML5 technology, which can be used in modern browsers, including on Apple machines, but will not function on older browsers. WARD ATLAS FOR 2014 BOUNDARIES In May 2014, ward boundaries changed in Hackney, Kensington and Chelsea, and Tower Hamlets. This version of the ward atlas gives data for these new wards, as well as retaining data on the unchanged wards in the rest of London for comparison purposes. Data for boroughs has also been included. Very few datasets have been published for the new ward boundaries, so the majority of data contained in this atlas have been modelled using a method of proportion of households from the old boundaries that are located in the new boundaries. Therefore, the data contained in this atlas are indicative only. OTHER SMALL AREA PROFILES Other profiles available include Borough, LSOA and MSOA atlases. Data from these profiles were used to create the Well-being scores tool. *The London boroughs are: City of London, Barking and Dagenham, Barnet, Bexley, Brent, Bromley, Camden, Croydon, Ealing, Enfield, Greenwich, Hackney, Hammersmith and Fulham, Haringey, Harrow, Havering, Hillingdon, Hounslow, Islington, Kensington and Chelsea, Kingston upon Thames, Lambeth, Lewisham, Merton, Newham, Redbridge, Richmond upon Thames, Southwark, Sutton, Tower Hamlets, Waltham Forest, Wandsworth, Westminster. These profiles were created using the most up to date information available at the time of collection (September 2015).

United States Median Home Sale Price: sa: All Residential: London, Y data was reported at 150.000 USD th in Jul 2020. This stayed constant from the previous number of 150.000 USD th for Jun 2020. United States Median Home Sale Price: sa: All Residential: London, Y data is updated monthly, averaging 115.000 USD th from Feb 2012 (Median) to Jul 2020, with 102 observations. The data reached an all-time high of 150.000 USD th in Jul 2020 and a record low of 60.000 USD th in Feb 2014. United States Median Home Sale Price: sa: All Residential: London, Y data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB057: Median Home Sale Price: by Metropolitan Areas: Seasonally Adjusted.

According to the forecast, house prices in London are expected to continue to increase until 2029. During the five-year period from 2025 to 2029, the house prices for mainstream properties are forecast to rise by **** 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.