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 8BH' order by fulladdress
E1 8BH - 590,000
- Leasehold Flat/Maisonette
E1 8BH - 593,000
- Leasehold Converted flat
E1 8BH - 630,000
- Leasehold Flat/Maisonette
E1 8BH - 642,000
- Leasehold Flat/Maisonette
E1 8BH - 697,000
- Leasehold Flat/Maisonette
E1 8BH - 691,000
- Leasehold Flat/Maisonette
E1 8BH - 733,000
- Leasehold Flat/Maisonette
E1 8BH - 537,000
- Leasehold Flat/Maisonette
E1 8BH - 685,000
- Leasehold Flat/Maisonette
E1 8BH - 648,000
- Leasehold Purpose built flat
E1 8BH - 669,000
- Leasehold Converted flat
E1 8BH - 575,000
- Leasehold Flat/Maisonette
E1 8BH - 603,000
- Leasehold Converted flat
E1 8BH - 638,000
- Leasehold Flat/Maisonette
E1 8BH - 609,000
- Leasehold Flat/Maisonette
E1 8BH - 652,000
- Leasehold Flat/Maisonette
E1 8BH - 534,000
- Leasehold Purpose built flat
E1 8BH - 672,000
- Leasehold Converted flat
E1 8BH - 624,000
- Leasehold Converted flat
E1 8BH - 648,000
- Leasehold Converted flat
E1 8BH - 649,000
- Leasehold Flat/Maisonette
E1 8BH - 666,000
- Feudal Converted flat
E1 8BH - 648,000
- Leasehold Flat/Maisonette
E1 8BH - 636,000
- Leasehold Flat/Maisonette
E1 8BH - 697,000
- Leasehold Converted flat
E1 8BH - 550,000
- Leasehold Flat/Maisonette
E1 8BH - 676,000
- Leasehold Converted flat
E1 8BH - 580,000
- Leasehold Flat/Maisonette
E1 8BH - 614,000
- Leasehold Flat/Maisonette
E1 8BH - 615,000
- Leasehold Converted flat
E1 8BH - 611,000
- Leasehold Flat/Maisonette
E1 8BH - 653,000
- Leasehold Purpose built flat
E1 8BH - 762,000
- Leasehold Purpose built flat
E1 8BH - 641,000
- Leasehold Purpose built flat
E1 8BH - 631,000
- Leasehold Flat/Maisonette
E1 8BH - 663,000
- Feudal Purpose built flat
E1 8BH - 707,000
- Leasehold Flat/Maisonette
E1 8BH - 669,000
- Leasehold Flat/Maisonette
E1 8BH - 646,000
- Leasehold Flat/Maisonette
E1 8BH - 502,000
- Leasehold Converted flat
E1 8BH - 729,000
- Leasehold Flat/Maisonette
E1 8BH - 678,000
- Leasehold Converted flat
E1 8BH - 672,000
- Leasehold Flat/Maisonette
E1 8BH - 629,000
- Leasehold Converted flat
E1 8BH - 617,000
- Leasehold Flat/Maisonette
E1 8BH - 641,000
- Leasehold Flat/Maisonette
E1 8BH - 644,000
- Leasehold Converted flat
E1 8BH - 630,000
- Leasehold Converted flat
E1 8BH - 643,000
- Leasehold Converted flat
E1 8BH - 663,000
- Feudal Converted flat
E1 8BH - 594,000
- Leasehold Flat/Maisonette
E1 8BH - 651,000
- Leasehold Flat/Maisonette
E1 8BH - 847,000
- Leasehold Flat/Maisonette
E1 8BH - 642,000
- Leasehold Flat/Maisonette
E1 8BH - 839,000
- Leasehold Converted flat
E1 8BH - 723,000
- Leasehold Flat/Maisonette
E1 8BH - 908,000
- Leasehold Purpose built flat
E1 8BH - 722,000
- Leasehold Flat/Maisonette
E1 8BH - 842,000
- Leasehold Purpose built flat
E1 8BH - 757,000
- Leasehold Converted flat
E1 8BH - 752,000
- Leasehold Purpose built flat
E1 8BH - 779,000
- Leasehold Converted flat
E1 8BH - 819,000
- Leasehold Flat/Maisonette
E1 8BH - 736,000
- Leasehold Flat/Maisonette
E1 8BH - 719,000
- Leasehold Flat/Maisonette
E1 8BH - 807,000
- Leasehold Flat/Maisonette
E1 8BH - 826,000
- Leasehold Flat/Maisonette
