SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW6 2UX' order by fulladdress
SW6 2UX - 848,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,286,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,068,000
- Leasehold Purpose built flat
SW6 2UX - 1,030,000
- Leasehold Purpose built flat
SW6 2UX - 1,615,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,376,000
- Leasehold Purpose built flat
SW6 2UX - 976,000
- Leasehold Purpose built flat
SW6 2UX - 1,983,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,262,000
- Leasehold Flat/Maisonette
SW6 2UX - 840,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,848,000
- Feudal Purpose built flat
SW6 2UX - 873,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,279,000
- Leasehold Flat/Maisonette
SW6 2UX - 888,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,885,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,068,000
- Leasehold Purpose built flat
SW6 2UX - 841,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,448,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,286,000
- Leasehold Flat/Maisonette
SW6 2UX - 828,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,850,000
- Leasehold Purpose built flat
SW6 2UX - 1,030,000
- Leasehold Purpose built flat
SW6 2UX - 689,000
- Leasehold Purpose built flat
SW6 2UX - 860,000
- Leasehold Purpose built flat
SW6 2UX - 639,000
- Leasehold Flat/Maisonette
SW6 2UX - 938,000
- Leasehold Flat/Maisonette
SW6 2UX - 874,000
- Leasehold Flat/Maisonette
SW6 2UX - 937,000
- Leasehold Flat/Maisonette
SW6 2UX - 908,000
- Leasehold Flat/Maisonette
SW6 2UX - 855,000
- Leasehold Purpose built flat
SW6 2UX - 859,000
- Share of freehold Flat/Maisonette
SW6 2UX - 820,000
- Leasehold Purpose built flat
SW6 2UX - 2,670,000
- Leasehold Flat/Maisonette
SW6 2UX - 945,000
- Leasehold Flat/Maisonette
SW6 2UX - 883,000
- Leasehold Purpose built flat
SW6 2UX - 863,000
- Leasehold Flat/Maisonette
SW6 2UX - 853,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,244,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,249,000
- Leasehold Flat/Maisonette
SW6 2UX - 872,000
- Leasehold Purpose built flat
SW6 2UX - 1,187,000
- Leasehold Flat/Maisonette
SW6 2UX - 942,000
- Leasehold Flat/Maisonette
SW6 2UX - 964,000
- Leasehold Flat/Maisonette
SW6 2UX - 819,000
- Leasehold Purpose built flat
SW6 2UX - 859,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,085,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,893,000
- Leasehold Flat/Maisonette
SW6 2UX - 865,000
- Leasehold Purpose built flat
SW6 2UX - 1,352,000
- Leasehold Purpose built flat
SW6 2UX - 1,829,000
- Leasehold Flat/Maisonette
SW6 2UX - 987,000
- Leasehold Purpose built flat
SW6 2UX - 1,312,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,704,000
- Leasehold Purpose built flat
SW6 2UX - 1,034,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,007,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,803,000
- Leasehold Purpose built flat
SW6 2UX - 890,000
- Leasehold Purpose built flat
SW6 2UX - 1,193,000
- Leasehold Flat/Maisonette
SW6 2UX - 825,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,080,000
- Leasehold Flat/Maisonette
SW6 2UX - 1,874,000
- Feudal Purpose built flat
SW6 2UX - 809,000
- Leasehold Purpose built flat
SW6 2UX - 932,000
- Leasehold Flat/Maisonette
SW6 2UX - 918,000
- Leasehold Flat/Maisonette