SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W3 8YG' order by fulladdress
W3 8YG - 453,000
- Purpose built flat
W3 8YG - 603,000
- Leasehold Flat/Maisonette
W3 8YG - 562,000
- Leasehold Purpose built flat
W3 8YG - 596,000
- Leasehold Flat/Maisonette
W3 8YG - 401,000
- Purpose built flat
W3 8YG - 453,000
- Feudal Flat/Maisonette
W3 8YG - 714,000
- Feudal Purpose built flat
W3 8YG - 594,000
- Leasehold Flat/Maisonette
W3 8YG - 581,000
- Purpose built flat
W3 8YG - 605,000
- Leasehold Flat/Maisonette
W3 8YG - 615,000
- Leasehold Purpose built flat
W3 8YG - 447,000
- Purpose built flat
W3 8YG - 452,000
- Leasehold Purpose built flat
W3 8YG - 697,000
- Feudal Purpose built flat
W3 8YG - 597,000
- Leasehold Purpose built flat
W3 8YG - 595,000
- Leasehold Purpose built flat
W3 8YG - 624,000
- Leasehold Flat/Maisonette
W3 8YG - 563,000
- Leasehold Flat/Maisonette
W3 8YG - 359,000
- Leasehold Purpose built flat
W3 8YG - 448,000
- Leasehold Purpose built flat
W3 8YG - 424,000
- Leasehold Purpose built flat
W3 8YG - 418,000
- Leasehold Flat/Maisonette
W3 8YG - 593,000
- Leasehold Converted flat
W3 8YG - 591,000
- Leasehold Purpose built flat
W3 8YG - 625,000
- Leasehold Flat/Maisonette
W3 8YG - 398,000
- Leasehold Semi-detached house
W3 8YG - 462,000
- Leasehold Flat/Maisonette
W3 8YG - 590,000
- Leasehold Purpose built flat
W3 8YG - 465,000
- Leasehold Flat/Maisonette
W3 8YG - 401,000
- Leasehold Purpose built flat
W3 8YG - 716,000
- Leasehold Purpose built flat
W3 8YG - 672,000
- Leasehold Flat/Maisonette
W3 8YG - 673,000
- Leasehold Flat/Maisonette
W3 8YG - 722,000
- Leasehold Flat/Maisonette
W3 8YG - 715,000
- Leasehold Flat/Maisonette
W3 8YG - 652,000
- Leasehold Purpose built flat
W3 8YG - 716,000
- Leasehold Flat/Maisonette
W3 8YG - 438,000
- Leasehold Purpose built flat
W3 8YG - 401,000
- Purpose built flat
W3 8YG - 415,000
- Leasehold Purpose built flat