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 4TE' order by fulladdress
W2 4TE - 938,000
- Leasehold Flat/Maisonette
W2 4TE - 820,000
- Leasehold Flat/Maisonette
W2 4TE - 1,328,000
- Leasehold Converted flat
W2 4TE - 885,000
- Leasehold Flat/Maisonette
W2 4TE - 978,000
- Leasehold Flat/Maisonette
W2 4TE - 970,000
- Leasehold Converted flat
W2 4TE - 956,000
- Leasehold Flat/Maisonette
W2 4TE - 1,077,000
- Leasehold Flat/Maisonette
W2 4TE - 1,475,000
- Leasehold Converted flat
W2 4TE - 962,000
- Leasehold Purpose built flat
W2 4TE - 876,000
- Leasehold Flat/Maisonette
W2 4TE - 1,480,000
- Leasehold Flat/Maisonette
W2 4TE - 1,677,000
- Leasehold Purpose built flat
W2 4TE - 1,284,000
- Leasehold Converted flat
W2 4TE - 1,603,000
- Leasehold Flat/Maisonette
W2 4TE - 949,000
- Leasehold Purpose built flat
W2 4TE - 951,000
- Leasehold Flat/Maisonette
W2 4TE - 1,443,000
- Leasehold Purpose built flat
W2 4TE - 889,000
- Leasehold Flat/Maisonette
W2 4TE - 985,000
- Leasehold Flat/Maisonette
W2 4TE - 880,000
- Leasehold Converted flat
W2 4TE - 1,060,000
- Leasehold Purpose built flat
W2 4TE - 961,000
- Leasehold Flat/Maisonette
W2 4TE - 1,536,000
- Leasehold Flat/Maisonette
W2 4TE - 925,000
- Leasehold Flat/Maisonette
W2 4TE - 1,499,000
- Leasehold Flat/Maisonette
W2 4TE - 1,671,000
- Leasehold Flat/Maisonette
W2 4TE - 1,172,000
- Leasehold Flat/Maisonette
W2 4TE - 1,677,000
- Leasehold Flat/Maisonette
W2 4TE - 974,000
- Leasehold Flat/Maisonette
W2 4TE - 1,017,000
- Leasehold Flat/Maisonette
W2 4TE - 1,455,000
- Leasehold Flat/Maisonette
W2 4TE - 1,303,000
- Leasehold Flat/Maisonette
W2 4TE - 944,000
- Leasehold Flat/Maisonette
W2 4TE - 979,000
- Leasehold Flat/Maisonette
W2 4TE - 1,040,000
- Leasehold Flat/Maisonette
W2 4TE - 955,000
- Leasehold Flat/Maisonette
W2 4TE - 1,038,000
- Leasehold Flat/Maisonette
W2 4TE - 1,440,000
- Leasehold Purpose built flat
W2 4TE - 964,000
- Leasehold Flat/Maisonette
W2 4TE - 1,519,000
- Leasehold Purpose built flat
W2 4TE - 1,681,000
- Leasehold Flat/Maisonette
W2 4TE - 921,000
- Leasehold Flat/Maisonette
W2 4TE - 1,280,000
- Leasehold Converted flat
W2 4TE - 1,729,000
- Leasehold Purpose built flat
W2 4TE - 942,000
- Leasehold Flat/Maisonette
W2 4TE - 963,000
- Leasehold Flat/Maisonette
W2 4TE - 1,185,000
- Leasehold Flat/Maisonette
W2 4TE - 878,000
- Leasehold Flat/Maisonette
W2 4TE - 973,000
- Leasehold Flat/Maisonette
W2 4TE - 903,000
- Leasehold Flat/Maisonette
W2 4TE - 962,000
- Leasehold Purpose built flat
W2 4TE - 876,000
- Leasehold Flat/Maisonette
W2 4TE - 1,497,000
- Leasehold Purpose built flat
W2 4TE - 885,000
- Leasehold Flat/Maisonette
W2 4TE - 1,265,000
- Leasehold Flat/Maisonette
W2 4TE - 1,456,000
- Leasehold Flat/Maisonette
W2 4TE - 1,140,000
- Leasehold Flat/Maisonette
W2 4TE - 1,614,000
- Leasehold Flat/Maisonette
W2 4TE - 1,569,000
- Leasehold Flat/Maisonette
W2 4TE - 1,564,000
- Leasehold Purpose built flat
W2 4TE - 935,000
- Leasehold Flat/Maisonette
W2 4TE - 1,486,000
- Leasehold Flat/Maisonette
W2 4TE - 936,000
- Leasehold Purpose built flat
W2 4TE - 912,000
- Leasehold Flat/Maisonette
W2 4TE - 786,000
- Leasehold Flat/Maisonette
W2 4TE - 1,291,000
- Leasehold Flat/Maisonette
W2 4TE - 1,405,000
- Leasehold Flat/Maisonette
W2 4TE - 1,442,000
- Leasehold Purpose built flat
W2 4TE - 1,075,000
- Leasehold Flat/Maisonette
W2 4TE - 1,264,000
- Leasehold Flat/Maisonette
W2 4TE - 1,068,000
- Leasehold Purpose built flat
W2 4TE - 1,414,000
- Leasehold Converted flat
