SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BH5 2EW' order by fulladdress
BH5 2EW - 479,000
- Leasehold Converted flat
BH5 2EW - 972,000
- Leasehold Flat/Maisonette
BH5 2EW - 1,134,000
- Freehold Detached house
BH5 2EW - 1,119,000
- Freehold Detached house
BH5 2EW - 1,047,000
- Freehold Detached house
BH5 2EW - 377,000
- Leasehold Flat/Maisonette
BH5 2EW - 287,000
- Leasehold Converted flat
BH5 2EW - 302,000
- Leasehold Converted flat
BH5 2EW - 519,000
- Leasehold Flat/Maisonette
BH5 2EW - 1,047,000
- Freehold Detached house
BH5 2EW - 1,106,000
- Freehold Detached house
BH5 2EW - 402,000
- Leasehold Flat/Maisonette
BH5 2EW - 364,000
- Freehold Purpose built flat
BH5 2EW - 1,143,000
- Freehold Detached house
BH5 2EW - 955,000
- Freehold Detached house
BH5 2EW - 482,000
- Leasehold Purpose built flat
BH5 2EW - 851,000
- Freehold Detached house
BH5 2EW - 907,000
- Freehold Detached house
BH5 2EW - 1,090,000
- Freehold Detached house
BH5 2EW - 1,038,000
- Freehold Detached property
BH5 2EW - 483,000
- Leasehold Purpose built flat
BH5 2EW - 893,000
- Freehold Detached house
BH5 2EW - 416,000
- Feudal Converted flat
BH5 2EW - 615,000
- Leasehold Flat/Maisonette
BH5 2EW - 580,000
- Leasehold Flat/Maisonette
BH5 2EW - 294,000
- Leasehold Purpose built flat
BH5 2EW - 594,000
- Leasehold Flat/Maisonette
BH5 2EW - 705,000
- Leasehold Flat/Maisonette
BH5 2EW - 1,211,000
- Freehold Detached house
BH5 2EW - 516,000
- Leasehold Flat/Maisonette
BH5 2EW - 349,000
- Leasehold Flat/Maisonette
BH5 2EW - 343,000
- Leasehold Converted flat
BH5 2EW - 353,000
- Leasehold Flat/Maisonette
BH5 2EW - 380,000
- Freehold Flat/Maisonette
BH5 2EW - 238,000
- Leasehold Flat/Maisonette
BH5 2EW - 424,000
- Leasehold Flat/Maisonette
