SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E3 2DA' order by fulladdress
E3 2DA - 391,000
- Leasehold Converted flat
E3 2DA - 413,000
- Leasehold Converted flat
E3 2DA - 827,000
- Purpose built flat
E3 2DA - 987,000
- Leasehold Purpose built flat
E3 2DA - 1,280,000
- Freehold Mid terrace house
E3 2DA - 1,368,000
- Freehold Mid terrace house
E3 2DA - 1,295,000
- Freehold Terraced
E3 2DA - 1,315,000
- Freehold Detached house
E3 2DA - 1,521,000
- Freehold Mid terrace house
E3 2DA - 1,377,000
- Mid terrace house
E3 2DA - 1,223,000
- Freehold Terraced
E3 2DA - 1,324,000
- Freehold Mid terrace house
E3 2DA - 1,671,000
- Freehold Mid terrace house
E3 2DA - 1,348,000
- Freehold Mid terrace house
E3 2DA - 934,000
- Freehold End terrace house
E3 2DA - 832,000
- Freehold Mid terrace house
E3 2DA - 893,000
- Freehold Mid terrace house
E3 2DA - 976,000
- Freehold Mid terrace house
E3 2DA - 1,440,000
- Freehold Mid terrace house
E3 2DA - 1,350,000
- Freehold Mid terrace house
E3 2DA - 1,215,000
- Freehold Terraced
E3 2DA - 1,222,000
- Freehold Mid terrace house
E3 2DA - 1,409,000
- Freehold Mid terrace house
E3 2DA - 1,273,000
- Terrace property
E3 2DA - 1,109,000
- Terrace property
E3 2DA - 1,031,000
- Mid terrace house
E3 2DA - 1,284,000
- End terrace house
E3 2DA - 1,661,000
- Freehold End terrace house
E3 2DA - 454,000
- Leasehold Flat/Maisonette
E3 2DA - 546,000
- Leasehold Flat/Maisonette
E3 2DA - 951,000
- Mid terrace house
E3 2DA - 2,008,000
- Freehold Semi-detached house
