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 8ZF' order by fulladdress
E1 8ZF - 732,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,302,000
- Leasehold Flat/Maisonette
E1 8ZF - 727,000
- Leasehold Purpose built flat
E1 8ZF - 587,000
- Leasehold Flat/Maisonette
E1 8ZF - 722,000
- Leasehold Flat/Maisonette
E1 8ZF - 980,000
- Leasehold Flat/Maisonette
E1 8ZF - 776,000
- Leasehold Purpose built flat
E1 8ZF - 724,000
- Leasehold Flat/Maisonette
E1 8ZF - 774,000
- Leasehold Flat/Maisonette
E1 8ZF - 958,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,186,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,132,000
- Leasehold Flat/Maisonette
E1 8ZF - 776,000
- Leasehold Purpose built flat
E1 8ZF - 1,114,000
- Leasehold Flat/Maisonette
E1 8ZF - 618,000
- Leasehold Purpose built flat
E1 8ZF - 613,000
- Leasehold Flat/Maisonette
E1 8ZF - 621,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,045,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,140,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,179,000
- Leasehold Flat/Maisonette
E1 8ZF - 883,000
- Leasehold Purpose built flat
E1 8ZF - 607,000
- Leasehold Flat/Maisonette
E1 8ZF - 709,000
- Leasehold Flat/Maisonette
E1 8ZF - 771,000
- Leasehold Purpose built flat
E1 8ZF - 1,092,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,180,000
- Leasehold Purpose built flat
E1 8ZF - 1,169,000
- Leasehold Flat/Maisonette
E1 8ZF - 922,000
- Leasehold Purpose built flat
E1 8ZF - 1,049,000
- Leasehold Flat/Maisonette
E1 8ZF - 575,000
- Leasehold Flat/Maisonette
E1 8ZF - 594,000
- Leasehold Flat/Maisonette
E1 8ZF - 610,000
- Leasehold Flat/Maisonette
E1 8ZF - 622,000
- Leasehold Purpose built flat
E1 8ZF - 1,185,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,174,000
- Leasehold Flat/Maisonette
E1 8ZF - 992,000
- Leasehold Flat/Maisonette
E1 8ZF - 892,000
- Leasehold Flat/Maisonette
E1 8ZF - 810,000
- Leasehold Flat/Maisonette
E1 8ZF - 731,000
- Leasehold Flat/Maisonette
E1 8ZF - 780,000
- Leasehold Flat/Maisonette
E1 8ZF - 994,000
- Leasehold Flat/Maisonette
E1 8ZF - 713,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,081,000
- Leasehold Flat/Maisonette
E1 8ZF - 713,000
- Leasehold Flat/Maisonette
E1 8ZF - 600,000
- Leasehold Flat/Maisonette
E1 8ZF - 646,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,021,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,191,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,197,000
- Leasehold Flat/Maisonette
E1 8ZF - 976,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,307,000
- Leasehold Flat/Maisonette
E1 8ZF - 612,000
- Leasehold Flat/Maisonette
E1 8ZF - 718,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,430,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,109,000
- Leasehold Flat/Maisonette
E1 8ZF - 1,169,000
- Leasehold Flat/Maisonette
