SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E1 8ZJ' order by fulladdress
E1 8ZJ - 1,773,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,567,000
- Leasehold Flat/Maisonette
E1 8ZJ - 820,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,361,000
- Leasehold Flat/Maisonette
E1 8ZJ - 852,000
- Leasehold Purpose built flat
E1 8ZJ - 1,707,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,554,000
- Leasehold Flat/Maisonette
E1 8ZJ - 734,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,472,000
- Leasehold Flat/Maisonette
E1 8ZJ - 896,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,336,000
- Leasehold Flat/Maisonette
E1 8ZJ - 962,000
- Leasehold Flat/Maisonette
E1 8ZJ - 862,000
- Leasehold Purpose built flat
E1 8ZJ - 1,326,000
- Leasehold Purpose built flat
E1 8ZJ - 984,000
- Leasehold Flat/Maisonette
E1 8ZJ - 891,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,302,000
- Leasehold Flat/Maisonette
E1 8ZJ - 899,000
- Leasehold Flat/Maisonette
E1 8ZJ - 900,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,327,000
- Leasehold Purpose built flat
E1 8ZJ - 992,000
- Leasehold Flat/Maisonette
E1 8ZJ - 923,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,342,000
- Leasehold Flat/Maisonette
E1 8ZJ - 961,000
- Leasehold Flat/Maisonette
E1 8ZJ - 894,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,387,000
- Leasehold Flat/Maisonette
E1 8ZJ - 967,000
- Leasehold Flat/Maisonette
E1 8ZJ - 915,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,356,000
- Leasehold Flat/Maisonette
E1 8ZJ - 971,000
- Leasehold Flat/Maisonette
E1 8ZJ - 898,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,355,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,004,000
- Leasehold Flat/Maisonette
E1 8ZJ - 896,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,293,000
- Flat/Maisonette
E1 8ZJ - 976,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,640,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,195,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,204,000
- Leasehold Flat/Maisonette
E1 8ZJ - 865,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,420,000
- Leasehold Flat/Maisonette
E1 8ZJ - 719,000
- Leasehold Flat/Maisonette
E1 8ZJ - 784,000
- Leasehold Flat/Maisonette
E1 8ZJ - 713,000
- Leasehold Flat/Maisonette
E1 8ZJ - 847,000
- Leasehold Flat/Maisonette
E1 8ZJ - 806,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,266,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,245,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,177,000
- Leasehold Flat/Maisonette
E1 8ZJ - 808,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,344,000
- Leasehold Flat/Maisonette
E1 8ZJ - 782,000
- Leasehold Flat/Maisonette
E1 8ZJ - 719,000
- Leasehold Flat/Maisonette
E1 8ZJ - 712,000
- Leasehold Flat/Maisonette
E1 8ZJ - 860,000
- Leasehold Flat/Maisonette
E1 8ZJ - 723,000
- Leasehold Purpose built flat
E1 8ZJ - 1,223,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,128,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,171,000
- Leasehold Flat/Maisonette
E1 8ZJ - 827,000
- Leasehold Flat/Maisonette
E1 8ZJ - 1,437,000
- Leasehold Flat/Maisonette
E1 8ZJ - 783,000
- Leasehold Flat/Maisonette
E1 8ZJ - 822,000
- Leasehold Flat/Maisonette
E1 8ZJ - 751,000
- Leasehold Flat/Maisonette
E1 8ZJ - 790,000
- Leasehold Flat/Maisonette