SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BH13 7DE' order by fulladdress
BH13 7DE - 1,721,000
- Freehold Detached bungalow
BH13 7DE - 3,413,000
- Freehold Detached house
BH13 7DE - 4,801,000
- Freehold Detached house
BH13 7DE - 2,203,000
- Freehold Detached house
BH13 7DE - 2,778,000
- Freehold Detached house
BH13 7DE - 2,219,000
- Freehold Detached house
BH13 7DE - 5,070,000
- Freehold Detached house