SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E4 7EF' order by fulladdress
E4 7EF - 893,000
- Freehold Semi-detached house
E4 7EF - 818,000
- Freehold End terrace house
E4 7EF - 933,000
- Freehold Semi-detached house
E4 7EF - 935,000
- Freehold Mid terrace house
E4 7EF - 917,000
- Semi-detached house
E4 7EF - 814,000
- Freehold Terrace property
E4 7EF - 366,000
- Freehold Converted flat
E4 7EF - 850,000
- Freehold Terrace property
E4 7EF - 1,033,000
- Freehold End terrace house
E4 7EF - 984,000
- Freehold Semi-detached house
E4 7EF - 889,000
- Freehold Semi-detached house
E4 7EF - 915,000
- Freehold Semi-detached house
E4 7EF - 847,000
- Freehold Semi-detached property
E4 7EF - 923,000
- Freehold Semi-detached property
E4 7EF - 840,000
- Freehold End terrace house
E4 7EF - 726,000
- Freehold Detached house
E4 7EF - 979,000
- Freehold Semi-detached house
E4 7EF - 865,000
- Freehold Mid terrace house
E4 7EF - 941,000
- Freehold Semi-detached house
E4 7EF - 881,000
- Freehold Semi-detached house
E4 7EF - 875,000
- Freehold Semi-detached house
E4 7EF - 974,000
- Freehold Semi-detached house
E4 7EF - 932,000
- Freehold Semi-detached property
E4 7EF - 1,004,000
- Freehold Semi-detached house
E4 7EF - 816,000
- Freehold Mid terrace house
E4 7EF - 869,000
- Freehold Semi-detached house
E4 7EF - 932,000
- Freehold Semi-detached property
E4 7EF - 893,000
- Freehold Semi-detached house
E4 7EF - 861,000
- Freehold End terrace house