SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='E7 0ED' order by fulladdress
E7 0ED - 864,000
- Freehold Mid terrace house
E7 0ED - 851,000
- Freehold Mid terrace house
E7 0ED - 840,000
- Freehold Mid terrace house
E7 0ED - 903,000
- Freehold Terraced
E7 0ED - 818,000
- Freehold Terraced
E7 0ED - 906,000
- Freehold Mid terrace house
E7 0ED - 978,000
- Freehold Mid terrace house
E7 0ED - 366,000
- Leasehold Converted flat
E7 0ED - 871,000
- End terrace house
E7 0ED - 909,000
- Mid terrace house
E7 0ED - 762,000
- Freehold Terrace property
E7 0ED - 379,000
- Leasehold Converted flat
E7 0ED - 388,000
- Freehold Converted flat
E7 0ED - 862,000
- Freehold Mid terrace house
E7 0ED - 916,000
- Mid terrace house
E7 0ED - 937,000
- Freehold Mid terrace house
E7 0ED - 898,000
- Freehold Mid terrace house
E7 0ED - 852,000
- Freehold Detached house
E7 0ED - 839,000
- Freehold Mid terrace house
E7 0ED - 854,000
- Freehold Mid terrace house
E7 0ED - 870,000
- Freehold End terrace house
E7 0ED - 885,000
- Freehold Terraced
E7 0ED - 928,000
- Freehold Mid terrace house
E7 0ED - 387,000
- Leasehold Flat/Maisonette
E7 0ED - 397,000
- Leasehold Purpose built flat
E7 0ED - 409,000
- Freehold Flat/Maisonette
E7 0ED - 839,000
- Freehold Mid terrace house
E7 0ED - 420,000
- Leasehold Purpose built flat
E7 0ED - 399,000
- Leasehold Purpose built flat
E7 0ED - 399,000
- Leasehold Purpose built flat
E7 0ED - 849,000
- Freehold Mid terrace house
