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 5JS' order by fulladdress
BH23 5JS - 1,152,000
- Freehold Detached house
BH23 5JS - 942,000
- Freehold Detached house
BH23 5JS - 297,000
- Leasehold Purpose built flat
BH23 5JS - 295,000
- Leasehold Purpose built flat
BH23 5JS - 943,000
- Freehold Semi-detached house
BH23 5JS - 465,000
- Leasehold Detached property
BH23 5JS - 328,000
- Leasehold Purpose built flat
BH23 5JS - 940,000
- Freehold Detached house
BH23 5JS - 979,000
- Freehold Detached house
BH23 5JS - 995,000
- Freehold Detached house
BH23 5JS - 793,000
- Freehold Detached house
BH23 5JS - 871,000
- Freehold Detached house
BH23 5JS - 1,048,000
- Freehold Detached house
BH23 5JS - 838,000
- Freehold Detached house
BH23 5JS - 935,000
- Freehold Detached house
BH23 5JS - 1,070,000
- Freehold Detached house
BH23 5JS - 994,000
- Freehold Detached house
BH23 5JS - 471,000
- Freehold Semi-detached house
BH23 5JS - 996,000
- Freehold Detached house
BH23 5JS - 564,000
- Freehold Semi-detached property
BH23 5JS - 942,000
- Freehold Detached house
BH23 5JS - 556,000
- Freehold Detached bungalow
BH23 5JS - 680,000
- Freehold Semi-detached house
BH23 5JS - 422,000
- Freehold Terrace property
BH23 5JS - 592,000
- Freehold Semi-detached house
BH23 5JS - 500,000
- Freehold Semi-detached house
BH23 5JS - 1,064,000
- Freehold Detached house
BH23 5JS - 279,000
- Leasehold Purpose built flat
BH23 5JS - 266,000
- Leasehold Purpose built flat
BH23 5JS - 266,000
- Leasehold Purpose built flat
BH23 5JS - 324,000
- Leasehold Purpose built flat
BH23 5JS - 131,000
- Leasehold Converted flat
BH23 5JS - 360,000
- Leasehold Flat/Maisonette
BH23 5JS - 306,000
- Leasehold Flat/Maisonette
BH23 5JS - 325,000
- Leasehold Flat/Maisonette
BH23 5JS - 176,000
- Leasehold Converted flat
BH23 5JS - 353,000
- Leasehold Flat/Maisonette
BH23 5JS - 293,000
- Leasehold Flat/Maisonette
BH23 5JS - 308,000
- Leasehold Flat/Maisonette
BH23 5JS - 312,000
- Leasehold Flat/Maisonette
BH23 5JS - 167,000
- Leasehold Converted flat
BH23 5JS - 318,000
- Leasehold Flat/Maisonette
BH23 5JS - 282,000
- Leasehold Purpose built flat
BH23 5JS - 310,000
- Leasehold Flat/Maisonette
BH23 5JS - 330,000
- Leasehold Flat/Maisonette
BH23 5JS - 164,000
- Leasehold Converted flat
BH23 5JS - 335,000
- Leasehold Flat/Maisonette
BH23 5JS - 246,000
- Leasehold Flat/Maisonette
BH23 5JS - 289,000
- Leasehold Flat/Maisonette
BH23 5JS - 323,000
- Leasehold Flat/Maisonette
BH23 5JS - 191,000
- Leasehold Converted flat
BH23 5JS - 368,000
- Leasehold Flat/Maisonette
BH23 5JS - 359,000
- Leasehold Flat/Maisonette
BH23 5JS - 291,000
- Leasehold Flat/Maisonette
BH23 5JS - 370,000
- Leasehold Flat/Maisonette
BH23 5JS - 186,000
- Leasehold Converted flat
BH23 5JS - 262,000
- Leasehold Flat/Maisonette
BH23 5JS - 202,000
- Freehold Flat/Maisonette
BH23 5JS - 295,000
- Leasehold Purpose built flat