Property profile

6 Spiggots Close Longstanton

Map showing 6, Spiggots Close, Longstanton, Cambridge

Estimated sale price

£580,000

Detached sold in Longstanton

The box shows the middle 50% of detached sale prices, the whiskers show the 5th to 95th percentile, and the marker shows this property's estimated price.

Half of similar homes sold within the box; most sold within the wider line.

An indicative model estimate, not a survey or formal valuation.

This property vs market

Last sold28 Sept 2021
£525,000Change since last sale: +£54,000 (+10%)
Annualised change
+2.0% per yearSouth Cambridgeshire annualised change (detached) since 2021: +2.1% per yearThis property's value is moving in line with the market
Price per sq ftLocal median £349 per sq ft
£340 per sq ftEstimate vs local median: −£9 per sq ft (−2.5%)
Local sold pricesMedian for detached in Longstanton
£538,750Estimate vs local median: +£40,000 (+7.5%)
How this estimate is calculated

We estimate what this property could sell for today using the information available. It is a guide, and the final sale price may be higher or lower.

Property facts

EPC ratingD / C
Floor area158 m² / 1,701 sq ft
Property typeHouse / Detached
Habitable rooms7
EPC inspection11 Feb 2019

Sales history

DatePriceChange
28 Sept 2021£525,000+119%
19 Nov 2008£240,000-

Local market

Property prices in Longstanton

Median price£385,000
Price per sq ft£351
Sales (last 12 months)92
Typical range (middle 50%)£309K – £535K

Based on 92 recent sales, the median property price is £385,000 (about £351 per square foot) in Longstanton area, with individual transactions ranging from £93,000 up to £700,000.

Prices by property typelast 12 months

Median sale price, median price per square foot, sales count, and percentile information for each property type in Longstanton over the last year.
TypeSalesMedian£/sq ft
Detached42£538,750£349
Semi-Detached23£375,000£384
Terraced21£320,000£333
Flats6£241,250£366

10-year price trendmedian sale price in Longstanton

Sale price

Ten year median sale price trend for each property type in Longstanton.
YearDetachedFlatsSemi-DetachedTerraced
2016£417,500£165,000£298,000£243,500
2017£414,995£205,000£330,000£277,498
2018£430,995£245,995£317,750£306,000
2019£448,000£233,495£330,000£287,495
2020£449,000£237,495£341,995£285,000
2021£455,500£237,500£363,500£320,240
2022£489,995£237,500£385,000£350,000
2023£505,250£277,995£377,625£310,000
2024£430,000£247,000£350,000£289,675
2025£535,000£225,000£345,000£309,000
2026£607,500£268,000£500,000£295,000
Ten year median sale price trend for each property type in Longstanton.

Price per sq ft

Ten year median sale price per square foot trend for each property type in Longstanton.
YearDetachedFlatsSemi-DetachedTerraced
2016£303£323£276£298
2017£324£353£310£297
2018£322£344£358£354
2019£294£327£327£320
2020£314£334£358£317
2021£330£362£318£322
2022£352£363£378£390
2023£368£400£372£369
2024£378£387£371£374
2025£346£341£385£369
2026£316£356£326£308
Ten year median sale price per square foot trend for each property type in Longstanton.

Price distribution by property typelast 12 months

Price distribution by property type for Longstanton in the last year.

Recent sales

There were 22 recent sold properties in the last 18 months near CB24 3EA.

Recent sold properties in the last 18 months near CB24 3EA
DateAddressTypeTenurePriceMap
28 Feb 2025Flat D, 3, Spiggots Close, Cambridge, CB24 3EAFlatsLeasehold£225,000
24 Apr 20261A, Prentice Close, Cambridge, CB24 3DYOtherFreehold£400,000
29 Sept 202511, Hattons Park, Cambridge, CB24 3DLSemi-DetachedFreehold£382,000
28 Mar 202515, Collingwood Drive, Cambridge, CB24 3GWSemi-DetachedFreehold£425,000
26 May 20263, Brookfield Drive, Cambridge, CB24 3DZDetachedFreehold£615,000

Other properties at this postcode

Area insights for CB24 3EA

Full area profile →

Overview

Postcode CB24 3EA is located in a rural town, within the Longstanton ward of South Cambridgeshire in the East of England region, and forms part of the Longstanton, Swavesey & Oakington area. It has very low deprivation and average crime levels, with around 49.2 crimes per 1,000 residents per year, about 40% below the East of England average of 82 per 1,000. The average income per household in Longstanton, Swavesey & Oakington is £78,196 per year. The nearest station is Cambridge North, about 6.3 miles away. There are 2 primary and 1 secondary schools in the area. There are 2 parks nearby, the closest medium park is Longstanton Recreation Ground.

Crime rate
5/10
Crimes per 1k residents
49
Deprivation level
2/10
Income level
10/10
Social housing
0%
Connectivity
N/A
Flood Risk
Medium
Noise Level
No noise

Deprivation level

2/10

Longstanton, Swavesey & Oakington has a very low level of deprivation, ranked at position 30,203 out of 32,844 areas in the United Kingdom, placing it within the bottom 8% least deprived areas in England.

Crime level

5/10

Longstanton, Swavesey & Oakington has an average crime rate, with approximately 49.2 reported incidents per 1,000 population each year.

Social housing

0%

Approximately 0.0% of homes on this street are social housing provided by a local council or housing association. Across the surrounding area, around 10.5% of dwellings are socially rented.

Income level

10/10

The average income per household in Longstanton, Swavesey & Oakington is £78,196 per year.

Noise Level

No noise

No significant noise sources from railways or roads near CB24 3EA.

Flood risk

Medium

Longstanton, Swavesey & Oakington near CB24 3EA has medium flood risk (between 1% and 3.3% chance of a flood each year) from rivers and sea.

Transport

The nearest station is Cambridge North located about 6.3 miles away. There are no other stations nearby.

Parks

Nearby parks and green spaces for CB24 3EA
DistanceNameSizeDirections
0.1 miLongstanton Recreation GroundMediumWalking directions to Longstanton Recreation Ground
0.4 migreenwaySmallWalking directions to greenway

Area Profile

Population
309
Population density
233.4 per km²

Crime

Crime per 1,000 population

Violence and sexual offences
15.89(-50%)
Anti-social behaviour
11.12(-4%)
Criminal damage and arson
6.35(0%)
Burglary
5.56(+100%)
Public order
5.56(+9%)
East of England average

Demographics

Ethnic groups

British
238
76.77%
Other White
39
12.58%
Irish
12
3.87%
Indian
6
1.94%
White and Asian (mixed)
5
1.61%
Total population: 310

Economics

Education (age 16+)

Level 4+ (Degree)
110
45.08%
Level 2 (GCSEs 9-4)
40
16.39%
Level 3 (A level)
37
15.16%
No qualifications
24
9.84%
Level 1 (GCSEs 3-1)
18
7.38%
Total 16+ residents: 244

Housing

Housing tenure

Owns with a mortgage
50
39.37%
Owns outright
43
33.86%
Private landlord or letting agency
32
25.2%
Shared ownership
1
0.79%
Other forms of private rent
1
0.79%
Total households: 127

Schools

In the CB24 3EA postcode area, located within Longstanton, Swavesey & Oakington, there are 2 primary and 1 secondary schools in close proximity.

Nearby primary and secondary schools for CB24 3EA
DistancePhaseNameTypeRating
0.1 miPrimaryHatton Park Primary SchoolAcademy sponsor led

Good

0.9 miPrimaryPathfinder CofE Primary SchoolAcademy converter

N/A

0.9 miSecondaryNorthstowe Secondary CollegeAcademy converter

Good

Local amenities

2 nearby supermarkets & convenience stores within mi of CB24 3EA

Nearby supermarkets & convenience stores for CB24 3EA
DistanceNameAddressDirections
0.2 miCo-op Food93 High Street, Cambridge, CB24 3BTWalking directions to Co-op Food
0.3 miLongstanton Post Office & Stores10 High Street, Cambridge, CB24 3BPWalking directions to Longstanton Post Office & Stores

Data Sources

All data is sourced from official UK government agencies and public datasets. Last updated: 01/08/2026. Read more about how our statistics are calculated.