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 3BW' order by fulladdress
E11 3BW - 1,325,000
- Freehold Detached house
E11 3BW - 613,000
- Freehold Flat/Maisonette
E11 3BW - 810,000
- Freehold Semi-detached house
E11 3BW - 941,000
- Freehold Semi-detached house
E11 3BW - 916,000
- Freehold Terrace property
E11 3BW - 919,000
- Freehold Mid terrace house
E11 3BW - 823,000
- Freehold Mid terrace house
E11 3BW - 855,000
- Freehold Mid terrace house
E11 3BW - 819,000
- Freehold Mid terrace house
E11 3BW - 962,000
- Freehold End terrace house
E11 3BW - 1,304,000
- Freehold Mid terrace house
E11 3BW - 1,330,000
- Freehold Mid terrace house
E11 3BW - 1,124,000
- Freehold Mid terrace house
E11 3BW - 1,071,000
- Mid terrace house
E11 3BW - 1,276,000
- Mid terrace house
E11 3BW - 1,231,000
- Freehold Mid terrace house
E11 3BW - 1,235,000
- Freehold Mid terrace house
E11 3BW - 586,000
- Leasehold Converted flat
E11 3BW - 1,134,000
- Freehold Semi-detached property
E11 3BW - 1,289,000
- Freehold End terrace house
E11 3BW - 1,059,000
- Mid terrace house
E11 3BW - 1,298,000
- Freehold Terraced
E11 3BW - 1,167,000
- Mid terrace house
E11 3BW - 1,251,000
- Leasehold Mid terrace house
E11 3BW - 1,336,000
- Mid terrace house
E11 3BW - 1,256,000
- Freehold Mid terrace house
E11 3BW - 1,217,000
- Freehold Terraced
E11 3BW - 1,233,000
- Freehold End terrace house
E11 3BW - 846,000
- Freehold Mid terrace house
E11 3BW - 821,000
- Freehold Semi-detached house
E11 3BW - 825,000
- Freehold Mid terrace house
E11 3BW - 837,000
- Freehold End terrace house
E11 3BW - 942,000
- Freehold End terrace house
E11 3BW - 883,000
- Freehold Mid terrace house
E11 3BW - 1,048,000
- Freehold Mid terrace house
E11 3BW - 868,000
- Freehold End terrace house