Feb 07, 2023 by HM

House prices in Great Shelford (CB22 5)

This article reveals price per square metre data and various charts to help you understand current housing market in Great Shelford (CB22 5).


Price per square metre

Knowing the average house price in Great Shelford 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. 16, Woollards Lane, Great Shelford, Sawston, sold for £1,300,000 on Aug-2023. Given the internal area of 229 square metres, the price per sqm is £5,676.

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. £4,150-£4,500, £4,500-£4,850, £4,850-£5,200 etc...) we then count the number of sales with within in each bucket and plot the results. The chart is based on 166 sales in Great Shelford (CB22 5) that took place in the last two years.

Distribution of £ per sqm for Great Shelford (CB22 5)
Distribution of £ per sqm house prices in Great Shelford

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 Great Shelford (CB22 5). Of the 166 transactions, half were sold for between £4,880 and £6,120 per square metre. Notably, only 25% of properties that sold recently were valued at more than £6,120m2. 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 'CB22 5' is £5,480. The table below shows how 'CB22 5' compares to neighbouring postcode sectors.

Postcode sector Lower quartile Middle quartile Upper quartile
CB22 4 Duxford £3,910m2 £4,390m2 £4,980m2
CB22 6 Foxton £4,110m2 £4,630m2 £5,480m2
CB22 3 Sawston £3,790m2 £4,460m2 £5,020m2
CB22 5 Great Shelford £4,880m2 £5,480m2 £6,120m2
CB22 7 Harston £4,280m2 £4,910m2 £5,650m2

Will Great Shelford 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 CB22 5 (Great Shelford). 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 CB22 5 and the blue dots are the individual property sales that inform this trend.

Price per square metre in Great Shelford (CB22 5) over time
House price trends for Great Shelford

Hover on any blue dot to see details of specific sales

Disclaimer: The data provided throughout this website about Great Shelford 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 Great Shelford data or any other data I am given.

Price map for Great Shelford

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 Great Shelford. 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 Great Shelford
House price heatmap for Great Shelford

Street level data

Street Avg size Avg £/m2 Recent sales
Cambridge Road, Great Shelford, CB22 5J 128m2 £5,555 22
Macaulay Avenue, Great Shelford, CB22 5A 77m2 £3,920 14
High Street, Great Shelford, CB22 5E 190m2 £5,483 13
Hinton Way, Great Shelford, CB22 5A 142m2 £5,393 13
Hauxton Road, Great Shelford, CB22 5H 128m2 £4,663 12
Church Road, Great Shelford, CB22 5H 116m2 £4,658 12
Abberley Wood, Great Shelford, CB22 5E 61m2 £5,533 10
Aylesford Way, Great Shelford, CB22 5D 98m2 £6,000 10

Search for your street here.

New build activity

Street Avg size Avg £/m2 New build sales
Mill Lane, Great Shelford, CB22 5G 87m2 £4,716 10

Mill Lane, Great Shelford, CB22 5G has seen 10 new build sales in the last 4 years (average price £401,528). These new build homes typically have an internal area of 87 m2, with an average price of £4,716 m2. This £sqm average is £-764 below the average for CB22 5. New builds typically command a £ per sqm premium. In the case of Mill Lane the premium seems not to exist. Without more info we can only speculate why this may be. Perhaps it may be greater density and smaller gardens, but this is just a guess.

Raw data

Our analysis of Great Shelford 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
16, Woollards Lane, Great Shelford, Sawston £1,300,000
Aug-2023
229 5,676
12, Poplar Close, Great Shelford, Sawston £410,000
Aug-2023
67 6,119
1, Granta Terrace, Great Shelford, Sawston £801,000
Aug-2023
149 5,375

See the entire list of all sales in Great Shelford (CB22 5) here.

About

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.