SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E14 8DB' order by fulladdress
E14 8DB - 1,466,000
- Freehold Detached house
E14 8DB - 1,458,000
- Freehold Mid terrace house
E14 8DB - 1,557,000
- Freehold Mid terrace house
E14 8DB - 1,344,000
- Freehold Mid terrace house
E14 8DB - 1,483,000
- Freehold Terrace property
E14 8DB - 1,655,000
- Leasehold Semi-detached house
E14 8DB - 1,450,000
- Freehold Mid terrace house
E14 8DB - 1,503,000
- Freehold Mid terrace house
E14 8DB - 1,355,000
- Freehold End terrace house
E14 8DB - 1,753,000
- Freehold End terrace house
E14 8DB - 1,430,000
- Freehold Detached house
E14 8DB - 1,599,000
- Freehold Mid terrace house
E14 8DB - 1,535,000
- Freehold Mid terrace bungalow
E14 8DB - 1,289,000
- Freehold Mid terrace house
E14 8DB - 1,339,000
- Freehold Mid terrace house
E14 8DB - 1,591,000
- Freehold Semi-detached property
E14 8DB - 858,000
- Leasehold Purpose built flat
E14 8DB - 593,000
- Leasehold Purpose built flat
E14 8DB - 652,000
- Leasehold Flat/Maisonette
E14 8DB - 740,000
- Leasehold Purpose built flat
E14 8DB - 476,000
- Leasehold Purpose built flat
E14 8DB - 659,000
- Leasehold Converted flat
E14 8DB - 724,000
- Leasehold Flat/Maisonette
E14 8DB - 866,000
- Leasehold Purpose built flat
E14 8DB - 610,000
- Leasehold Flat/Maisonette
E14 8DB - 688,000
- Leasehold Purpose built flat
E14 8DB - 866,000
- Leasehold Purpose built flat
E14 8DB - 464,000
- Leasehold Purpose built flat
E14 8DB - 658,000
- Leasehold Flat/Maisonette
E14 8DB - 749,000
- Leasehold Flat/Maisonette
E14 8DB - 447,000
- Leasehold Purpose built flat
E14 8DB - 664,000
- Leasehold Purpose built flat
E14 8DB - 705,000
- Leasehold Flat/Maisonette
E14 8DB - 522,000
- Leasehold Purpose built flat
