SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BH6 3AL' order by fulladdress
BH6 3AL - 691,000
- Freehold Detached property
BH6 3AL - 297,000
- Freehold Converted flat
BH6 3AL - 271,000
- Freehold Converted flat
BH6 3AL - 747,000
- Freehold Detached house
BH6 3AL - 673,000
- Freehold Detached house
BH6 3AL - 679,000
- Freehold Detached house
BH6 3AL - 686,000
- Freehold Detached house
BH6 3AL - 678,000
- Freehold Detached house
BH6 3AL - 688,000
- Freehold Detached house
BH6 3AL - 670,000
- Freehold Detached house
BH6 3AL - 705,000
- Freehold Detached house
BH6 3AL - 595,000
- Freehold Detached bungalow
BH6 3AL - 650,000
- Freehold Detached house
BH6 3AL - 702,000
- Freehold Detached house
BH6 3AL - 566,000
- Freehold Detached bungalow
BH6 3AL - 705,000
- Freehold Detached house
BH6 3AL - 610,000
- Freehold Detached bungalow
BH6 3AL - 660,000
- Freehold Detached house
BH6 3AL - 694,000
- Freehold Detached house
BH6 3AL - 246,000
- Leasehold Purpose built flat
BH6 3AL - 583,000
- Leasehold Detached house
BH6 3AL - 195,000
- Leasehold Flat/Maisonette
BH6 3AL - 662,000
- Freehold Detached house
BH6 3AL - 666,000
- Freehold Detached house
BH6 3AL - 645,000
- Freehold Detached house
