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 2BW' order by fulladdress
W2 2BW - 1,206,000
- Leasehold Flat/Maisonette
W2 2BW - 583,000
- Leasehold Purpose built flat
W2 2BW - 1,463,000
- Leasehold Flat/Maisonette
W2 2BW - 1,205,000
- Leasehold Purpose built flat
W2 2BW - 612,000
- Leasehold Purpose built flat
W2 2BW - 489,000
- Leasehold Purpose built flat
W2 2BW - 532,000
- Leasehold Flat/Maisonette
W2 2BW - 439,000
- Leasehold Flat/Maisonette
W2 2BW - 752,000
- Leasehold Purpose built flat
W2 2BW - 590,000
- Leasehold Purpose built flat
W2 2BW - 712,000
- Leasehold Flat/Maisonette
W2 2BW - 1,244,000
- Leasehold Flat/Maisonette
W2 2BW - 967,000
- Leasehold Flat/Maisonette
W2 2BW - 518,000
- Leasehold Flat/Maisonette
W2 2BW - 1,359,000
- Leasehold Flat/Maisonette
W2 2BW - 543,000
- Leasehold Flat/Maisonette
W2 2BW - 405,000
- Leasehold Purpose built flat
W2 2BW - 1,456,000
- Leasehold Purpose built flat
W2 2BW - 973,000
- Leasehold Flat/Maisonette
W2 2BW - 555,000
- Leasehold Flat/Maisonette
W2 2BW - 831,000
- Leasehold Flat/Maisonette
W2 2BW - 839,000
- Leasehold Flat/Maisonette
W2 2BW - 1,789,000
- Leasehold Flat/Maisonette
W2 2BW - 865,000
- Leasehold Flat/Maisonette
W2 2BW - 620,000
- Leasehold Purpose built flat
W2 2BW - 735,000
- Leasehold Flat/Maisonette
W2 2BW - 781,000
- Leasehold Flat/Maisonette
W2 2BW - 937,000
- Leasehold Flat/Maisonette
W2 2BW - 752,000
- Leasehold Flat/Maisonette
W2 2BW - 296,000
- Leasehold Flat/Maisonette
W2 2BW - 783,000
- Leasehold Flat/Maisonette
W2 2BW - 952,000
- Leasehold Flat/Maisonette
W2 2BW - 861,000
- Leasehold Flat/Maisonette
W2 2BW - 802,000
- Leasehold Flat/Maisonette
W2 2BW - 1,027,000
- Leasehold Purpose built flat
W2 2BW - 733,000
- Leasehold Flat/Maisonette
W2 2BW - 436,000
- Leasehold Flat/Maisonette
W2 2BW - 513,000
- Leasehold Purpose built flat
W2 2BW - 428,000
- Leasehold Purpose built flat