SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW11 3YR' order by fulladdress
SW11 3YR - 969,000
- Leasehold Purpose built flat
SW11 3YR - 921,000
- Leasehold Purpose built flat
SW11 3YR - 834,000
- Leasehold Purpose built flat
SW11 3YR - 938,000
- Leasehold Flat/Maisonette
SW11 3YR - 803,000
- Leasehold Purpose built flat
SW11 3YR - 837,000
- Leasehold Flat/Maisonette
SW11 3YR - 1,393,000
- Leasehold Flat/Maisonette
SW11 3YR - 1,286,000
- Leasehold Purpose built flat
SW11 3YR - 946,000
- Leasehold Purpose built flat
SW11 3YR - 873,000
- Leasehold Purpose built flat
SW11 3YR - 859,000
- Leasehold Purpose built flat
SW11 3YR - 782,000
- Leasehold Purpose built flat
SW11 3YR - 856,000
- Leasehold Flat/Maisonette
SW11 3YR - 909,000
- Leasehold Flat/Maisonette
SW11 3YR - 948,000
- Leasehold Flat/Maisonette
SW11 3YR - 942,000
- Leasehold Flat/Maisonette
SW11 3YR - 817,000
- Leasehold Flat/Maisonette
SW11 3YR - 895,000
- Leasehold Purpose built flat
SW11 3YR - 905,000
- Leasehold Purpose built flat
SW11 3YR - 785,000
- Leasehold Purpose built flat
SW11 3YR - 941,000
- Leasehold Flat/Maisonette
SW11 3YR - 1,018,000
- Leasehold Flat/Maisonette
SW11 3YR - 875,000
- Leasehold Flat/Maisonette
SW11 3YR - 934,000
- Leasehold Flat/Maisonette
SW11 3YR - 1,356,000
- Leasehold Flat/Maisonette
SW11 3YR - 1,060,000
- Leasehold Flat/Maisonette
SW11 3YR - 1,274,000
- Leasehold Purpose built flat
SW11 3YR - 893,000
- Leasehold Flat/Maisonette
SW11 3YR - 827,000
- Leasehold Flat/Maisonette
SW11 3YR - 855,000
- Leasehold Flat/Maisonette
SW11 3YR - 910,000
- Leasehold Flat/Maisonette
SW11 3YR - 828,000
- Leasehold Flat/Maisonette
SW11 3YR - 840,000
- Leasehold Purpose built flat
SW11 3YR - 920,000
- Leasehold Flat/Maisonette
SW11 3YR - 815,000
- Leasehold Purpose built flat
SW11 3YR - 853,000
- Leasehold Purpose built flat
SW11 3YR - 844,000
- Leasehold Purpose built flat
SW11 3YR - 834,000
- Leasehold Flat/Maisonette
SW11 3YR - 896,000
- Leasehold Purpose built flat
SW11 3YR - 776,000
- Leasehold Purpose built flat
SW11 3YR - 941,000
- Feudal Purpose built flat
SW11 3YR - 888,000
- Leasehold Purpose built flat
SW11 3YR - 1,288,000
- Leasehold Purpose built flat
SW11 3YR - 1,204,000
- Leasehold Flat/Maisonette
SW11 3YR - 1,209,000
- Leasehold Flat/Maisonette
SW11 3YR - 934,000
- Leasehold Purpose built flat
SW11 3YR - 963,000
- Leasehold Purpose built flat
SW11 3YR - 853,000
- Leasehold Purpose built flat
SW11 3YR - 904,000
- Leasehold Flat/Maisonette