SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP5 2SE' order by fulladdress
HP5 2SE - 886,000
- Freehold Detached house
HP5 2SE - 628,000
- Freehold Detached bungalow
HP5 2SE - 747,000
- Freehold Detached house
HP5 2SE - 910,000
- Freehold Detached house
HP5 2SE - 998,000
- Freehold Detached house
HP5 2SE - 1,006,000
- Freehold Detached house
HP5 2SE - 875,000
- Freehold Detached house
HP5 2SE - 745,000
- Freehold Detached house
HP5 2SE - 755,000
- Freehold Semi-detached house
HP5 2SE - 928,000
- Freehold Detached house
HP5 2SE - 607,000
- Freehold Bungalow property
HP5 2SE - 772,000
- Freehold Detached house
HP5 2SE - 624,000
- Freehold Semi-detached house
HP5 2SE - 1,038,000
- Freehold Detached house
HP5 2SE - 794,000
- Freehold Semi-detached house
HP5 2SE - 654,000
- Freehold Semi-detached house
HP5 2SE - 644,000
- Freehold Semi-detached property
HP5 2SE - 1,120,000
- Freehold Detached bungalow
HP5 2SE - 1,036,000
- Freehold Detached house
HP5 2SE - 1,038,000
- Freehold Detached house
HP5 2SE - 736,000
- Freehold Detached house
HP5 2SE - 601,000
- Freehold Detached bungalow
HP5 2SE - 691,000
- Freehold Detached bungalow
HP5 2SE - 785,000
- Freehold Detached property
HP5 2SE - 977,000
- Freehold Detached house
HP5 2SE - 940,000
- Freehold Detached property
HP5 2SE - 860,000
- Freehold Detached house
HP5 2SE - 882,000
- Freehold Detached house
HP5 2SE - 1,015,000
- Freehold Detached house
HP5 2SE - 1,052,000
- Freehold Detached bungalow
HP5 2SE - 871,000
- Freehold Semi-detached property
HP5 2SE - 752,000
- Freehold Detached house
HP5 2SE - 544,000
- Freehold Semi-detached house
