SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW12 0HE' order by fulladdress
SW12 0HE - 656,000
- Leasehold Converted flat
SW12 0HE - 1,399,000
- Freehold Mid terrace house
SW12 0HE - 1,356,000
- Freehold Mid terrace house
SW12 0HE - 1,291,000
- Leasehold Mid terrace house
SW12 0HE - 1,337,000
- Freehold Mid terrace house
SW12 0HE - 1,327,000
- Freehold Mid terrace house
SW12 0HE - 1,460,000
- Freehold Mid terrace house
SW12 0HE - 976,000
- Leasehold Converted flat
SW12 0HE - 1,406,000
- Freehold Mid terrace house
SW12 0HE - 637,000
- Leasehold Flat/Maisonette
SW12 0HE - 712,000
- Leasehold Converted flat
SW12 0HE - 768,000
- Leasehold Purpose built flat
SW12 0HE - 770,000
- Leasehold Purpose built flat
SW12 0HE - 702,000
- Leasehold Purpose built flat
SW12 0HE - 743,000
- Leasehold Purpose built flat
SW12 0HE - 681,000
- Leasehold Purpose built flat
SW12 0HE - 694,000
- Leasehold Purpose built flat
SW12 0HE - 835,000
- Leasehold Purpose built flat
SW12 0HE - 728,000
- Leasehold Purpose built flat
SW12 0HE - 743,000
- Leasehold Flat/Maisonette
SW12 0HE - 769,000
- Leasehold Mid terrace house
SW12 0HE - 752,000
- Leasehold Flat/Maisonette
SW12 0HE - 725,000
- Leasehold Purpose built flat
SW12 0HE - 816,000
- Leasehold Flat/Maisonette
SW12 0HE - 771,000
- Leasehold Purpose built flat
SW12 0HE - 742,000
- Leasehold Purpose built flat
SW12 0HE - 759,000
- Leasehold Purpose built flat
SW12 0HE - 808,000
- Leasehold Purpose built flat
SW12 0HE - 744,000
- Leasehold Purpose built flat
SW12 0HE - 727,000
- Leasehold Converted flat
SW12 0HE - 753,000
- Leasehold Flat/Maisonette
SW12 0HE - 721,000
- Leasehold Converted flat
