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 2UU' order by fulladdress
SW6 2UU - 853,000
- Leasehold Purpose built flat
SW6 2UU - 845,000
- Leasehold Purpose built flat
SW6 2UU - 840,000
- Leasehold Purpose built flat
SW6 2UU - 954,000
- Leasehold Flat/Maisonette
SW6 2UU - 863,000
- Leasehold Purpose built flat
SW6 2UU - 969,000
- Leasehold Purpose built flat
SW6 2UU - 902,000
- Leasehold Purpose built flat
SW6 2UU - 960,000
- Leasehold Flat/Maisonette
SW6 2UU - 1,012,000
- Freehold Purpose built flat
SW6 2UU - 866,000
- Leasehold Flat/Maisonette
SW6 2UU - 915,000
- Leasehold Flat/Maisonette
SW6 2UU - 877,000
- Leasehold Flat/Maisonette
SW6 2UU - 968,000
- Leasehold Purpose built flat
SW6 2UU - 828,000
- Leasehold Purpose built flat
SW6 2UU - 825,000
- Leasehold Flat/Maisonette
SW6 2UU - 1,265,000
- Leasehold Purpose built flat
SW6 2UU - 832,000
- Leasehold Purpose built flat
SW6 2UU - 845,000
- Leasehold Flat/Maisonette
SW6 2UU - 926,000
- Share of freehold Flat/Maisonette
SW6 2UU - 928,000
- Leasehold Flat/Maisonette
SW6 2UU - 813,000
- Leasehold Flat/Maisonette
SW6 2UU - 808,000
- Leasehold Flat/Maisonette
SW6 2UU - 903,000
- Leasehold Flat/Maisonette
SW6 2UU - 827,000
- Leasehold Flat/Maisonette
SW6 2UU - 1,115,000
- Leasehold Purpose built flat
SW6 2UU - 818,000
- Leasehold Purpose built flat
SW6 2UU - 973,000
- Leasehold Flat/Maisonette
SW6 2UU - 903,000
- Leasehold Flat/Maisonette
SW6 2UU - 835,000
- Leasehold Flat/Maisonette
SW6 2UU - 898,000
- Leasehold Purpose built flat
SW6 2UU - 780,000
- Leasehold Purpose built flat
SW6 2UU - 631,000
- Leasehold Purpose built flat
SW6 2UU - 774,000
- Leasehold Flat/Maisonette
SW6 2UU - 1,329,000
- Leasehold Flat/Maisonette
SW6 2UU - 912,000
- Leasehold Purpose built flat
SW6 2UU - 915,000
- Leasehold Flat/Maisonette
SW6 2UU - 834,000
- Leasehold Flat/Maisonette
SW6 2UU - 822,000
- Leasehold Flat/Maisonette