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 2YF' order by fulladdress
W2 2YF - 890,000
- Leasehold Purpose built flat
W2 2YF - 885,000
- Leasehold Purpose built flat
W2 2YF - 842,000
- Purpose built flat
W2 2YF - 670,000
- Leasehold Purpose built flat
W2 2YF - 765,000
- Leasehold Flat/Maisonette
W2 2YF - 708,000
- Leasehold Purpose built flat
W2 2YF - 689,000
- Leasehold Flat/Maisonette
W2 2YF - 703,000
- Leasehold Flat/Maisonette
W2 2YF - 702,000
- Leasehold Flat/Maisonette
W2 2YF - 914,000
- Leasehold Flat/Maisonette
W2 2YF - 707,000
- Leasehold Purpose built flat
W2 2YF - 747,000
- Leasehold Flat/Maisonette
W2 2YF - 791,000
- Leasehold Flat/Maisonette
W2 2YF - 866,000
- Leasehold Purpose built flat
W2 2YF - 822,000
- Leasehold Purpose built flat
W2 2YF - 870,000
- Leasehold Purpose built flat
W2 2YF - 899,000
- Leasehold Flat/Maisonette
W2 2YF - 891,000
- Leasehold Flat/Maisonette
W2 2YF - 888,000
- Leasehold Purpose built flat
W2 2YF - 883,000
- Leasehold Flat/Maisonette
W2 2YF - 916,000
- Leasehold Flat/Maisonette
W2 2YF - 862,000
- Leasehold Flat/Maisonette
W2 2YF - 902,000
- Leasehold Flat/Maisonette
W2 2YF - 893,000
- Leasehold Purpose built flat
W2 2YF - 883,000
- Leasehold Purpose built flat
W2 2YF - 686,000
- Leasehold Flat/Maisonette
W2 2YF - 823,000
- Leasehold Purpose built flat
W2 2YF - 702,000
- Leasehold Flat/Maisonette
W2 2YF - 756,000
- Leasehold Flat/Maisonette
W2 2YF - 841,000
- Leasehold Flat/Maisonette
W2 2YF - 846,000
- Leasehold Flat/Maisonette
W2 2YF - 802,000
- Leasehold Flat/Maisonette
W2 2YF - 899,000
- Leasehold Flat/Maisonette
W2 2YF - 773,000
- Leasehold Flat/Maisonette
W2 2YF - 870,000
- Leasehold Flat/Maisonette
W2 2YF - 889,000
- Leasehold Flat/Maisonette
W2 2YF - 917,000
- Leasehold Flat/Maisonette