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 9TL' order by fulladdress
CR6 9TL - 217,000
- Leasehold Purpose built flat
CR6 9TL - 216,000
- Leasehold Converted flat
CR6 9TL - 772,000
- Freehold Semi-detached property
CR6 9TL - 684,000
- Freehold Detached house
CR6 9TL - 751,000
- Freehold Detached house
CR6 9TL - 674,000
- Freehold Semi-detached house
CR6 9TL - 667,000
- Freehold Semi-detached property
CR6 9TL - 678,000
- Freehold Detached house
CR6 9TL - 949,000
- Freehold Detached house
CR6 9TL - 961,000
- Freehold Detached house
CR6 9TL - 782,000
- Freehold Detached house
CR6 9TL - 986,000
- Freehold Detached house
CR6 9TL - 1,156,000
- Freehold Detached house
CR6 9TL - 846,000
- Freehold Detached house
CR6 9TL - 1,230,000
- Freehold Detached house
CR6 9TL - 192,000
- Freehold Flat/Maisonette
CR6 9TL - 598,000
- Freehold Detached house
CR6 9TL - 837,000
- Freehold Semi-detached house
CR6 9TL - 1,274,000
- Freehold Detached house
CR6 9TL - 1,208,000
- Freehold Detached house
CR6 9TL - 293,000
- Freehold Flat/Maisonette
CR6 9TL - 1,301,000
- Freehold Detached house
CR6 9TL - 495,000
- Freehold Mid terrace house
CR6 9TL - 257,000
- Leasehold Converted flat
CR6 9TL - 280,000
- Leasehold Converted flat
CR6 9TL - 426,000
- Leasehold Flat/Maisonette
CR6 9TL - 343,000
- Leasehold Converted flat
CR6 9TL - 297,000
- Leasehold Converted flat
