SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='EC2A 4BY' order by fulladdress
EC2A 4BY - 647,000
- Leasehold Converted flat
EC2A 4BY - 700,000
- Leasehold Purpose built flat
EC2A 4BY - 696,000
- Leasehold Purpose built flat
EC2A 4BY - 864,000
- Leasehold Flat/Maisonette
EC2A 4BY - 836,000
- Leasehold Flat/Maisonette
EC2A 4BY - 651,000
- Leasehold Flat/Maisonette
EC2A 4BY - 651,000
- Leasehold Flat/Maisonette
EC2A 4BY - 654,000
- Leasehold Flat/Maisonette
EC2A 4BY - 708,000
- Leasehold Flat/Maisonette
EC2A 4BY - 718,000
- Leasehold Flat/Maisonette
EC2A 4BY - 810,000
- Leasehold Flat/Maisonette
EC2A 4BY - 874,000
- Leasehold Flat/Maisonette
EC2A 4BY - 951,000
- Leasehold Flat/Maisonette
EC2A 4BY - 844,000
- Feudal Purpose built flat
EC2A 4BY - 640,000
- Leasehold Flat/Maisonette
EC2A 4BY - 674,000
- Leasehold Flat/Maisonette
EC2A 4BY - 740,000
- Leasehold Flat/Maisonette
EC2A 4BY - 755,000
- Leasehold Flat/Maisonette
EC2A 4BY - 1,020,000
- Leasehold Flat/Maisonette
EC2A 4BY - 855,000
- Leasehold Flat/Maisonette
EC2A 4BY - 678,000
- Leasehold Purpose built flat
EC2A 4BY - 674,000
- Leasehold Purpose built flat
EC2A 4BY - 643,000
- Leasehold Flat/Maisonette
EC2A 4BY - 692,000
- Leasehold Flat/Maisonette
EC2A 4BY - 714,000
- Leasehold Flat/Maisonette
EC2A 4BY - 689,000
- Leasehold Purpose built flat
EC2A 4BY - 653,000
- Leasehold Purpose built flat
EC2A 4BY - 921,000
- Leasehold Flat/Maisonette
EC2A 4BY - 716,000
- Leasehold Flat/Maisonette
EC2A 4BY - 655,000
- Leasehold Flat/Maisonette
EC2A 4BY - 678,000
- Leasehold Flat/Maisonette
EC2A 4BY - 995,000
- Leasehold Purpose built flat
EC2A 4BY - 701,000
- Leasehold Flat/Maisonette
EC2A 4BY - 634,000
- Leasehold Flat/Maisonette
EC2A 4BY - 665,000
- Leasehold Flat/Maisonette
EC2A 4BY - 876,000
- Leasehold Purpose built flat
EC2A 4BY - 649,000
- Leasehold Flat/Maisonette
EC2A 4BY - 632,000
- Leasehold Flat/Maisonette
EC2A 4BY - 668,000
- Leasehold Flat/Maisonette
EC2A 4BY - 695,000
- Leasehold Purpose built flat
EC2A 4BY - 2,262,000
- Leasehold Purpose built flat
EC2A 4BY - 1,580,000
- Leasehold Purpose built flat
EC2A 4BY - 2,120,000
- Leasehold Purpose built flat