SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BH20 4FL' order by fulladdress
BH20 4FL - 692,000
- Freehold Detached house
BH20 4FL - 555,000
- Freehold Detached house
BH20 4FL - 680,000
- Freehold Detached house
BH20 4FL - 644,000
- Freehold Detached house
BH20 4FL - 544,000
- Freehold Detached house
BH20 4FL - 676,000
- Freehold Detached house
BH20 4FL - 568,000
- Freehold Detached house
BH20 4FL - 580,000
- Freehold Detached house
BH20 4FL - 447,000
- Freehold Terrace property
BH20 4FL - 699,000
- Freehold Detached house
BH20 4FL - 475,000
- Freehold Mid terrace house
BH20 4FL - 621,000
- Freehold Detached house
BH20 4FL - 561,000
- Freehold Detached house
BH20 4FL - 433,000
- Freehold Mid terrace house
BH20 4FL - 538,000
- Freehold Detached house
BH20 4FL - 480,000
- Freehold End terrace house
BH20 4FL - 461,000
- Freehold End terrace house
BH20 4FL - 510,000
- Freehold Detached house
BH20 4FL - 547,000
- Freehold Detached house
BH20 4FL - 415,000
- Freehold Semi-detached house
BH20 4FL - 413,000
- Freehold Semi-detached house
BH20 4FL - 431,000
- Freehold Semi-detached property
BH20 4FL - 514,000
- Freehold Detached property
BH20 4FL - 545,000
- Freehold Detached house
BH20 4FL - 567,000
- Freehold Detached house
BH20 4FL - 552,000
- Freehold Detached house
BH20 4FL - 543,000
- Freehold Detached house
BH20 4FL - 551,000
- Freehold Detached house
BH20 4FL - 540,000
- Freehold Detached property
BH20 4FL - 239,000
- Freehold Flat/Maisonette
