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 2NU' order by fulladdress
E1W 2NU - 1,088,000
- Leasehold Converted flat
E1W 2NU - 954,000
- Leasehold Converted flat
E1W 2NU - 818,000
- Leasehold Flat/Maisonette
E1W 2NU - 970,000
- Leasehold Flat/Maisonette
E1W 2NU - 623,000
- Leasehold Converted flat
E1W 2NU - 1,048,000
- Leasehold Flat/Maisonette
E1W 2NU - 631,000
- Leasehold Converted flat
E1W 2NU - 641,000
- Leasehold Converted flat
E1W 2NU - 748,000
- Leasehold Flat/Maisonette
E1W 2NU - 623,000
- Leasehold Converted flat
E1W 2NU - 1,054,000
- Leasehold Converted flat
E1W 2NU - 636,000
- Leasehold Flat/Maisonette
E1W 2NU - 661,000
- Leasehold Purpose built flat
E1W 2NU - 844,000
- Leasehold Flat/Maisonette
E1W 2NU - 654,000
- Leasehold Converted flat
E1W 2NU - 629,000
- Leasehold Converted flat
E1W 2NU - 606,000
- Leasehold Flat/Maisonette
E1W 2NU - 655,000
- Leasehold Flat/Maisonette
E1W 2NU - 558,000
- Leasehold Converted flat
E1W 2NU - 648,000
- Leasehold Purpose built flat
E1W 2NU - 1,638,000
- Leasehold Converted flat
E1W 2NU - 642,000
- Leasehold Purpose built flat
E1W 2NU - 669,000
- Leasehold Converted flat
E1W 2NU - 746,000
- Leasehold Purpose built flat
E1W 2NU - 1,084,000
- Leasehold Converted flat
E1W 2NU - 928,000
- Leasehold Converted flat
E1W 2NU - 990,000
- Leasehold Converted flat
E1W 2NU - 1,699,000
- Leasehold Converted flat
E1W 2NU - 971,000
- Leasehold Flat/Maisonette
E1W 2NU - 922,000
- Leasehold Converted flat
E1W 2NU - 748,000
- Leasehold Converted flat
E1W 2NU - 1,033,000
- Leasehold Converted flat
E1W 2NU - 930,000
- Leasehold Flat/Maisonette
E1W 2NU - 939,000
- Leasehold Converted flat
E1W 2NU - 728,000
- Leasehold Flat/Maisonette
E1W 2NU - 1,103,000
- Leasehold Flat/Maisonette
E1W 2NU - 1,039,000
- Leasehold Converted flat
E1W 2NU - 1,032,000
- Leasehold Flat/Maisonette
E1W 2NU - 1,102,000
- Leasehold Flat/Maisonette
E1W 2NU - 1,046,000
- Feudal Converted flat
