SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E16 2NZ' order by fulladdress
E16 2NZ - 490,000
- Leasehold Purpose built flat
E16 2NZ - 625,000
- Leasehold Purpose built flat
E16 2NZ - 614,000
- Leasehold Purpose built flat
E16 2NZ - 622,000
- Leasehold Purpose built flat
E16 2NZ - 439,000
- Leasehold Purpose built flat
E16 2NZ - 419,000
- Feudal Purpose built flat
E16 2NZ - 614,000
- Leasehold Purpose built flat
E16 2NZ - 892,000
- Leasehold Terrace property
E16 2NZ - 622,000
- Leasehold Purpose built flat
E16 2NZ - 408,000
- Leasehold Purpose built flat
E16 2NZ - 631,000
- Leasehold Purpose built flat
E16 2NZ - 526,000
- Leasehold Purpose built flat
E16 2NZ - 606,000
- Leasehold Purpose built flat
E16 2NZ - 658,000
- Leasehold Purpose built flat
E16 2NZ - 403,000
- Leasehold Flat/Maisonette
E16 2NZ - 939,000
- Leasehold Mid terrace house
E16 2NZ - 930,000
- Leasehold End terrace house
E16 2NZ - 948,000
- Leasehold End terrace house
E16 2NZ - 946,000
- Leasehold Terrace property
E16 2NZ - 877,000
- Leasehold Mid terrace house
E16 2NZ - 916,000
- Leasehold Mid terrace house
E16 2NZ - 529,000
- Leasehold Flat/Maisonette
E16 2NZ - 1,219,000
- Leasehold Mid terrace house
E16 2NZ - 1,181,000
- Leasehold Mid terrace house
E16 2NZ - 1,225,000
- Leasehold Terrace property
E16 2NZ - 1,295,000
- Leasehold Detached house
E16 2NZ - 1,133,000
- Leasehold Detached house
E16 2NZ - 1,196,000
- Leasehold Terrace property
E16 2NZ - 1,016,000
- Leasehold Purpose built flat
E16 2NZ - 1,224,000
- Leasehold Mid terrace house
E16 2NZ - 1,254,000
- Leasehold Mid terrace house
E16 2NZ - 1,246,000
- Leasehold Mid terrace house
E16 2NZ - 618,000
- Leasehold Purpose built flat
E16 2NZ - 461,000
- Leasehold Purpose built flat
E16 2NZ - 399,000
- Feudal Purpose built flat
E16 2NZ - 412,000
- Leasehold Purpose built flat