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 1AF' order by fulladdress
EC1V 1AF - 935,000
- Leasehold Purpose built flat
EC1V 1AF - 1,109,000
- Leasehold Flat/Maisonette
EC1V 1AF - 960,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,530,000
- Leasehold Flat/Maisonette
EC1V 1AF - 808,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,153,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,138,000
- Leasehold Purpose built flat
EC1V 1AF - 778,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,094,000
- Leasehold Flat/Maisonette
EC1V 1AF - 776,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,720,000
- Leasehold Flat/Maisonette
EC1V 1AF - 711,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,500,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,165,000
- Leasehold Flat/Maisonette
EC1V 1AF - 783,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,590,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,791,000
- Leasehold Flat/Maisonette
EC1V 1AF - 835,000
- Leasehold Purpose built flat
EC1V 1AF - 1,157,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,178,000
- Leasehold Flat/Maisonette
EC1V 1AF - 839,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,733,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,728,000
- Leasehold Flat/Maisonette
EC1V 1AF - 823,000
- Leasehold Flat/Maisonette
EC1V 1AF - 1,704,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,620,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,405,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,056,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,237,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,195,000
- Leasehold Purpose built flat
EC1V 1AF - 2,057,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,154,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,250,000
- Leasehold Flat/Maisonette
EC1V 1AF - 2,038,000
- Leasehold Flat/Maisonette