SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E2 0BU' order by fulladdress
E2 0BU - 647,000
- Leasehold Flat/Maisonette
E2 0BU - 599,000
- Leasehold Purpose built flat
E2 0BU - 578,000
- Leasehold Converted flat
E2 0BU - 639,000
- Leasehold Purpose built flat
E2 0BU - 594,000
- Leasehold Purpose built flat
E2 0BU - 622,000
- Leasehold Flat/Maisonette
E2 0BU - 579,000
- Leasehold Purpose built flat
E2 0BU - 574,000
- Leasehold Flat/Maisonette
E2 0BU - 582,000
- Leasehold Purpose built flat
E2 0BU - 550,000
- Leasehold Purpose built flat
E2 0BU - 679,000
- Leasehold Flat/Maisonette
E2 0BU - 605,000
- Leasehold Converted flat
E2 0BU - 598,000
- Leasehold Purpose built flat
E2 0BU - 549,000
- Leasehold Purpose built flat
E2 0BU - 608,000
- Leasehold Purpose built flat
E2 0BU - 683,000
- Leasehold Flat/Maisonette
E2 0BU - 588,000
- Leasehold Purpose built flat
E2 0BU - 626,000
- Leasehold Purpose built flat
E2 0BU - 581,000
- Feudal Purpose built flat
E2 0BU - 660,000
- Leasehold Converted flat
E2 0BU - 619,000
- Leasehold Flat/Maisonette
E2 0BU - 592,000
- Leasehold Purpose built flat
E2 0BU - 577,000
- Leasehold Purpose built flat
E2 0BU - 577,000
- Feudal Converted flat
E2 0BU - 596,000
- Leasehold Purpose built flat
E2 0BU - 620,000
- Leasehold Purpose built flat
E2 0BU - 572,000
- Leasehold Purpose built flat
E2 0BU - 703,000
- Leasehold Mid terrace house
E2 0BU - 502,000
- Leasehold Purpose built flat
E2 0BU - 395,000
- Leasehold Converted flat
E2 0BU - 483,000
- Leasehold Purpose built flat
E2 0BU - 383,000
- Leasehold Converted flat
E2 0BU - 467,000
- Leasehold Purpose built flat
E2 0BU - 316,000
- Leasehold Purpose built flat
E2 0BU - 425,000
- Leasehold Purpose built flat
E2 0BU - 330,000
- Leasehold Flat/Maisonette
E2 0BU - 471,000
- Leasehold Flat/Maisonette
E2 0BU - 335,000
- Leasehold Converted flat
E2 0BU - 507,000
- Leasehold Purpose built flat
E2 0BU - 350,000
- Leasehold Purpose built flat
E2 0BU - 448,000
- Leasehold Purpose built flat
E2 0BU - 323,000
- Leasehold Purpose built flat
E2 0BU - 499,000
- Leasehold Purpose built flat
E2 0BU - 475,000
- Leasehold Purpose built flat
E2 0BU - 361,000
- Leasehold Flat/Maisonette
E2 0BU - 523,000
- Leasehold Flat/Maisonette
E2 0BU - 337,000
- Leasehold Purpose built flat
E2 0BU - 391,000
- Leasehold Purpose built flat
E2 0BU - 483,000
- Leasehold Purpose built flat
E2 0BU - 430,000
- Purpose built flat
E2 0BU - 365,000
- Leasehold Purpose built flat
E2 0BU - 437,000
- Leasehold Flat/Maisonette
E2 0BU - 366,000
- Leasehold Purpose built flat
E2 0BU - 452,000
- Leasehold Purpose built flat
E2 0BU - 327,000
- Leasehold Purpose built flat
E2 0BU - 440,000
- Leasehold Purpose built flat