SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CT6 6JJ' order by fulladdress
CT6 6JJ - 562,000
- Freehold Detached house
CT6 6JJ - 482,000
- Freehold Semi-detached house
CT6 6JJ - 560,000
- Freehold Detached house
CT6 6JJ - 457,000
- Freehold Semi-detached house
CT6 6JJ - 535,000
- Freehold Semi-detached house
CT6 6JJ - 617,000
- Freehold Semi-detached house
CT6 6JJ - 515,000
- Freehold Semi-detached house
CT6 6JJ - 505,000
- Freehold Detached house
CT6 6JJ - 611,000
- Freehold Detached house
CT6 6JJ - 496,000
- Freehold Detached house
CT6 6JJ - 602,000
- Freehold Detached house
CT6 6JJ - 195,000
- Leasehold Converted flat
CT6 6JJ - 495,000
- Freehold Detached house
CT6 6JJ - 499,000
- Freehold Detached house
CT6 6JJ - 544,000
- Freehold Semi-detached house
CT6 6JJ - 364,000
- Freehold Detached house
CT6 6JJ - 478,000
- Freehold Semi-detached property
CT6 6JJ - 327,000
- Freehold Semi-detached house
CT6 6JJ - 587,000
- Freehold Detached house
CT6 6JJ - 531,000
- Freehold Semi-detached house
CT6 6JJ - 433,000
- Freehold Semi-detached house
CT6 6JJ - 427,000
- Freehold Semi-detached house
CT6 6JJ - 479,000
- Freehold Semi-detached house
CT6 6JJ - 604,000
- Freehold Semi-detached house
CT6 6JJ - 440,000
- Freehold Semi-detached house
CT6 6JJ - 670,000
- Freehold Detached house
CT6 6JJ - 484,000
- Freehold Semi-detached property
CT6 6JJ - 615,000
- Freehold Detached house
CT6 6JJ - 507,000
- Freehold Semi-detached house
CT6 6JJ - 698,000
- Freehold Detached house
CT6 6JJ - 214,000
- Leasehold Converted flat
CT6 6JJ - 224,000
- Leasehold Converted flat
CT6 6JJ - 233,000
- Leasehold Converted flat
CT6 6JJ - 215,000
- Leasehold Converted flat
CT6 6JJ - 224,000
- Leasehold Converted flat
CT6 6JJ - 604,000
- Freehold Detached house