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 6PE' order by fulladdress
W8 6PE - 5,982,000
- Freehold Terrace property
W8 6PE - 6,050,000
- Freehold Mid terrace house
W8 6PE - 4,646,000
- Freehold Mid terrace house
W8 6PE - 5,193,000
- Freehold Mid terrace house
W8 6PE - 4,959,000
- Freehold Terraced
W8 6PE - 5,380,000
- Freehold Mid terrace house
W8 6PE - 5,416,000
- Freehold Mid terrace house
W8 6PE - 5,264,000
- Freehold Terraced
W8 6PE - 5,673,000
- Freehold Mid terrace house
W8 6PE - 5,860,000
- Freehold Terraced
W8 6PE - 5,383,000
- Freehold Mid terrace house
W8 6PE - 1,376,000
- Flat/Maisonette
