SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CO6 1BU' order by fulladdress
CO6 1BU - 746,000
- Freehold Detached bungalow
CO6 1BU - 595,000
- Freehold Detached house
CO6 1BU - 648,000
- Freehold Detached house
CO6 1BU - 547,000
- Freehold Semi-detached house
CO6 1BU - 563,000
- Freehold Detached house
CO6 1BU - 558,000
- Freehold Semi-detached house
CO6 1BU - 719,000
- Freehold Detached house
CO6 1BU - 540,000
- Freehold Semi-detached house
CO6 1BU - 783,000
- Freehold Detached property
CO6 1BU - 504,000
- Freehold Semi-detached house
CO6 1BU - 876,000
- Freehold Detached house
CO6 1BU - 687,000
- Freehold Detached house
CO6 1BU - 780,000
- Freehold Detached house
CO6 1BU - 639,000
- Freehold Detached house
CO6 1BU - 586,000
- Freehold Detached house
CO6 1BU - 612,000
- Freehold Detached house
CO6 1BU - 647,000
- Freehold Detached bungalow
CO6 1BU - 537,000
- Freehold Detached house
CO6 1BU - 671,000
- Freehold Detached bungalow
CO6 1BU - 898,000
- Freehold Detached house
CO6 1BU - 601,000
- Freehold Detached bungalow
CO6 1BU - 434,000
- Freehold Detached bungalow
CO6 1BU - 1,042,000
- Freehold Detached bungalow
CO6 1BU - 414,000
- Freehold Detached bungalow
CO6 1BU - 472,000
- Freehold Bungalow property
CO6 1BU - 653,000
- Freehold Detached house
CO6 1BU - 427,000
- Freehold Detached house
CO6 1BU - 564,000
- Freehold Detached bungalow
CO6 1BU - 446,000
- Freehold Semi-detached house
CO6 1BU - 343,000
- Freehold Semi-detached house
CO6 1BU - 750,000
- Freehold Detached house
CO6 1BU - 449,000
- Freehold Detached property
CO6 1BU - 617,000
- Freehold Detached bungalow
CO6 1BU - 463,000
- Freehold Detached property
CO6 1BU - 494,000
- Freehold Detached property
CO6 1BU - 530,000
- Freehold Detached bungalow
CO6 1BU - 569,000
- Freehold Detached house
CO6 1BU - 517,000
- Freehold Detached bungalow
CO6 1BU - 569,000
- Freehold Detached bungalow
CO6 1BU - 606,000
- Freehold Detached bungalow
CO6 1BU - 451,000
- Freehold Detached bungalow
CO6 1BU - 453,000
- Freehold Detached property
CO6 1BU - 848,000
- Freehold Detached bungalow
CO6 1BU - 188,000
- Freehold Flat/Maisonette
CO6 1BU - 691,000
- Freehold Detached property
CO6 1BU - 558,000
- Freehold Detached bungalow
CO6 1BU - 585,000
- Freehold Detached bungalow