SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='EC1R 4UP' order by fulladdress
EC1R 4UP - 1,477,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,341,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,423,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,194,000
- Leasehold Purpose built flat
EC1R 4UP - 921,000
- Leasehold Flat/Maisonette
EC1R 4UP - 925,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,311,000
- Leasehold Flat/Maisonette
EC1R 4UP - 908,000
- Leasehold Flat/Maisonette
EC1R 4UP - 818,000
- Leasehold Converted flat
EC1R 4UP - 900,000
- Leasehold Converted flat
EC1R 4UP - 1,222,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,319,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,206,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,005,000
- Leasehold Converted flat
EC1R 4UP - 1,088,000
- Leasehold Flat/Maisonette
EC1R 4UP - 797,000
- Leasehold Converted flat
EC1R 4UP - 895,000
- Leasehold Converted flat
EC1R 4UP - 1,112,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,060,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,030,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,294,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,070,000
- Leasehold Converted flat
EC1R 4UP - 917,000
- Leasehold Purpose built flat
EC1R 4UP - 987,000
- Leasehold Converted flat
EC1R 4UP - 1,129,000
- Leasehold Converted flat
EC1R 4UP - 1,076,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,065,000
- Leasehold Converted flat
EC1R 4UP - 1,122,000
- Leasehold Flat/Maisonette
EC1R 4UP - 927,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,129,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,553,000
- Leasehold Flat/Maisonette
EC1R 4UP - 1,063,000
- Leasehold Flat/Maisonette
