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 6EH' order by fulladdress
E9 6EH - 1,964,000
- Freehold Terraced
E9 6EH - 1,923,000
- Freehold Mid terrace house
E9 6EH - 1,965,000
- Freehold Mid terrace house
E9 6EH - 1,834,000
- Freehold Mid terrace house
E9 6EH - 1,947,000
- Freehold Mid terrace house
E9 6EH - 1,908,000
- End terrace house
E9 6EH - 2,051,000
- Freehold Terrace property
E9 6EH - 2,357,000
- Freehold Detached house
E9 6EH - 743,000
- Leasehold Converted flat
E9 6EH - 490,000
- Leasehold Converted flat
E9 6EH - 843,000
- Freehold Converted flat
E9 6EH - 480,000
- Leasehold Converted flat
E9 6EH - 1,768,000
- Freehold Terraced
E9 6EH - 1,882,000
- Freehold Mid terrace house
E9 6EH - 1,935,000
- Freehold Mid terrace house
E9 6EH - 1,934,000
- Freehold Mid terrace house
E9 6EH - 1,877,000
- Freehold Mid terrace house
E9 6EH - 1,875,000
- Freehold Mid terrace house
E9 6EH - 1,735,000
- Freehold End terrace house
E9 6EH - 520,000
- Leasehold Flat/Maisonette
E9 6EH - 440,000
- Leasehold Flat/Maisonette
E9 6EH - 516,000
- Leasehold Flat/Maisonette
E9 6EH - 2,076,000
- Freehold Terraced
E9 6EH - 1,939,000
- Freehold Mid terrace house
E9 6EH - 2,050,000
- Freehold Mid terrace house
E9 6EH - 546,000
- Leasehold Flat/Maisonette
E9 6EH - 622,000
- Leasehold Purpose built flat
E9 6EH - 504,000
- Leasehold Flat/Maisonette
E9 6EH - 456,000
- Leasehold Flat/Maisonette
E9 6EH - 596,000
- Leasehold Flat/Maisonette
E9 6EH - 541,000
- Leasehold Purpose built flat