SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E9 5SL' order by fulladdress
E9 5SL - 892,000
- Freehold Mid terrace house
E9 5SL - 999,000
- Freehold Terraced
E9 5SL - 908,000
- Freehold Mid terrace house
E9 5SL - 995,000
- Freehold Mid terrace house
E9 5SL - 836,000
- Freehold Mid terrace house
E9 5SL - 862,000
- Freehold Mid terrace house
E9 5SL - 894,000
- Freehold Mid terrace house
E9 5SL - 1,084,000
- Freehold Mid terrace house
E9 5SL - 1,111,000
- Freehold Terrace property
E9 5SL - 931,000
- Freehold Mid terrace house
E9 5SL - 944,000
- Freehold Mid terrace house
E9 5SL - 1,005,000
- Freehold Mid terrace house
E9 5SL - 977,000
- Mid terrace house
E9 5SL - 832,000
- Freehold Mid terrace house
E9 5SL - 897,000
- Freehold Terraced
E9 5SL - 814,000
- Freehold Mid terrace house
E9 5SL - 602,000
- Leasehold Purpose built flat
E9 5SL - 1,183,000
- Freehold End terrace house
E9 5SL - 963,000
- Freehold Mid terrace house
E9 5SL - 471,000
- Leasehold Flat/Maisonette
E9 5SL - 465,000
- Freehold Flat/Maisonette
E9 5SL - 887,000
- Freehold Mid terrace house
E9 5SL - 876,000
- Freehold Mid terrace house
E9 5SL - 931,000
- Freehold Mid terrace house
E9 5SL - 925,000
- Freehold Mid terrace house
E9 5SL - 956,000
- Freehold Mid terrace house
E9 5SL - 975,000
- Freehold Mid terrace house
E9 5SL - 944,000
- Freehold Mid terrace house
E9 5SL - 899,000
- Freehold Mid terrace house
E9 5SL - 493,000
- Leasehold Converted flat
