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 8PW' order by fulladdress
E1 8PW - 813,000
- Leasehold Flat/Maisonette
E1 8PW - 791,000
- Leasehold Flat/Maisonette
E1 8PW - 528,000
- Leasehold Flat/Maisonette
E1 8PW - 927,000
- Leasehold Flat/Maisonette
E1 8PW - 897,000
- Feudal Flat/Maisonette
E1 8PW - 950,000
- Leasehold Purpose built flat
E1 8PW - 786,000
- Leasehold Flat/Maisonette
E1 8PW - 873,000
- Leasehold Flat/Maisonette
E1 8PW - 643,000
- Leasehold Flat/Maisonette
E1 8PW - 790,000
- Leasehold Flat/Maisonette
E1 8PW - 1,227,000
- Leasehold Flat/Maisonette
E1 8PW - 856,000
- Leasehold Flat/Maisonette
E1 8PW - 1,338,000
- Leasehold Purpose built flat
E1 8PW - 789,000
- Leasehold Flat/Maisonette
E1 8PW - 1,197,000
- Leasehold Flat/Maisonette
E1 8PW - 1,493,000
- Leasehold Flat/Maisonette
E1 8PW - 570,000
- Leasehold Flat/Maisonette
E1 8PW - 1,474,000
- Leasehold Flat/Maisonette
E1 8PW - 562,000
- Leasehold Flat/Maisonette
E1 8PW - 2,165,000
- Leasehold Flat/Maisonette
E1 8PW - 854,000
- Leasehold Flat/Maisonette
E1 8PW - 945,000
- Leasehold Flat/Maisonette
E1 8PW - 667,000
- Leasehold Flat/Maisonette
E1 8PW - 946,000
- Leasehold Purpose built flat
E1 8PW - 657,000
- Leasehold Flat/Maisonette
E1 8PW - 798,000
- Leasehold Flat/Maisonette
E1 8PW - 1,014,000
- Leasehold Flat/Maisonette
E1 8PW - 666,000
- Leasehold Flat/Maisonette
E1 8PW - 982,000
- Leasehold Flat/Maisonette
E1 8PW - 653,000
- Leasehold Flat/Maisonette
E1 8PW - 814,000
- Leasehold Flat/Maisonette
E1 8PW - 1,010,000
- Leasehold Flat/Maisonette
E1 8PW - 664,000
- Leasehold Flat/Maisonette
E1 8PW - 885,000
- Leasehold Flat/Maisonette
E1 8PW - 655,000
- Leasehold Flat/Maisonette
E1 8PW - 857,000
- Leasehold Flat/Maisonette
E1 8PW - 966,000
- Leasehold Purpose built flat
E1 8PW - 663,000
- Leasehold Flat/Maisonette
E1 8PW - 949,000
- Leasehold Flat/Maisonette
E1 8PW - 528,000
- Leasehold Flat/Maisonette
E1 8PW - 799,000
- Leasehold Flat/Maisonette
E1 8PW - 962,000
- Leasehold Purpose built flat
E1 8PW - 652,000
- Leasehold Flat/Maisonette
E1 8PW - 931,000
- Leasehold Flat/Maisonette
E1 8PW - 652,000
- Leasehold Flat/Maisonette
E1 8PW - 950,000
- Leasehold Flat/Maisonette
E1 8PW - 1,024,000
- Leasehold Flat/Maisonette
E1 8PW - 657,000
- Leasehold Flat/Maisonette
E1 8PW - 950,000
- Leasehold Flat/Maisonette
E1 8PW - 698,000
- Leasehold Flat/Maisonette
E1 8PW - 637,000
- Leasehold Flat/Maisonette
E1 8PW - 819,000
- Leasehold Flat/Maisonette
E1 8PW - 963,000
- Leasehold Flat/Maisonette
E1 8PW - 656,000
- Leasehold Flat/Maisonette
E1 8PW - 956,000
- Leasehold Flat/Maisonette
E1 8PW - 637,000
- Leasehold Flat/Maisonette
E1 8PW - 788,000
- Leasehold Flat/Maisonette
E1 8PW - 1,321,000
- Leasehold Flat/Maisonette
E1 8PW - 1,167,000
- Leasehold Flat/Maisonette
E1 8PW - 651,000
- Leasehold Flat/Maisonette
E1 8PW - 637,000
- Leasehold Flat/Maisonette