SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W2 4QN' order by fulladdress
W2 4QN - 577,000
- Leasehold Flat/Maisonette
W2 4QN - 696,000
- Leasehold Flat/Maisonette
W2 4QN - 686,000
- Leasehold Flat/Maisonette
W2 4QN - 495,000
- Leasehold Flat/Maisonette
W2 4QN - 905,000
- Leasehold Flat/Maisonette
W2 4QN - 778,000
- Leasehold Purpose built flat
W2 4QN - 735,000
- Leasehold Purpose built flat
W2 4QN - 1,238,000
- Leasehold Purpose built flat
W2 4QN - 1,283,000
- Feudal Purpose built flat
W2 4QN - 903,000
- Leasehold Flat/Maisonette
W2 4QN - 649,000
- Leasehold Flat/Maisonette
W2 4QN - 1,238,000
- Leasehold Flat/Maisonette
W2 4QN - 537,000
- Leasehold Purpose built flat
W2 4QN - 1,132,000
- Leasehold Purpose built flat
W2 4QN - 832,000
- Leasehold Flat/Maisonette
W2 4QN - 1,070,000
- Flat/Maisonette
W2 4QN - 553,000
- Leasehold Converted flat
W2 4QN - 1,342,000
- Leasehold Flat/Maisonette
W2 4QN - 502,000
- Leasehold Flat/Maisonette
W2 4QN - 751,000
- Leasehold Purpose built flat
W2 4QN - 581,000
- Leasehold Flat/Maisonette
W2 4QN - 1,535,000
- Leasehold Flat/Maisonette
W2 4QN - 517,000
- Leasehold Purpose built flat
W2 4QN - 998,000
- Leasehold Flat/Maisonette
W2 4QN - 582,000
- Leasehold Purpose built flat
W2 4QN - 791,000
- Leasehold Flat/Maisonette
W2 4QN - 721,000
- Share of freehold Flat/Maisonette
W2 4QN - 2,155,000
- Leasehold Flat/Maisonette
W2 4QN - 465,000
- Feudal Purpose built flat
W2 4QN - 691,000
- Leasehold Flat/Maisonette
W2 4QN - 1,336,000
- Leasehold Flat/Maisonette
W2 4QN - 1,221,000
- Leasehold Purpose built flat
W2 4QN - 1,029,000
- Leasehold Flat/Maisonette
W2 4QN - 1,581,000
- Leasehold Purpose built flat
W2 4QN - 838,000
- Leasehold Purpose built flat
W2 4QN - 1,180,000
- Feudal Purpose built flat
W2 4QN - 1,653,000
- Leasehold Flat/Maisonette
