SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='EC1V 8AZ' order by fulladdress
EC1V 8AZ - 729,000
- Leasehold Purpose built flat
EC1V 8AZ - 569,000
- Leasehold Purpose built flat
EC1V 8AZ - 544,000
- Leasehold Purpose built flat
EC1V 8AZ - 561,000
- Leasehold Purpose built flat
EC1V 8AZ - 713,000
- Feudal Purpose built flat
EC1V 8AZ - 724,000
- Leasehold Purpose built flat
EC1V 8AZ - 533,000
- Leasehold Purpose built flat
EC1V 8AZ - 569,000
- Leasehold Purpose built flat
EC1V 8AZ - 721,000
- Leasehold Purpose built flat
EC1V 8AZ - 691,000
- Leasehold Purpose built flat
EC1V 8AZ - 549,000
- Leasehold Purpose built flat
EC1V 8AZ - 701,000
- Leasehold Purpose built flat
EC1V 8AZ - 737,000
- Leasehold Purpose built flat
EC1V 8AZ - 796,000
- Leasehold Purpose built flat
EC1V 8AZ - 822,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 694,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 567,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 695,000
- Leasehold Purpose built flat
EC1V 8AZ - 530,000
- Leasehold Purpose built flat
EC1V 8AZ - 747,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 803,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 781,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 727,000
- Leasehold Purpose built flat
EC1V 8AZ - 641,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 719,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 932,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 810,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 742,000
- Leasehold Purpose built flat
EC1V 8AZ - 499,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 732,000
- Leasehold Purpose built flat
EC1V 8AZ - 840,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 829,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 712,000
- Leasehold Purpose built flat
EC1V 8AZ - 565,000
- Leasehold Purpose built flat
EC1V 8AZ - 835,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 823,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 838,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 829,000
- Leasehold Purpose built flat
EC1V 8AZ - 885,000
- Leasehold Purpose built flat
EC1V 8AZ - 865,000
- Feudal Purpose built flat
EC1V 8AZ - 730,000
- Leasehold Purpose built flat
EC1V 8AZ - 539,000
- Leasehold Purpose built flat
EC1V 8AZ - 543,000
- Leasehold Purpose built flat
EC1V 8AZ - 821,000
- Leasehold Purpose built flat
EC1V 8AZ - 550,000
- Feudal Purpose built flat
EC1V 8AZ - 595,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 516,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 529,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 816,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 510,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 595,000
- Leasehold Purpose built flat
EC1V 8AZ - 544,000
- Leasehold Purpose built flat
EC1V 8AZ - 543,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 744,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 531,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 586,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 528,000
- Leasehold Flat/Maisonette
EC1V 8AZ - 549,000
- Feudal Purpose built flat