SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W8 6HE' order by fulladdress
W8 6HE - 6,005,000
- End terrace house
W8 6HE - 6,499,000
- Freehold Mid terrace house
W8 6HE - 3,505,000
- Freehold Mid terrace house
W8 6HE - 7,007,000
- Freehold Terraced
W8 6HE - 6,247,000
- Mid terrace house
W8 6HE - 7,251,000
- Freehold Terrace property
W8 6HE - 5,499,000
- Freehold Mid terrace house
W8 6HE - 0
- Freehold Mid terrace house
W8 6HE - 5,406,000
- Freehold Mid terrace house
W8 6HE - 5,799,000
- Freehold Mid terrace house
W8 6HE - 5,765,000
- Freehold Terrace property
W8 6HE - 8,762,000
- Freehold Terraced
W8 6HE - 11,274,000
- Freehold Terraced
W8 6HE - 5,825,000
- Freehold Mid terrace house
W8 6HE - 6,712,000
- Freehold Mid terrace house
W8 6HE - 6,270,000
- Freehold Terraced
