SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BH23 2HW' order by fulladdress
BH23 2HW - 590,000
- Freehold Detached bungalow
BH23 2HW - 268,000
- Leasehold Detached property
BH23 2HW - 592,000
- Freehold Detached house
BH23 2HW - 531,000
- Freehold Detached property
BH23 2HW - 516,000
- Freehold Detached bungalow
BH23 2HW - 840,000
- Freehold Detached house
BH23 2HW - 489,000
- Freehold Semi-detached house
BH23 2HW - 558,000
- Freehold Detached bungalow
BH23 2HW - 643,000
- Freehold Detached house
BH23 2HW - 686,000
- Freehold Detached bungalow
BH23 2HW - 686,000
- Freehold Detached bungalow
BH23 2HW - 479,000
- Freehold Bungalow property
BH23 2HW - 505,000
- Freehold Detached bungalow
BH23 2HW - 659,000
- Freehold Detached bungalow
BH23 2HW - 764,000
- Freehold Detached bungalow
BH23 2HW - 562,000
- Freehold Detached bungalow
BH23 2HW - 618,000
- Freehold Detached bungalow
BH23 2HW - 486,000
- Freehold Semi-detached bungalow
BH23 2HW - 511,000
- Freehold Semi-detached bungalow
BH23 2HW - 436,000
- Freehold Semi-detached bungalow
BH23 2HW - 512,000
- Freehold Detached bungalow
BH23 2HW - 441,000
- Freehold Semi-detached bungalow
BH23 2HW - 516,000
- Freehold Detached bungalow
BH23 2HW - 681,000
- Freehold Detached bungalow
BH23 2HW - 459,000
- Freehold Detached house
BH23 2HW - 508,000
- Freehold Detached bungalow
BH23 2HW - 876,000
- Freehold Detached bungalow
