SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CR6 9JB' order by fulladdress
CR6 9JB - 1,861,000
- Freehold Detached house
CR6 9JB - 1,597,000
- Freehold Detached house
CR6 9JB - 455,000
- Leasehold Converted flat
CR6 9JB - 1,355,000
- Freehold Detached house
CR6 9JB - 1,248,000
- Freehold Detached house
CR6 9JB - 1,135,000
- Freehold Detached house
CR6 9JB - 1,557,000
- Freehold Detached house
CR6 9JB - 898,000
- Freehold Detached house
CR6 9JB - 1,867,000
- Freehold Detached house
CR6 9JB - 992,000
- Freehold Detached property
CR6 9JB - 1,678,000
- Freehold Detached house
CR6 9JB - 1,170,000
- Freehold Detached house
CR6 9JB - 866,000
- Freehold Detached house
CR6 9JB - 1,138,000
- Freehold Detached property
CR6 9JB - 1,833,000
- Freehold Detached property
CR6 9JB - 1,124,000
- Freehold Detached house
CR6 9JB - 1,716,000
- Freehold Detached property
CR6 9JB - 973,000
- Freehold Detached house
CR6 9JB - 1,210,000
- Freehold Detached property
CR6 9JB - 1,712,000
- Freehold Detached house
CR6 9JB - 630,000
- Leasehold Flat/Maisonette
CR6 9JB - 660,000
- Leasehold Flat/Maisonette
CR6 9JB - 707,000
- Leasehold Flat/Maisonette
CR6 9JB - 1,269,000
- Freehold Detached house
CR6 9JB - 2,387,000
- Freehold Detached house
CR6 9JB - 1,497,000
- Freehold Detached house
CR6 9JB - 1,521,000
- Freehold Detached house
CR6 9JB - 1,985,000
- Freehold Detached house
