SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP22 6BY' order by fulladdress
HP22 6BY - 792,000
- Freehold Detached house
HP22 6BY - 838,000
- Freehold Detached house
HP22 6BY - 783,000
- Freehold Detached house
HP22 6BY - 904,000
- Freehold Detached house
HP22 6BY - 952,000
- Freehold Detached house
HP22 6BY - 805,000
- Freehold Detached house
HP22 6BY - 947,000
- Freehold Detached house
HP22 6BY - 943,000
- Freehold Detached house
HP22 6BY - 824,000
- Freehold Detached property
HP22 6BY - 1,005,000
- Freehold Detached house
HP22 6BY - 827,000
- Freehold Detached house
HP22 6BY - 906,000
- Freehold Detached house
HP22 6BY - 858,000
- Freehold Detached house
HP22 6BY - 889,000
- Freehold Detached property
HP22 6BY - 779,000
- Freehold Detached house
HP22 6BY - 833,000
- Freehold Semi-detached property
HP22 6BY - 859,000
- Freehold Detached house
HP22 6BY - 652,000
- Freehold End terrace house
HP22 6BY - 588,000
- Freehold Terrace property
HP22 6BY - 682,000
- Freehold Detached house
HP22 6BY - 715,000
- Freehold Semi-detached house
HP22 6BY - 941,000
- Freehold Detached house
HP22 6BY - 682,000
- Freehold Semi-detached house
HP22 6BY - 1,061,000
- Freehold Detached house
HP22 6BY - 898,000
- Freehold Detached house
HP22 6BY - 981,000
- Freehold Detached house
HP22 6BY - 999,000
- Freehold Detached house
