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 5JD' order by fulladdress
E3 5JD - 788,000
- Freehold Terrace property
E3 5JD - 734,000
- Freehold End terrace house
E3 5JD - 924,000
- Freehold Mid terrace house
E3 5JD - 852,000
- Freehold Mid terrace house
E3 5JD - 936,000
- End terrace house
E3 5JD - 968,000
- Freehold Mid terrace house
E3 5JD - 924,000
- Mid terrace house
E3 5JD - 529,000
- Freehold Flat/Maisonette
E3 5JD - 909,000
- Mid terrace house
E3 5JD - 936,000
- Mid terrace property
E3 5JD - 979,000
- Freehold Mid terrace house
E3 5JD - 990,000
- Freehold End terrace house
E3 5JD - 520,000
- Leasehold Flat/Maisonette
E3 5JD - 515,000
- Freehold Flat/Maisonette
E3 5JD - 903,000
- Freehold Mid terrace house
E3 5JD - 775,000
- Mid terrace house
E3 5JD - 739,000
- Freehold Mid terrace house
E3 5JD - 677,000
- Mid terrace bungalow
E3 5JD - 465,000
- Leasehold Converted flat
E3 5JD - 864,000
- Freehold Mid terrace house
E3 5JD - 654,000
- Semi-detached bungalow
E3 5JD - 774,000
- End terrace house
E3 5JD - 748,000
- Mid terrace house
E3 5JD - 749,000
- Mid terrace house
E3 5JD - 762,000
- Mid terrace house
E3 5JD - 761,000
- Mid terrace house
E3 5JD - 689,000
- Freehold Mid terrace house
E3 5JD - 731,000
- Mid terrace house
E3 5JD - 804,000
- Freehold Terraced
E3 5JD - 753,000
- End terrace house
E3 5JD - 667,000
- End terrace house
E3 5JD - 675,000
- Freehold Mid terrace house
E3 5JD - 936,000
- Freehold Mid terrace house
E3 5JD - 826,000
- Freehold Detached house
E3 5JD - 355,000
- Leasehold Purpose built flat
E3 5JD - 332,000
- Leasehold Purpose built flat
E3 5JD - 323,000
- Leasehold Purpose built flat
E3 5JD - 287,000
- Leasehold Converted flat
