SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CO7 8FA' order by fulladdress
CO7 8FA - 428,000
- Freehold Detached house
CO7 8FA - 412,000
- Freehold Detached bungalow
CO7 8FA - 440,000
- Freehold Detached house
CO7 8FA - 450,000
- Freehold Detached bungalow
CO7 8FA - 534,000
- Freehold Detached house
CO7 8FA - 608,000
- Freehold Detached house
CO7 8FA - 530,000
- Freehold Detached house
CO7 8FA - 735,000
- Freehold Detached house
CO7 8FA - 596,000
- Freehold Detached house
CO7 8FA - 657,000
- Freehold Detached house
CO7 8FA - 427,000
- Freehold Detached house
CO7 8FA - 539,000
- Freehold Detached house
CO7 8FA - 632,000
- Freehold Detached house
CO7 8FA - 458,000
- Freehold Detached bungalow
CO7 8FA - 599,000
- Freehold Detached house
CO7 8FA - 487,000
- Freehold Detached bungalow
CO7 8FA - 662,000
- Freehold Detached house
CO7 8FA - 505,000
- Freehold Detached house
CO7 8FA - 622,000
- Freehold Detached house
CO7 8FA - 568,000
- Freehold Detached house
CO7 8FA - 743,000
- Freehold Detached house
CO7 8FA - 437,000
- Freehold Detached house
CO7 8FA - 437,000
- Freehold Detached house
CO7 8FA - 606,000
- Freehold Detached house
CO7 8FA - 429,000
- Freehold Detached house
CO7 8FA - 424,000
- Freehold Detached house
CO7 8FA - 427,000
- Freehold Detached house
CO7 8FA - 429,000
- Freehold Detached house
CO7 8FA - 525,000
- Freehold Detached house
CO7 8FA - 438,000
- Freehold Detached house
