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 9PT' order by fulladdress
E14 9PT - 477,000
- Leasehold Purpose built flat
E14 9PT - 1,058,000
- Freehold End terrace house
E14 9PT - 1,138,000
- Freehold Terraced
E14 9PT - 1,080,000
- Freehold Mid terrace house
E14 9PT - 1,155,000
- Freehold Mid terrace house
E14 9PT - 1,154,000
- Freehold Terraced
E14 9PT - 424,000
- Leasehold Purpose built flat
E14 9PT - 532,000
- Leasehold Flat/Maisonette
E14 9PT - 486,000
- Leasehold Purpose built flat
E14 9PT - 430,000
- Feudal Purpose built flat
E14 9PT - 462,000
- Leasehold Purpose built flat
E14 9PT - 483,000
- Leasehold Flat/Maisonette
E14 9PT - 1,087,000
- Freehold Mid terrace house
E14 9PT - 1,121,000
- Freehold End terrace house
E14 9PT - 1,138,000
- Freehold End terrace house
E14 9PT - 1,115,000
- Freehold Mid terrace house
E14 9PT - 1,069,000
- Freehold Mid terrace house
E14 9PT - 1,131,000
- Freehold Terraced
E14 9PT - 621,000
- Leasehold Purpose built flat
E14 9PT - 583,000
- Leasehold Purpose built flat
E14 9PT - 484,000
- Freehold Flat/Maisonette
E14 9PT - 543,000
- Leasehold Purpose built flat
E14 9PT - 561,000
- Leasehold Flat/Maisonette
E14 9PT - 752,000
- Feudal Purpose built flat
E14 9PT - 715,000
- Leasehold Purpose built flat
E14 9PT - 714,000
- Leasehold Purpose built flat
E14 9PT - 1,148,000
- Leasehold Purpose built flat
E14 9PT - 687,000
- Leasehold Flat/Maisonette
E14 9PT - 471,000
- Leasehold Purpose built flat
E14 9PT - 640,000
- Leasehold Purpose built flat
E14 9PT - 542,000
- Leasehold Purpose built flat
E14 9PT - 529,000
- Leasehold Purpose built flat
E14 9PT - 475,000
- Leasehold Flat/Maisonette
E14 9PT - 529,000
- Leasehold Flat/Maisonette
E14 9PT - 500,000
- Leasehold Flat/Maisonette
E14 9PT - 543,000
- Leasehold Flat/Maisonette