SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP17 8LY' order by fulladdress
HP17 8LY - 498,000
- Freehold Semi-detached house
HP17 8LY - 506,000
- Freehold Semi-detached house
HP17 8LY - 508,000
- Freehold Semi-detached house
HP17 8LY - 966,000
- Freehold Semi-detached house
HP17 8LY - 495,000
- Freehold Semi-detached house
HP17 8LY - 588,000
- Freehold Semi-detached property
HP17 8LY - 582,000
- Freehold Semi-detached property
HP17 8LY - 893,000
- Freehold Detached house
HP17 8LY - 980,000
- Freehold Detached house
HP17 8LY - 877,000
- Freehold Detached property
HP17 8LY - 963,000
- Freehold Detached house
