SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BH12 3DB' order by fulladdress
BH12 3DB - 386,000
- Leasehold Detached house
BH12 3DB - 421,000
- Freehold Detached house
BH12 3DB - 96,000
- Leasehold Flat/Maisonette
BH12 3DB - 93,000
- Leasehold Flat/Maisonette
BH12 3DB - 338,000
- Freehold Mid terrace house
BH12 3DB - 139,000
- Leasehold Flat/Maisonette
BH12 3DB - 125,000
- Leasehold Purpose built flat
BH12 3DB - 97,000
- Leasehold Flat/Maisonette
BH12 3DB - 82,000
- Leasehold Flat/Maisonette
BH12 3DB - 105,000
- Leasehold Flat/Maisonette
BH12 3DB - 359,000
- Freehold Semi-detached house
BH12 3DB - 112,000
- Leasehold Flat/Maisonette
BH12 3DB - 143,000
- Leasehold Flat/Maisonette
BH12 3DB - 114,000
- Leasehold Flat/Maisonette
BH12 3DB - 114,000
- Leasehold Flat/Maisonette
BH12 3DB - 106,000
- Leasehold Flat/Maisonette
BH12 3DB - 111,000
- Leasehold Flat/Maisonette
BH12 3DB - 154,000
- Leasehold Flat/Maisonette
BH12 3DB - 126,000
- Leasehold Flat/Maisonette
BH12 3DB - 354,000
- Freehold Semi-detached house
BH12 3DB - 494,000
- Freehold Detached house
BH12 3DB - 394,000
- Leasehold Detached house
BH12 3DB - 187,000
- Leasehold Converted flat
BH12 3DB - 182,000
- Leasehold Flat/Maisonette
BH12 3DB - 192,000
- Leasehold Purpose built flat
BH12 3DB - 163,000
- Leasehold Purpose built flat
BH12 3DB - 438,000
- Freehold Detached house
BH12 3DB - 129,000
- Leasehold Flat/Maisonette
BH12 3DB - 397,000
- Freehold Semi-detached house
BH12 3DB - 393,000
- Freehold Semi-detached house
BH12 3DB - 440,000
- Freehold Detached house
BH12 3DB - 96,000
- Leasehold Flat/Maisonette
BH12 3DB - 370,000
- Freehold Semi-detached property
BH12 3DB - 476,000
- Freehold Detached house
BH12 3DB - 538,000
- Freehold Detached house
BH12 3DB - 528,000
- Freehold Detached property
BH12 3DB - 360,000
- Freehold Detached bungalow
BH12 3DB - 394,000
- Freehold Detached property
BH12 3DB - 148,000
- Leasehold Flat/Maisonette
BH12 3DB - 92,000
- Leasehold Flat/Maisonette
BH12 3DB - 251,000
- Leasehold Converted flat
BH12 3DB - 204,000
- Leasehold Converted flat
BH12 3DB - 185,000
- Leasehold Converted flat
BH12 3DB - 162,000
- Leasehold Converted flat
BH12 3DB - 155,000
- Leasehold Flat/Maisonette
BH12 3DB - 243,000
- Leasehold Converted flat
