SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP16 0RA' order by fulladdress
HP16 0RA - 778,000
- Freehold Detached bungalow
HP16 0RA - 731,000
- Freehold Detached bungalow
HP16 0RA - 773,000
- Freehold Detached bungalow
HP16 0RA - 842,000
- Freehold Detached bungalow
HP16 0RA - 722,000
- Freehold Detached bungalow
HP16 0RA - 678,000
- Freehold Semi-detached bungalow
HP16 0RA - 866,000
- Freehold Detached property
HP16 0RA - 682,000
- Freehold Semi-detached bungalow
HP16 0RA - 652,000
- Freehold Semi-detached bungalow
HP16 0RA - 791,000
- Freehold Detached bungalow
HP16 0RA - 724,000
- Freehold Detached bungalow
HP16 0RA - 881,000
- Freehold Detached property
HP16 0RA - 870,000
- Freehold Detached property
HP16 0RA - 856,000
- Freehold Detached house
HP16 0RA - 557,000
- Freehold Semi-detached bungalow
HP16 0RA - 733,000
- Freehold Detached property
HP16 0RA - 1,079,000
- Freehold Detached bungalow
HP16 0RA - 741,000
- Freehold Detached bungalow
HP16 0RA - 667,000
- Freehold Detached property
HP16 0RA - 727,000
- Freehold Detached bungalow
HP16 0RA - 743,000
- Freehold Detached property
