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