SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW2 5EB' order by fulladdress
SW2 5EB - 1,314,000
- Freehold Semi-detached property
SW2 5EB - 871,000
- Leasehold Converted flat
SW2 5EB - 710,000
- Leasehold Flat/Maisonette
SW2 5EB - 875,000
- Leasehold Flat/Maisonette
SW2 5EB - 862,000
- Leasehold Flat/Maisonette
SW2 5EB - 770,000
- Leasehold Converted flat
SW2 5EB - 735,000
- Leasehold Flat/Maisonette
SW2 5EB - 824,000
- Leasehold Converted flat
SW2 5EB - 958,000
- Leasehold Converted flat
SW2 5EB - 750,000
- Leasehold Converted flat
SW2 5EB - 823,000
- Leasehold Converted flat
SW2 5EB - 952,000
- Leasehold Flat/Maisonette
SW2 5EB - 917,000
- Leasehold Converted flat
SW2 5EB - 946,000
- Leasehold Flat/Maisonette
SW2 5EB - 1,178,000
- Leasehold Converted flat
SW2 5EB - 715,000
- Leasehold Flat/Maisonette
SW2 5EB - 778,000
- Leasehold Converted flat
SW2 5EB - 968,000
- Leasehold Flat/Maisonette
SW2 5EB - 1,112,000
- Leasehold Converted flat
SW2 5EB - 856,000
- Leasehold Converted flat
SW2 5EB - 931,000
- Leasehold Converted flat
SW2 5EB - 935,000
- Leasehold Flat/Maisonette
SW2 5EB - 776,000
- Leasehold Converted flat
SW2 5EB - 759,000
- Leasehold Converted flat
SW2 5EB - 819,000
- Leasehold Converted flat
SW2 5EB - 882,000
- Leasehold Converted flat
SW2 5EB - 797,000
- Leasehold Converted flat
SW2 5EB - 923,000
- Leasehold Flat/Maisonette
SW2 5EB - 699,000
- Leasehold Converted flat
SW2 5EB - 806,000
- Leasehold Converted flat
SW2 5EB - 712,000
- Leasehold Flat/Maisonette
