SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CO4 9TH' order by fulladdress
CO4 9TH - 586,000
- Freehold Detached property
CO4 9TH - 686,000
- Freehold Detached house
CO4 9TH - 777,000
- Freehold Detached house
CO4 9TH - 711,000
- Freehold Detached house
CO4 9TH - 830,000
- Freehold Detached property
CO4 9TH - 712,000
- Freehold Detached house
CO4 9TH - 614,000
- Freehold Detached property
CO4 9TH - 724,000
- Freehold Detached house
CO4 9TH - 796,000
- Freehold Detached house
CO4 9TH - 714,000
- Freehold Detached house
CO4 9TH - 706,000
- Freehold Detached house
CO4 9TH - 716,000
- Freehold Detached house
CO4 9TH - 512,000
- Freehold Detached house
CO4 9TH - 784,000
- Freehold Detached house
CO4 9TH - 737,000
- Freehold Detached property
CO4 9TH - 667,000
- Freehold Detached house
CO4 9TH - 696,000
- Freehold Detached house
CO4 9TH - 702,000
- Freehold Detached house
CO4 9TH - 493,000
- Freehold Detached house
CO4 9TH - 744,000
- Freehold Detached house
CO4 9TH - 548,000
- Freehold Detached house
CO4 9TH - 584,000
- Freehold Detached house
CO4 9TH - 776,000
- Freehold Detached property
