SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W6 0SZ' order by fulladdress
W6 0SZ - 874,000
- Leasehold Purpose built flat
W6 0SZ - 971,000
- Leasehold Flat/Maisonette
W6 0SZ - 972,000
- Leasehold Flat/Maisonette
W6 0SZ - 907,000
- Feudal Purpose built flat
W6 0SZ - 893,000
- Leasehold Purpose built flat
W6 0SZ - 741,000
- Leasehold Flat/Maisonette
W6 0SZ - 883,000
- Leasehold Purpose built flat
W6 0SZ - 861,000
- Leasehold Purpose built flat
W6 0SZ - 861,000
- Leasehold Purpose built flat
W6 0SZ - 895,000
- Leasehold Purpose built flat
W6 0SZ - 860,000
- Leasehold Flat/Maisonette
W6 0SZ - 895,000
- Leasehold Flat/Maisonette
W6 0SZ - 851,000
- Leasehold Purpose built flat
W6 0SZ - 1,211,000
- Leasehold Flat/Maisonette
W6 0SZ - 1,186,000
- Leasehold Flat/Maisonette
W6 0SZ - 888,000
- Purpose built flat
W6 0SZ - 907,000
- Leasehold Purpose built flat
W6 0SZ - 894,000
- Leasehold Purpose built flat
W6 0SZ - 876,000
- Leasehold Purpose built flat
W6 0SZ - 880,000
- Leasehold Flat/Maisonette
W6 0SZ - 912,000
- Leasehold Purpose built flat
W6 0SZ - 815,000
- Leasehold Flat/Maisonette
W6 0SZ - 892,000
- Feudal Purpose built flat
W6 0SZ - 915,000
- Leasehold Flat/Maisonette
W6 0SZ - 911,000
- Leasehold Purpose built flat
W6 0SZ - 1,011,000
- Leasehold Flat/Maisonette
W6 0SZ - 942,000
- Leasehold Flat/Maisonette
W6 0SZ - 886,000
- Leasehold Flat/Maisonette
W6 0SZ - 903,000
- Leasehold Purpose built flat
W6 0SZ - 908,000
- Leasehold Purpose built flat
W6 0SZ - 911,000
- Leasehold Flat/Maisonette
W6 0SZ - 917,000
- Leasehold Flat/Maisonette
W6 0SZ - 910,000
- Leasehold Purpose built flat
W6 0SZ - 856,000
- Leasehold Flat/Maisonette
W6 0SZ - 911,000
- Leasehold Flat/Maisonette
W6 0SZ - 924,000
- Leasehold Flat/Maisonette
W6 0SZ - 888,000
- Leasehold Purpose built flat
W6 0SZ - 981,000
- Leasehold Purpose built flat
W6 0SZ - 942,000
- Leasehold Purpose built flat
W6 0SZ - 808,000
- Leasehold Flat/Maisonette
W6 0SZ - 842,000
- Leasehold Flat/Maisonette
W6 0SZ - 887,000
- Leasehold Purpose built flat
W6 0SZ - 836,000
- Leasehold Flat/Maisonette
W6 0SZ - 839,000
- Leasehold Purpose built flat