SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='EC4A 1BX' order by fulladdress
EC4A 1BX - 407,000
- Leasehold Purpose built flat
EC4A 1BX - 417,000
- Leasehold Flat/Maisonette
EC4A 1BX - 531,000
- Leasehold Purpose built flat
EC4A 1BX - 556,000
- Leasehold Flat/Maisonette
EC4A 1BX - 678,000
- Leasehold Converted flat
EC4A 1BX - 372,000
- Leasehold Flat/Maisonette
EC4A 1BX - 643,000
- Leasehold Purpose built flat
EC4A 1BX - 398,000
- Freehold Flat/Maisonette
EC4A 1BX - 709,000
- Leasehold Purpose built flat
EC4A 1BX - 461,000
- Leasehold Flat/Maisonette
EC4A 1BX - 554,000
- Leasehold Flat/Maisonette
EC4A 1BX - 543,000
- Leasehold Flat/Maisonette
EC4A 1BX - 530,000
- Leasehold Flat/Maisonette
EC4A 1BX - 537,000
- Leasehold Flat/Maisonette
EC4A 1BX - 358,000
- Leasehold Flat/Maisonette
EC4A 1BX - 389,000
- Leasehold Purpose built flat
EC4A 1BX - 344,000
- Feudal Purpose built flat
EC4A 1BX - 567,000
- Leasehold Flat/Maisonette
EC4A 1BX - 544,000
- Leasehold Purpose built flat
EC4A 1BX - 541,000
- Leasehold Flat/Maisonette
EC4A 1BX - 603,000
- Leasehold Flat/Maisonette
EC4A 1BX - 513,000
- Leasehold Flat/Maisonette
EC4A 1BX - 677,000
- Leasehold Flat/Maisonette
EC4A 1BX - 562,000
- Feudal Purpose built flat
EC4A 1BX - 500,000
- Leasehold Purpose built flat
EC4A 1BX - 346,000
- Leasehold Flat/Maisonette
EC4A 1BX - 379,000
- Leasehold Flat/Maisonette
EC4A 1BX - 726,000
- Leasehold Flat/Maisonette
EC4A 1BX - 427,000
- Leasehold Flat/Maisonette
EC4A 1BX - 508,000
- Leasehold Flat/Maisonette
EC4A 1BX - 528,000
- Leasehold Purpose built flat
EC4A 1BX - 390,000
- Leasehold Flat/Maisonette
EC4A 1BX - 378,000
- Leasehold Flat/Maisonette
EC4A 1BX - 550,000
- Leasehold Flat/Maisonette
EC4A 1BX - 542,000
- Leasehold Purpose built flat
EC4A 1BX - 387,000
- Leasehold Flat/Maisonette
EC4A 1BX - 655,000
- Leasehold Flat/Maisonette
EC4A 1BX - 582,000
- Leasehold Flat/Maisonette
EC4A 1BX - 556,000
- Leasehold Purpose built flat
EC4A 1BX - 350,000
- Leasehold Flat/Maisonette
EC4A 1BX - 425,000
- Leasehold Flat/Maisonette
EC4A 1BX - 440,000
- Leasehold Flat/Maisonette
EC4A 1BX - 559,000
- Leasehold Converted flat
EC4A 1BX - 476,000
- Leasehold Flat/Maisonette
EC4A 1BX - 514,000
- Leasehold Flat/Maisonette
EC4A 1BX - 591,000
- Leasehold Flat/Maisonette