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 7JG' order by fulladdress
E14 7JG - 656,000
- Leasehold Flat/Maisonette
E14 7JG - 540,000
- Leasehold Flat/Maisonette
E14 7JG - 710,000
- Leasehold Flat/Maisonette
E14 7JG - 732,000
- Leasehold Flat/Maisonette
E14 7JG - 534,000
- Leasehold Flat/Maisonette
E14 7JG - 742,000
- Leasehold Flat/Maisonette
E14 7JG - 923,000
- Leasehold End terrace house
E14 7JG - 505,000
- Leasehold Flat/Maisonette
E14 7JG - 749,000
- Leasehold Flat/Maisonette
E14 7JG - 812,000
- Leasehold Flat/Maisonette
E14 7JG - 533,000
- Leasehold Purpose built flat
E14 7JG - 731,000
- Leasehold Flat/Maisonette
E14 7JG - 954,000
- Leasehold Purpose built flat
E14 7JG - 499,000
- Leasehold Purpose built flat
E14 7JG - 721,000
- Leasehold Flat/Maisonette
E14 7JG - 740,000
- Leasehold Purpose built flat
E14 7JG - 548,000
- Leasehold Flat/Maisonette
E14 7JG - 742,000
- Leasehold Flat/Maisonette
E14 7JG - 761,000
- Leasehold Flat/Maisonette
E14 7JG - 561,000
- Leasehold Purpose built flat
E14 7JG - 781,000
- Leasehold Purpose built flat
E14 7JG - 747,000
- Leasehold Flat/Maisonette
E14 7JG - 543,000
- Leasehold Purpose built flat
E14 7JG - 690,000
- Leasehold Flat/Maisonette
E14 7JG - 770,000
- Leasehold Purpose built flat
E14 7JG - 541,000
- Leasehold Purpose built flat
E14 7JG - 749,000
- Feudal Purpose built flat
E14 7JG - 770,000
- Feudal Purpose built flat
E14 7JG - 566,000
- Leasehold Purpose built flat
E14 7JG - 757,000
- Leasehold Flat/Maisonette
E14 7JG - 1,568,000
- Leasehold Purpose built flat