SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BH8 9HX' order by fulladdress
BH8 9HX - 744,000
- Freehold Detached house
BH8 9HX - 359,000
- Freehold Detached property
BH8 9HX - 671,000
- Freehold Detached property
BH8 9HX - 605,000
- Freehold Detached house
BH8 9HX - 687,000
- Freehold Detached house
BH8 9HX - 690,000
- Freehold Detached house
BH8 9HX - 758,000
- Freehold Detached house
BH8 9HX - 694,000
- Freehold Detached house
BH8 9HX - 601,000
- Freehold Detached bungalow
BH8 9HX - 787,000
- Freehold Detached property
BH8 9HX - 733,000
- Freehold Detached house
BH8 9HX - 719,000
- Freehold Detached property
BH8 9HX - 672,000
- Freehold Detached bungalow
BH8 9HX - 732,000
- Freehold Detached house
BH8 9HX - 783,000
- Freehold Detached house
BH8 9HX - 753,000
- Freehold Detached house
BH8 9HX - 711,000
- Freehold Detached house
BH8 9HX - 757,000
- Freehold Detached house
BH8 9HX - 693,000
- Freehold Detached house
BH8 9HX - 816,000
- Freehold Detached house
BH8 9HX - 726,000
- Freehold Detached house
BH8 9HX - 715,000
- Freehold Detached house
BH8 9HX - 716,000
- Freehold Detached house
BH8 9HX - 723,000
- Freehold Detached property
BH8 9HX - 810,000
- Freehold Detached house
BH8 9HX - 728,000
- Freehold Detached house
BH8 9HX - 740,000
- Freehold Detached house
BH8 9HX - 741,000
- Freehold Detached house
BH8 9HX - 854,000
- Freehold Detached house
BH8 9HX - 783,000
- Freehold Detached property
BH8 9HX - 680,000
- Freehold Detached house
BH8 9HX - 695,000
- Freehold Detached house
BH8 9HX - 286,000
- Leasehold Flat/Maisonette
BH8 9HX - 312,000
- Leasehold Purpose built flat
BH8 9HX - 295,000
- Freehold Purpose built flat
BH8 9HX - 292,000
- Leasehold Purpose built flat
