SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E16 2SE' order by fulladdress
E16 2SE - 866,000
- Leasehold Mid terrace house
E16 2SE - 589,000
- Leasehold Flat/Maisonette
E16 2SE - 460,000
- Leasehold Purpose built flat
E16 2SE - 532,000
- Leasehold Purpose built flat
E16 2SE - 500,000
- Leasehold Purpose built flat
E16 2SE - 508,000
- Leasehold Purpose built flat
E16 2SE - 540,000
- Leasehold Flat/Maisonette
E16 2SE - 558,000
- Leasehold Flat/Maisonette
E16 2SE - 551,000
- Leasehold Flat/Maisonette
E16 2SE - 477,000
- Leasehold Flat/Maisonette
E16 2SE - 549,000
- Leasehold Flat/Maisonette
E16 2SE - 488,000
- Leasehold Purpose built flat
E16 2SE - 586,000
- Leasehold Flat/Maisonette
E16 2SE - 501,000
- Leasehold Purpose built flat
E16 2SE - 491,000
- Leasehold Flat/Maisonette
E16 2SE - 479,000
- Leasehold Purpose built flat
E16 2SE - 584,000
- Leasehold Purpose built flat
E16 2SE - 522,000
- Leasehold Purpose built flat
E16 2SE - 563,000
- Leasehold Purpose built flat
E16 2SE - 502,000
- Leasehold Flat/Maisonette
E16 2SE - 515,000
- Leasehold Flat/Maisonette
E16 2SE - 558,000
- Leasehold Purpose built flat
E16 2SE - 485,000
- Leasehold Purpose built flat
E16 2SE - 603,000
- Leasehold Flat/Maisonette
E16 2SE - 524,000
- Leasehold Flat/Maisonette
E16 2SE - 599,000
- Leasehold Flat/Maisonette
E16 2SE - 538,000
- Leasehold Purpose built flat
E16 2SE - 436,000
- Leasehold Flat/Maisonette
E16 2SE - 542,000
- Leasehold Purpose built flat
E16 2SE - 798,000
- Freehold Purpose built flat
E16 2SE - 386,000
- Leasehold Flat/Maisonette
E16 2SE - 554,000
- Leasehold Purpose built flat
E16 2SE - 458,000
- Leasehold Purpose built flat
E16 2SE - 446,000
- Leasehold Purpose built flat
E16 2SE - 468,000
- Leasehold Flat/Maisonette
E16 2SE - 469,000
- Leasehold Flat/Maisonette
E16 2SE - 501,000
- Leasehold Purpose built flat
E16 2SE - 536,000
- Leasehold Purpose built flat
E16 2SE - 562,000
- Leasehold Purpose built flat
E16 2SE - 489,000
- Leasehold Flat/Maisonette
E16 2SE - 430,000
- Leasehold Purpose built flat
E16 2SE - 553,000
- Leasehold Purpose built flat
E16 2SE - 474,000
- Leasehold Purpose built flat
E16 2SE - 503,000
- Leasehold Purpose built flat
E16 2SE - 536,000
- Leasehold Purpose built flat
E16 2SE - 566,000
- Leasehold Purpose built flat
E16 2SE - 476,000
- Leasehold Purpose built flat
E16 2SE - 543,000
- Leasehold Purpose built flat
E16 2SE - 485,000
- Leasehold Purpose built flat
E16 2SE - 570,000
- Leasehold Flat/Maisonette
E16 2SE - 537,000
- Freehold Purpose built flat
E16 2SE - 512,000
- Leasehold Purpose built flat
E16 2SE - 599,000
- Leasehold Purpose built flat
E16 2SE - 494,000
- Leasehold Flat/Maisonette
E16 2SE - 547,000
- Leasehold Purpose built flat
E16 2SE - 549,000
- Leasehold Purpose built flat
E16 2SE - 436,000
- Leasehold Purpose built flat
E16 2SE - 564,000
- Leasehold Purpose built flat
E16 2SE - 441,000
- Leasehold Purpose built flat
E16 2SE - 554,000
- Leasehold Purpose built flat
E16 2SE - 832,000
- Leasehold Purpose built flat
E16 2SE - 873,000
- Leasehold Purpose built flat
