SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CB24 6ZG' order by fulladdress
CB24 6ZG - 258,000
- Freehold End terrace house
CB24 6ZG - 490,000
- Freehold Detached house
CB24 6ZG - 371,000
- Freehold Mid terrace house
CB24 6ZG - 487,000
- Freehold Detached house
CB24 6ZG - 392,000
- Freehold Mid terrace house
CB24 6ZG - 458,000
- Freehold Detached house
CB24 6ZG - 255,000
- Freehold End terrace house
CB24 6ZG - 476,000
- Freehold Detached house
CB24 6ZG - 260,000
- Freehold End terrace house
CB24 6ZG - 244,000
- Freehold Purpose built flat
CB24 6ZG - 334,000
- Freehold End terrace house
CB24 6ZG - 476,000
- Freehold Detached house
CB24 6ZG - 348,000
- Freehold Mid terrace house
CB24 6ZG - 325,000
- Freehold Mid terrace house
CB24 6ZG - 341,000
- Freehold Mid terrace house
CB24 6ZG - 258,000
- Freehold End terrace house
CB24 6ZG - 267,000
- Freehold Detached house
CB24 6ZG - 240,000
- Freehold End terrace house
CB24 6ZG - 237,000
- Freehold End terrace house
CB24 6ZG - 484,000
- Freehold Detached house
CB24 6ZG - 273,000
- Freehold Terrace property
CB24 6ZG - 566,000
- Freehold Detached house
CB24 6ZG - 434,000
- Freehold Semi-detached house
CB24 6ZG - 463,000
- Freehold Detached house
CB24 6ZG - 439,000
- Freehold Semi-detached house
CB24 6ZG - 539,000
- Freehold Detached house
CB24 6ZG - 375,000
- Freehold End terrace house
CB24 6ZG - 473,000
- Freehold Detached house
CB24 6ZG - 355,000
- Freehold Mid terrace house
CB24 6ZG - 532,000
- Freehold Detached house
CB24 6ZG - 263,000
- Freehold End terrace house
CB24 6ZG - 427,000
- Freehold Semi-detached house
CB24 6ZG - 266,000
- Freehold End terrace house
CB24 6ZG - 342,000
- Freehold Terrace property
CB24 6ZG - 337,000
- Freehold End terrace house
CB24 6ZG - 354,000
- Freehold Semi-detached property
CB24 6ZG - 328,000
- Freehold Terrace property
CB24 6ZG - 382,000
- Freehold End terrace house
CB24 6ZG - 265,000
- Freehold End terrace house
CB24 6ZG - 262,000
- Freehold Semi-detached house
CB24 6ZG - 419,000
- Freehold Semi-detached house
CB24 6ZG - 372,000
- Freehold Mid terrace house
CB24 6ZG - 421,000
- Freehold End terrace house
CB24 6ZG - 416,000
- Freehold Semi-detached house
CB24 6ZG - 482,000
- Freehold Semi-detached house
CB24 6ZG - 494,000
- Freehold Detached property
CB24 6ZG - 332,000
- Freehold Mid terrace house
CB24 6ZG - 518,000
- Freehold Detached property
CB24 6ZG - 437,000
- Freehold Detached house
CB24 6ZG - 467,000
- Freehold Detached house
CB24 6ZG - 518,000
- Freehold Detached house
CB24 6ZG - 518,000
- Freehold Detached house
CB24 6ZG - 478,000
- Freehold Detached house
CB24 6ZG - 519,000
- Freehold Detached house
CB24 6ZG - 259,000
- Freehold Mid terrace house