SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CM16 5AF' order by fulladdress
CM16 5AF - 384,000
- Leasehold Flat/Maisonette
CM16 5AF - 399,000
- Leasehold Flat/Maisonette
CM16 5AF - 411,000
- Leasehold Purpose built flat
CM16 5AF - 434,000
- Leasehold Flat/Maisonette
CM16 5AF - 410,000
- Leasehold Purpose built flat
CM16 5AF - 414,000
- Leasehold Purpose built flat
CM16 5AF - 438,000
- Leasehold Flat/Maisonette
CM16 5AF - 1,232,000
- Freehold Detached house
CM16 5AF - 1,229,000
- Freehold Detached house
CM16 5AF - 1,243,000
- Freehold Detached house
CM16 5AF - 1,226,000
- Freehold Detached house
CM16 5AF - 435,000
- Leasehold Flat/Maisonette
CM16 5AF - 1,097,000
- Freehold Detached house
CM16 5AF - 1,144,000
- Freehold Detached house
CM16 5AF - 1,199,000
- Freehold Detached house
CM16 5AF - 1,255,000
- Freehold Detached house
CM16 5AF - 970,000
- Freehold Detached house
CM16 5AF - 1,018,000
- Freehold Detached house
CM16 5AF - 974,000
- Freehold Detached house
CM16 5AF - 1,037,000
- Freehold Detached house
CM16 5AF - 405,000
- Leasehold Purpose built flat
CM16 5AF - 412,000
- Leasehold Purpose built flat
CM16 5AF - 401,000
- Leasehold Purpose built flat
CM16 5AF - 410,000
- Leasehold Flat/Maisonette
CM16 5AF - 403,000
- Leasehold Purpose built flat
CM16 5AF - 465,000
- Leasehold Purpose built flat
CM16 5AF - 394,000
- Leasehold Purpose built flat
CM16 5AF - 389,000
- Leasehold Flat/Maisonette
CM16 5AF - 391,000
- Leasehold Purpose built flat
CM16 5AF - 398,000
- Leasehold Purpose built flat
CM16 5AF - 421,000
- Leasehold Flat/Maisonette
CM16 5AF - 391,000
- Leasehold Purpose built flat
CM16 5AF - 408,000
- Leasehold Purpose built flat
CM16 5AF - 418,000
- Leasehold Flat/Maisonette
CM16 5AF - 407,000
- Leasehold Flat/Maisonette
CM16 5AF - 380,000
- Leasehold Purpose built flat
CM16 5AF - 401,000
- Leasehold Purpose built flat
CM16 5AF - 401,000
- Leasehold Purpose built flat
CM16 5AF - 402,000
- Leasehold Purpose built flat
CM16 5AF - 398,000
- Leasehold Purpose built flat
CM16 5AF - 424,000
- Leasehold Flat/Maisonette
CM16 5AF - 408,000
- Leasehold Flat/Maisonette
CM16 5AF - 402,000
- Leasehold Purpose built flat
CM16 5AF - 496,000
- Leasehold Semi-detached house