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.

London Property Listings Dataset

Description

This dataset expands upon the original London Property Listings by including additional attributes to facilitate deeper analysis of rental properties in London. It is ideal for research and projects related to real estate trends, price categorization, and area-wise analysis in one of the world's busiest markets.

Dataset Features

• Price: Monthly rental price in GBP.
• Property Type: Classification of the property (e.g., Apartment, Flat).
• Bedrooms: Number of bedrooms in the property.
• Bathrooms: Number of bathrooms.
• Size: Property size in square feet (where available).
• Postcode: Postal code of the property location.
• Area: General area or neighborhood information.
• Price_Category: Categorization of prices into predefined ranges (e.g., Low, Medium, High).
• Area_Avg_Price: Average price of properties within the same area.

Potential Use Cases

• Price Analysis: Study how property attributes impact rental prices.
• Price Prediction Models: Utilize the dataset for machine learning tasks like regression and classification.
• Regional Insights: Compare rental trends across different neighborhoods.
• Categorical Analysis: Investigate trends within predefined price categories.

Data Summary

• Total Records: 29,537
• Total Attributes: 9
• Data Completeness: No missing values. All columns are fully populated.

Attribution

This dataset was prepared and uploaded by Mehmet Emre Sezer. It is intended for educational and non-commercial use.

This dataset contains detailed information about rental properties across various locations in the UK. The data was collected by scraping Rightmove, a popular real estate platform. Each entry in the dataset includes the property's address, subdistrict code, rental price, deposit amount, letting type, furnish type, council tax details, property type, number of bedrooms and bathrooms, size in square feet, average distance to the nearest train station, and the count of nearest stations.

Researchers and analysts interested in the UK rental market can utilize this dataset to explore rental trends, pricing variations based on location and property type, amenities preferences, and more. The dataset provides a valuable resource for machine learning models, statistical analysis, and market research in the real estate sector.

Metadata: Source: The data was collected by scraping the Rightmove real estate platform, a leading source for property listings in the UK. Date Range: The dataset covers rental property listings available during the scraping period. Geographical Coverage: Primarily focused on various locations across the UK, providing insights into regional rental markets. Data Fields: Address: The location of the rental property. Subdistrict Code: A code representing the subdistrict or area of the property. Rent: The monthly rental price in GBP (£) for the property. Deposit: The deposit amount required for renting the property. Let Type: Indicates whether the property is available for short-term or long-term rental. Furnish Type: Describes the furnishing status of the property (e.g., furnished, unfurnished, or flexible options). Council Tax: Information about the council tax associated with the property. Property Type: Specifies the type of property, such as apartment, flat, maisonette, etc. Bedrooms: The number of bedrooms in the property. Bathrooms: The number of bathrooms in the property. Size: The size of the property in square feet (sq ft). Average Distance to Nearest Station: The average distance (in miles) to the nearest train station from the property. Nearest Station Count: The count of nearest train stations within a certain distance from the property. Data Quality: The data may contain missing values or "Ask agent" placeholders, which require direct inquiry with agents or landlords for specific information. Potential Uses: The dataset can be used for market analysis, rental price prediction models, understanding property preferences, and exploring the impact of location and amenities on rental properties in the UK.

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.

Dataset Overview

This dataset provides a snapshot of properties listed for sale in London, sourced from the Rightmove website. It includes various property details such as the number of bedrooms, bathrooms, type of property, and price. The dataset is designed for educational purposes, offering insights into real estate trends and allowing data science enthusiasts to apply their skills in the context of property analysis.

Data Science Applications

This dataset is a valuable resource for students and researchers to practice various data science and analytics techniques. Potential applications include: - Exploratory Data Analysis (EDA): Understanding property distribution across London, price trends, and property types. - Price Prediction Models: Building machine learning models to estimate property prices based on available features. - Real Estate Trend Analysis: Analyzing trends in London’s real estate market, such as price fluctuations or differences in property features by neighborhood. - Text Analysis: Using the property descriptions for natural language processing (NLP) to extract keywords or sentiment related to property value or appeal.

Column Descriptions

• addedOn: Date when the property listing was added or updated on the website.
• title: Brief listing title describing the property, typically including the number of bedrooms and the location.
• descriptionHtml: Detailed description of the property, including features and potentially some promotional language.
• propertyType: Type of property, such as House, Terraced, or Detached.
• sizeSqFeetMax: Maximum size of the property in square feet, if provided.
• bedrooms: Number of bedrooms in the property.
• bathrooms: Number of bathrooms in the property.
• listingUpdateReason: Reason for updating the listing (e.g., new listing, price reduction).
• price: Price at which the property is listed for sale.

Ethically Mined Data

This dataset was ethically mined from a publicly accessible website using the APIFY API. All data in this dataset reflects publicly available information about properties listed for sale, with no Personally Identifiable Information (PII) included. The dataset does not include any data that could infringe on individual privacy.

Acknowledgements

• Data Source: Rightmove for providing publicly accessible real estate listings.
• Image Credit: Photo by Douglas Sheppard on Unsplash.

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 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.

Prices for prime residential real estate in Central London were expected to decline slightly in 2024, followed by a gradual increase until 2028, according to a *********** forecast. During the five-year period, the prices are forecast to rise by **** percent. In comparison, regional prime property prices and Outer London prime property prices are forecast to grow at a lower rate.

The house price dataset generated with 100 samples of houses in London. Each row of the DataFrame represents a single house and its features. The features of the houses in the dataset include:

Address: The address of the house, including the street name and number, as a string Square Footage: The total square footage of the house, as an integer Bedrooms: The number of bedrooms in the house, as an integer Bathrooms: The number of bathrooms in the house, as an integer Has Garden: A binary feature indicating whether the house has a garden or not, represented as 0 or 1 Has Garage: A binary feature indicating whether the house has a garage or not, represented as 0 or 1 Has Pool: A binary feature indicating whether the house has a pool or not, represented as 0 or 1 Has Gym: A binary feature indicating whether the house has a gym or not, represented as 0 or 1 Has Elevator: A binary feature indicating whether the house has an elevator or not, represented as 0 or 1 Has Fireplace: A binary feature indicating whether the house has a fireplace or not, represented as 0 or 1 Is Waterfront: A binary feature indicating whether the house is waterfront or not, represented as 0 or 1 Has Central Air: A binary feature indicating whether the house has central air or not, represented as 0 or 1 Is Renovated: A binary feature indicating whether the house is renovated or not, represented as 0 or 1 Has View: A binary feature indicating whether the house has a view or not, represented as 0 or 1 Price: The estimated price of the house, calculated based on the square footage, number of bedrooms, and number of bathrooms.

All of the features in the dataset are randomly generated, and the price is calculated based on simple formula that is not necessarily representative of the real world.

Summary of UK House Price Index (HPI) price statistics covering England, Scotland, Wales and Northern Ireland. Full UK HPI data are available on GOV.UK.

London Property Prices Dataset 200k+ records Overview This dataset offers a comprehensive snapshot of residential properties in London, capturing both historical and current market data. It includes property-specific information such as address, geographic coordinates, and various price estimates. Data spans from past transaction prices to present estimates for sale and rental values, making it ideal for real estate analysis, investment modeling, and trend forecasting.

Key Columns fullAddress: Complete address of the property. postcode: Postal code identifying specific areas in London. outcode: First part of the postcode, grouping properties into broader geographic zones. latitude & longitude: Geographic coordinates for mapping or location-based analysis. property details: Includes bathrooms, bedrooms, floorAreaSqM, livingRooms, tenure (e.g., leasehold or freehold), and propertyType (e.g., flat, maisonette). energy rating: Current energy rating, indicating the property’s energy efficiency. Pricing Information Rental Estimates: Ranges for estimated rental values (rentEstimate_lowerPrice, rentEstimate_currentPrice, rentEstimate_upperPrice). Sale Estimates: Current sale price estimates with confidence levels and historical changes. saleEstimate_currentPrice: Current estimated sale price. saleEstimate_confidenceLevel: Confidence in the sale price estimate (LOW, MEDIUM, HIGH). saleEstimate_valueChange: Numeric and percentage change in sale value over time. Transaction History: Date-stamped sale prices with historic price changes, providing insight into property appreciation or depreciation. Potential Applications This dataset enables a variety of analyses:

Market Trend Analysis: Track how property values and rents have evolved over time. Investment Insights: Identify high-growth areas and property types based on historical and estimated price changes. Geospatial Analysis: Use location data to visualize price distributions and trends across London. Usage Recommendations This dataset is well-suited for machine learning projects predicting property values, rent estimations, or analyzing urban property trends. With rich details spanning multiple facets of the real estate market, it’s an essential resource for data scientists, analysts, and investors exploring the London property market.

Housing Index in the United Kingdom increased to 517.10 points in October from 514.20 points in September of 2025. This dataset provides - United Kingdom House Price Index - actual values, historical data, forecast, chart, statistics, economic calendar and news.

The London house prices dataset contains details for property sales and contains around 1.38 million observations.

The average mix-adjusted house price in London, England, peaked in August 2022, followed by a slight correction in 2023. In June 2024, the average house price amounted to about ******* British pounds, up from ******* British pounds a year ago. These recent fluctuations have also been observed by other measures, such as the house price index. The house price index is an important measure for the residential real estate market and is used to show changes in the value of residential properties.

The UK residential real estate market, valued at £360.27 million in 2025, is projected to experience robust growth, driven by several key factors. A consistently strong CAGR of 5.75% indicates a healthy and expanding market over the forecast period (2025-2033). This growth is fueled by increasing urbanization, a growing population, and a persistent demand for housing, particularly in major cities like London. Furthermore, government initiatives aimed at boosting homeownership and infrastructure development contribute positively to market expansion. The market is segmented by property type, with apartments and condominiums, and landed houses and villas representing significant segments. Key players such as Bellway PLC, Barratt Developments PLC, and Berkeley Group dominate the market, while a competitive landscape also includes numerous smaller developers and housing associations. While rising interest rates and construction costs present challenges, the overall outlook remains positive due to the enduring demand and limited housing supply, particularly in desirable areas. However, several factors could influence the market's trajectory. Fluctuations in the national economy, changes in government regulations concerning mortgages and property taxation, and global economic uncertainty could impact buyer confidence and investment. Regional variations also exist, with market dynamics differing across England, Scotland, Wales, and Northern Ireland. Understanding these regional nuances is crucial for targeted investment strategies. The market's resilience will depend on the ability of developers to adapt to changing market conditions and meet evolving consumer preferences for sustainable and energy-efficient housing. The continuous evolution of consumer preferences towards specific types of housing and location preferences will further shape the market's future growth. Recent developments include: May 2023: A UAE-based investment manager, Rasmala Investment Bank, has launched a USD 2bn ( €1.8bn) UK multifamily strategy for a five-year period to build a USD 2bn portfolio of UK residential properties. The strategy is focused on the UK market for multifamily properties through a Shariah-compliant investment vehicle, initially targeting the serviced apartment (SAP) and BTR (build-to-rent) subsectors within and around London. Seeded by Rasmala Group, the strategy is backed by an active investment pipeline for the next 12 – 18 months., November 2022: ValuStrat, a Middle East consulting company, increased its foothold in the UK by acquiring an interest in Capital Value Surveyors, a real estate advisory services company with offices in London. The UK continues to be one of the most established real estate markets worldwide and attracts foreign investors regularly. They are excited to expand their presence there to better serve all of their clients, both in the UK and the Middle East.. Key drivers for this market are: Demand for New Dwellings Units, Government Initiatives are driving the market. Potential restraints include: Demand for New Dwellings Units, Government Initiatives are driving the market. Notable trends are: Increasing in the United Kingdom House Prices.

📹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.

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.

After a period of rapid increase, house price growth in the UK has moderated. In 2025, house prices are forecast to increase by ****percent. Between 2025 and 2029, the average house price growth is projected at *** percent. According to the source, home building is expected to increase slightly in this period, fueling home buying. On the other hand, higher borrowing costs despite recent easing of mortgage rates and affordability challenges may continue to suppress transaction activity. Historical house price growth in the UK House prices rose steadily between 2015 and 2020, despite minor fluctuations. In the following two years, prices soared, leading to the house price index jumping by about 20 percent. As the market stood in April 2025, the average price for a home stood at approximately ******* British pounds. Rents are expected to continue to grow According to another forecast, the prime residential market is also expected to see rental prices grow in the next five years. Growth is forecast to be stronger in 2025 and slow slightly until 2029. The rental market in London is expected to follow a similar trend, with Outer London slightly outperforming Central London.

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..