SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E17 6ZE' order by fulladdress
E17 6ZE - 513,000
- Leasehold Purpose built flat
E17 6ZE - 521,000
- Leasehold Flat/Maisonette
E17 6ZE - 395,000
- Leasehold Purpose built flat
E17 6ZE - 515,000
- Leasehold Flat/Maisonette
E17 6ZE - 401,000
- Leasehold Flat/Maisonette
E17 6ZE - 513,000
- Leasehold Flat/Maisonette
E17 6ZE - 401,000
- Leasehold Flat/Maisonette
E17 6ZE - 516,000
- Leasehold Purpose built flat
E17 6ZE - 525,000
- Leasehold Flat/Maisonette
E17 6ZE - 388,000
- Leasehold Purpose built flat
E17 6ZE - 526,000
- Leasehold Purpose built flat
E17 6ZE - 517,000
- Leasehold Flat/Maisonette
E17 6ZE - 396,000
- Leasehold Purpose built flat
E17 6ZE - 388,000
- Leasehold Purpose built flat
E17 6ZE - 512,000
- Leasehold Flat/Maisonette
E17 6ZE - 404,000
- Leasehold Flat/Maisonette
E17 6ZE - 518,000
- Leasehold Purpose built flat
E17 6ZE - 498,000
- Leasehold Flat/Maisonette
E17 6ZE - 528,000
- Leasehold Purpose built flat
E17 6ZE - 451,000
- Leasehold Flat/Maisonette
E17 6ZE - 406,000
- Leasehold Flat/Maisonette
E17 6ZE - 409,000
- Leasehold Flat/Maisonette
E17 6ZE - 381,000
- Leasehold Purpose built flat
E17 6ZE - 602,000
- Leasehold Flat/Maisonette
E17 6ZE - 540,000
- Leasehold Flat/Maisonette
E17 6ZE - 604,000
- Leasehold Purpose built flat
E17 6ZE - 398,000
- Leasehold Flat/Maisonette
E17 6ZE - 570,000
- Leasehold Flat/Maisonette
E17 6ZE - 632,000
- Leasehold Flat/Maisonette
E17 6ZE - 502,000
- Leasehold Purpose built flat
E17 6ZE - 396,000
- Leasehold Purpose built flat
E17 6ZE - 394,000
- Leasehold Purpose built flat
E17 6ZE - 500,000
- Leasehold Purpose built flat
E17 6ZE - 401,000
- Leasehold Flat/Maisonette
E17 6ZE - 499,000
- Leasehold Purpose built flat
