By Kush Chheda, Eric Gonzalez, Artesia Kabore, Mike Paz, and Pramod Rai
Based on UK property sales activity, the dataset contains two separate CSV files with 22,258 properties and 51,276 sales records spanned over a 30-year period from 1995 to 2025. The data was assembled from Rightmove and HM Land Registry, with the sales history at the property level. The origin of this dataset can be found here.
The very low sale prices range from £1 to £10K in the AB (Aberdeen) postcode area. The two properties with a sale price of £1 did not have a new build from 2005 and 2008, but the latest 2024 sale prices are £115K and £62K respectively.
The possible reasons for these high and low sale prices can be due to:
With these factors in mind, we decided to keep these sale values but flag them and treat them differently. We kept the low sales prices for most of the analysis with exception of question 8 and question 9, where values less than or equal to £10K were filtered out.
The very high sales prices range from £10M to £56M in the high value postcode areas of W (West London) and SW (South West London). Most of these properties are flats with a leasehold tenure, and the remaining properties in this sale price range are terraced with variations of leasehold and freehold tenures. Flats in the UK are equivalent to apartments in the US, meaning they are a form of multifamily real estate. The possible reason there’s high demand for high-density housing in West and South West London can be due to its land value and good transport links, which can signify high accessibility and an increase in property value and business opportunities. Another possible reason can be due to the proximity to central London with transport hubs, and this can make flats the most affordable property type in comparison to terraced houses in these affluent areas.
We applied a fixed cut off for properties with a sale price over £10M due to the factors previously explained.