Feb 07, 2023 by HM

House prices in Longstanton (CB24 3)

This article reveals price per square metre data and various charts to help you understand current housing market in Longstanton (CB24 3).

Price per square metre

Knowing the average house price in Longstanton is not much use. However, knowing average price per square metre can be quite useful. Price per sqm allows some comparison between properties of different size. We define price per square metre as the sold price divided by the internal area of a property:

£ per sqm = price ÷ internal area
E.g. 7, Rectory Close, Longstanton, Cottenham, sold for £200,000 on Sep-2023. Given the internal area of 42 square metres, the price per sqm is £4,761.

England & Wales have been officially metric for many decades. However house price per square foot is sometimes prefered by those of sufficiently advanced age. They may want to convert metres on this page to square feet.

The chart below is called a histogram, it helps you see the distribution of this house price per sqm data. To make this chart we put the sales data into a series of £ per sqm 'buckets' (e.g. £3,350-£3,500, £3,500-£3,650, £3,650-£3,800 etc...) we then count the number of sales with within in each bucket and plot the results. The chart is based on 93 sales in Longstanton (CB24 3) that took place in the last two years.

Distribution of £ per sqm for Longstanton (CB24 3)
Distribution of £ per sqm house prices in Longstanton

You can see the spread of prices above. This is because although internal area is a key factor in determining valuation, it is not the only factor. Many factors other than size affect desirability; these factors could be condition, aspect, garden size, negotiating power of the vendor etc.

That said, the spread of prices will give you a feel of the typical range to expect in Longstanton (CB24 3). Of the 93 transactions, half were sold for between £3,450 and £4,490 per square metre. Notably, only 25% of properties that sold recently were valued at more than £4,490m2. For anything to be valued more than this means it has to be more desireable than the clear majority of homes.

For the average, we calculate the 'median' or middle price. The median price per square metre in 'CB24 3' is £3,930. The table below shows how 'CB24 3' compares to neighbouring postcode sectors.

Postcode sector Lower quartile Middle quartile Upper quartile
CB24 4 Swavesey £3,340m2 £3,780m2 £4,320m2
CB24 3 Longstanton £3,450m2 £3,930m2 £4,490m2
CB24 8 Cottenham £3,720m2 £4,330m2 £4,670m2
CB24 5 Willingham £3,270m2 £3,660m2 £4,200m2
CB24 6 Milton £4,510m2 £5,000m2 £5,490m2
CB24 1 Northstowe £3,720m2 £4,250m2 £4,610m2
CB24 9 Histon £4,730m2 £5,250m2 £5,830m2

Will Longstanton house prices drop in 2024?

I cannot tell the future and don't believe anyone who says they can. I can however plot price trends - I have done this in the scatter plot below for CB24 3 (Longstanton). From this one could infer a range of reasonable possible future price falls or rises. In the chart below, the red dashed line is the house price trend for CB24 3 and the blue dots are the individual property sales that inform this trend.

Price per square metre in Longstanton (CB24 3) over time
House price trends for Longstanton

Hover on any blue dot to see details of specific sales

Disclaimer: The data provided throughout this website about Longstanton and any other area, is not financial advice. Any information provided does not and cannot ever take in to account the particular financial situation, objectives or property needs of either you or anyone reading this information. Furthermore, I cannot guarantee the accuracy of any data shown. This information is based on sold prices and internal area data provided by Land Registry and other third parties - I do not verify the accuracy of the Longstanton data or any other data I am given.

Price map for Longstanton

I've just finished coding the map I link to below. I find it useful and I am sure it will help you in exploring Longstanton. You can zoom in all the way to individual properties and then all the way back out to see the whole country. The colours show the current estimated property values. I will explain more about the methodology and create a key next week.

Property price heatmap for Longstanton
House price heatmap for Longstanton

Street level data

Street Avg size Avg £/m2 Recent sales
Magdalene Close, Longstanton, CB24 3E 82m2 £3,570 23
Rampton Drift, Longstanton, CB24 3E 94m2 £3,080 16
Mitchcroft Road, Longstanton, CB24 3E 110m2 £3,376 13
Mitchcroft Road, Longstanton, CB24 3B 105m2 £3,350 13
Days Meadow, Longstanton, CB24 3G 93m2 £3,906 10
Collingwood Drive, Longstanton, CB24 3G 94m2 £3,683 10
Duddle Drive, Longstanton, CB24 3U 123m2 £3,640 9
High Street, Longstanton, CB24 3B 118m2 £3,153 8

Search for your street here.

Raw data

Our analysis of Longstanton is derived from what is essentially a big table of sold prices from Land Registry with added property size information. Below are three rows from this table to give you an idea.

Address Paid m2 £/m2
7, Rectory Close, Longstanton, Cottenham £200,000
42 4,761
14, Mead View, Longstanton, Cottenham £670,000
158 4,240
4, Days Meadow, Longstanton, Cottenham £535,000
124 4,314

See the entire list of all sales in Longstanton (CB24 3) here.


HouseMetric is a hobby, created out of a desire to see data and analysis not present on any free to use website. It is still a work in progress and I'll add more stuff in the near future.