SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E1W 1AH' order by fulladdress
E1W 1AH - 933,000
- Leasehold Purpose built flat
E1W 1AH - 1,464,000
- Leasehold Flat/Maisonette
E1W 1AH - 995,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,424,000
- Leasehold Purpose built flat
E1W 1AH - 862,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,440,000
- Leasehold Purpose built flat
E1W 1AH - 1,084,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,155,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,504,000
- Leasehold Purpose built flat
E1W 1AH - 1,501,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,040,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,556,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,596,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,031,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,554,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,475,000
- Leasehold Purpose built flat
E1W 1AH - 1,059,000
- Leasehold Flat/Maisonette
E1W 1AH - 1,534,000
- Leasehold Flat/Maisonette
E1W 1AH - 2,382,000
- Leasehold Converted flat
E1W 1AH - 2,475,000
- Feudal Purpose built flat
