SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CB6 2HP' order by fulladdress
CB6 2HP - 186,000
- Leasehold Flat/Maisonette
CB6 2HP - 0
- Freehold Detached property
CB6 2HP - 466,000
- Freehold Detached bungalow
CB6 2HP - 392,000
- Freehold Semi-detached property
CB6 2HP - 311,000
- Freehold Semi-detached house
CB6 2HP - 329,000
- Semi-detached house
CB6 2HP - 316,000
- Freehold Semi-detached house
CB6 2HP - 291,000
- Freehold Semi-detached property
CB6 2HP - 316,000
- Freehold Semi-detached house
CB6 2HP - 586,000
- Freehold Detached property
CB6 2HP - 327,000
- Freehold Semi-detached house
CB6 2HP - 635,000
- Freehold Detached house
CB6 2HP - 683,000
- Freehold Detached house
CB6 2HP - 675,000
- Freehold Detached house
CB6 2HP - 362,000
- Freehold Semi-detached house
CB6 2HP - 440,000
- Freehold Detached property
CB6 2HP - 673,000
- Freehold Detached house
CB6 2HP - 672,000
- Freehold Detached house
CB6 2HP - 399,000
- Freehold Semi-detached house
CB6 2HP - 398,000
- Semi-detached house
CB6 2HP - 736,000
- Freehold Detached house
CB6 2HP - 422,000
- Freehold Detached property
CB6 2HP - 407,000
- Freehold Detached house
CB6 2HP - 583,000
- Freehold Detached house
CB6 2HP - 449,000
- Freehold Detached house
CB6 2HP - 354,000
- Freehold Detached bungalow
CB6 2HP - 521,000
- Freehold Detached house
CB6 2HP - 390,000
- Freehold Semi-detached property
CB6 2HP - 376,000
- Freehold Semi-detached bungalow
CB6 2HP - 547,000
- Freehold Detached property
CB6 2HP - 400,000
- Freehold Semi-detached house
CB6 2HP - 414,000
- Freehold Semi-detached house
CB6 2HP - 381,000
- Freehold Semi-detached house
CB6 2HP - 342,000
- Freehold Semi-detached house
CB6 2HP - 395,000
- Freehold Semi-detached house
CB6 2HP - 343,000
- Freehold Semi-detached property
CB6 2HP - 363,000
- Freehold Semi-detached house
CB6 2HP - 377,000
- Freehold Semi-detached house
CB6 2HP - 458,000
- Freehold Semi-detached house
CB6 2HP - 185,000
- Leasehold Purpose built flat
CB6 2HP - 187,000
- Leasehold Purpose built flat
CB6 2HP - 186,000
- Leasehold Flat/Maisonette
CB6 2HP - 177,000
- Leasehold Flat/Maisonette
CB6 2HP - 189,000
- Leasehold Purpose built flat
CB6 2HP - 707,000
- Freehold Detached house
CB6 2HP - 793,000
- Freehold Detached house
CB6 2HP - 346,000
- Freehold Semi-detached house
CB6 2HP - 753,000
- Freehold Detached house
CB6 2HP - 619,000
- Freehold Detached property
CB6 2HP - 708,000
- Freehold Detached house