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 8BG' order by fulladdress
EC1V 8BG - 1,250,000
- Leasehold Purpose built flat
EC1V 8BG - 574,000
- Leasehold Purpose built flat
EC1V 8BG - 554,000
- Leasehold Flat/Maisonette
EC1V 8BG - 902,000
- Leasehold Flat/Maisonette
EC1V 8BG - 895,000
- Leasehold Flat/Maisonette
EC1V 8BG - 545,000
- Leasehold Flat/Maisonette
EC1V 8BG - 655,000
- Leasehold Flat/Maisonette
EC1V 8BG - 1,082,000
- Leasehold Flat/Maisonette
EC1V 8BG - 905,000
- Leasehold Purpose built flat
EC1V 8BG - 1,391,000
- Leasehold Flat/Maisonette
EC1V 8BG - 1,082,000
- Leasehold Converted flat
EC1V 8BG - 986,000
- Leasehold Flat/Maisonette
EC1V 8BG - 1,271,000
- Leasehold Purpose built flat
EC1V 8BG - 835,000
- Leasehold Flat/Maisonette
EC1V 8BG - 854,000
- Leasehold Terrace property
EC1V 8BG - 635,000
- Leasehold Terrace property
EC1V 8BG - 902,000
- Leasehold Flat/Maisonette
EC1V 8BG - 528,000
- Leasehold Purpose built flat
EC1V 8BG - 610,000
- Leasehold Flat/Maisonette
EC1V 8BG - 913,000
- Leasehold Flat/Maisonette
EC1V 8BG - 846,000
- Leasehold Converted flat
