SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW20 8HJ' order by fulladdress
SW20 8HJ - 613,000
- Leasehold Purpose built flat
SW20 8HJ - 689,000
- Leasehold Purpose built flat
SW20 8HJ - 883,000
- Leasehold Flat/Maisonette
SW20 8HJ - 787,000
- Leasehold Flat/Maisonette
SW20 8HJ - 1,390,000
- Leasehold Purpose built flat
SW20 8HJ - 907,000
- Leasehold Flat/Maisonette
SW20 8HJ - 843,000
- Leasehold Flat/Maisonette
SW20 8HJ - 773,000
- Leasehold Flat/Maisonette
SW20 8HJ - 898,000
- Leasehold Flat/Maisonette
SW20 8HJ - 908,000
- Leasehold Flat/Maisonette
SW20 8HJ - 1,021,000
- Leasehold Detached house
SW20 8HJ - 880,000
- Leasehold Flat/Maisonette
SW20 8HJ - 747,000
- Leasehold Flat/Maisonette
SW20 8HJ - 789,000
- Leasehold Purpose built flat
SW20 8HJ - 1,065,000
- Leasehold Flat/Maisonette
SW20 8HJ - 838,000
- Leasehold Flat/Maisonette
SW20 8HJ - 805,000
- Leasehold Purpose built flat
SW20 8HJ - 1,027,000
- Leasehold Flat/Maisonette
SW20 8HJ - 788,000
- Leasehold Purpose built flat
SW20 8HJ - 726,000
- Leasehold Flat/Maisonette
SW20 8HJ - 745,000
- Leasehold Flat/Maisonette
SW20 8HJ - 762,000
- Leasehold Flat/Maisonette
SW20 8HJ - 1,152,000
- Leasehold Flat/Maisonette
SW20 8HJ - 773,000
- Leasehold Flat/Maisonette
SW20 8HJ - 894,000
- Leasehold Purpose built flat
SW20 8HJ - 720,000
- Leasehold Flat/Maisonette