SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='EC1M 5UQ' order by fulladdress
EC1M 5UQ - 3,152,000
- Freehold Mid terrace house
EC1M 5UQ - 917,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 934,000
- Freehold Flat/Maisonette
EC1M 5UQ - 691,000
- Leasehold Purpose built flat
EC1M 5UQ - 989,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 915,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 691,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 875,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 913,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 650,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 947,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 916,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 743,000
- Leasehold Purpose built flat
EC1M 5UQ - 678,000
- Leasehold Purpose built flat
EC1M 5UQ - 846,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 979,000
- Leasehold Purpose built flat
EC1M 5UQ - 825,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 947,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 898,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 927,000
- Leasehold Purpose built flat
EC1M 5UQ - 814,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 874,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 944,000
- Leasehold Purpose built flat
EC1M 5UQ - 978,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 1,071,000
- Leasehold Purpose built flat
EC1M 5UQ - 745,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 899,000
- Leasehold Purpose built flat
EC1M 5UQ - 795,000
- Leasehold Purpose built flat
EC1M 5UQ - 731,000
- Leasehold Flat/Maisonette
EC1M 5UQ - 735,000
- Leasehold Purpose built flat
EC1M 5UQ - 693,000
- Leasehold Purpose built flat
EC1M 5UQ - 794,000
- Freehold Flat/Maisonette