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 3NH' order by fulladdress
E1W 3NH - 857,000
- Leasehold Flat/Maisonette
E1W 3NH - 1,077,000
- Leasehold Converted flat
E1W 3NH - 590,000
- Leasehold Converted flat
E1W 3NH - 492,000
- Leasehold Flat/Maisonette
E1W 3NH - 842,000
- Leasehold Flat/Maisonette
E1W 3NH - 946,000
- Leasehold Converted flat
E1W 3NH - 498,000
- Leasehold Converted flat
E1W 3NH - 457,000
- Leasehold Converted flat
E1W 3NH - 996,000
- Feudal Converted flat
E1W 3NH - 1,017,000
- Leasehold Flat/Maisonette
E1W 3NH - 1,002,000
- Leasehold Flat/Maisonette
E1W 3NH - 969,000
- Leasehold Purpose built flat
E1W 3NH - 600,000
- Leasehold Converted flat
E1W 3NH - 528,000
- Leasehold Flat/Maisonette
E1W 3NH - 900,000
- Feudal Converted flat
E1W 3NH - 1,037,000
- Leasehold Converted flat
E1W 3NH - 413,000
- Leasehold Flat/Maisonette
E1W 3NH - 436,000
- Leasehold Converted flat
E1W 3NH - 931,000
- Leasehold Flat/Maisonette
E1W 3NH - 1,340,000
- Leasehold Converted flat
E1W 3NH - 1,516,000
- Leasehold Converted flat
E1W 3NH - 980,000
- Leasehold Flat/Maisonette
E1W 3NH - 590,000
- Leasehold Purpose built flat
E1W 3NH - 587,000
- Leasehold Flat/Maisonette
E1W 3NH - 1,144,000
- Leasehold Flat/Maisonette
E1W 3NH - 645,000
- Leasehold Flat/Maisonette
E1W 3NH - 600,000
- Leasehold Flat/Maisonette
E1W 3NH - 1,082,000
- Leasehold Purpose built flat
E1W 3NH - 410,000
- Leasehold Flat/Maisonette
E1W 3NH - 905,000
- Leasehold Flat/Maisonette
E1W 3NH - 945,000
- Leasehold Flat/Maisonette
E1W 3NH - 907,000
- Leasehold Converted flat
E1W 3NH - 974,000
- Leasehold Converted flat
