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

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:

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

Dataset

This dataset was created by 🚀Sonali Singh

Contents

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.

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.

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

The Greater London Authority's ‘Housing in London’ report sets out the evidence base for the Mayor's housing policies, summarising key patterns and trends across a wide range of topics relevant to housing in the capital. The report is the evidence base for the Mayor’s London Housing Strategy, the latest edition of which was published in May 2018. The 2024 edition of Housing in London can be viewed here. It includes monitoring indicators for the London Housing Strategy, and five thematic chapters: Demographic, economic and social context Housing stock and supply Housing costs and affordability Housing needs, including homelessness and overcrowding Mobility and decent homes

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.

The number of housing starts and completions in London decreased sharply in the fiscal year 2024/25. That came after a period of steadily increasing housing starts between 2019/20 and 2022/23, with ****** units started that latter year. Meanwhile, the number of new residential property starts in London amounted to ***** dwellings in 2024/25. However, the overall housing starts in the United Kingdom were forecasted to grow significantly in the coming years. How do residential construction costs compare across regions in the United Kingdom? Construction costs have been an important challenge for contractors and homebuilders in the United Kingdom, having an effect on their profit, but also on the final price of housing. Residential construction costs in the UK varied significantly by city and building type, with apartment high-rises generally being more expensive to construct than medium-standard townhouses. Overall, construction costs reflect a trend in which urban centers like London and Manchester have the highest average residential building construction costs in the UK. What is the price of a newly built home in the United Kingdom? Over the past decade, house prices have generally increased, reflecting a steady upward trend in the housing market. By the end of 2023, the average price of a newly built house in the UK amounted to nearly ******* British pounds. However, this represented a slight dip compared to the previous quarter, which recorded the highest average house prices since 2013. These trends suggest that the rise in housing costs will continue in the long-term, even if prices fluctuate slightly in certain quarters.

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 package contains data and STATA/SAS codes to generate house price and rent indices for London from 1895 to 1914.

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

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

The Greater London Authority's ‘Housing in London’ report sets out the evidence base for the Mayor's housing policies, summarising key patterns and trends across a wide range of topics relevant to housing in the capital. The report is the evidence base for the Mayor’s London Housing Strategy, the latest edition of which was published in May 2018.

The 2024 edition of Housing in London can be viewed here. It includes monitoring indicators for the London Housing Strategy, and five thematic chapters:

• 1. Demographic, economic and social context
• 2. Housing stock and supply
• 3. Housing costs and affordability
• 4. Housing needs, including homelessness and overcrowding
• 5. Mobility and decent homes

Where possible, the data behind each year's report's charts and maps is made available below.

To provide feedback or request the document in an accessible format, please email housing.analysis@london.gov.uk

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

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 statistic shows the average house prices in London, United Kingdom (UK), from 2013 to 2019. The average house price in the capital increased to over *** thousand British pounds by 2019.