SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E11 2DY' order by fulladdress
E11 2DY - 1,356,000
- Freehold Semi-detached property
E11 2DY - 1,160,000
- Freehold Semi-detached house
E11 2DY - 1,264,000
- Freehold Semi-detached house
E11 2DY - 958,000
- Freehold Semi-detached house
E11 2DY - 1,186,000
- Freehold Semi-detached house
E11 2DY - 1,136,000
- Freehold Semi-detached house
E11 2DY - 1,192,000
- Freehold Semi-detached house
E11 2DY - 1,032,000
- Freehold Semi-detached house
E11 2DY - 1,038,000
- Freehold Semi-detached house
E11 2DY - 1,339,000
- Freehold Semi-detached house
E11 2DY - 1,250,000
- Freehold Detached house
E11 2DY - 1,028,000
- Freehold Detached house
E11 2DY - 1,195,000
- Freehold Semi-detached property
E11 2DY - 1,241,000
- Freehold Semi-detached house
E11 2DY - 1,059,000
- Freehold Semi-detached house
E11 2DY - 1,101,000
- Freehold Semi-detached house
E11 2DY - 1,221,000
- Freehold Semi-detached house
E11 2DY - 1,163,000
- Freehold Semi-detached property
E11 2DY - 1,055,000
- Freehold Semi-detached house
E11 2DY - 1,061,000
- Freehold Semi-detached house
E11 2DY - 1,507,000
- Freehold Semi-detached house
E11 2DY - 1,017,000
- Freehold Semi-detached house
E11 2DY - 1,172,000
- Freehold Semi-detached house
E11 2DY - 1,068,000
- Semi-detached house
E11 2DY - 1,117,000
- Freehold Semi-detached property
E11 2DY - 1,433,000
- Freehold Semi-detached house
E11 2DY - 1,341,000
- Freehold Semi-detached house
E11 2DY - 1,356,000
- Freehold Semi-detached house
E11 2DY - 1,594,000
- Freehold Terraced
E11 2DY - 1,492,000
- Freehold Semi-detached house