SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CA10 3RG' order by fulladdress
CA10 3RG - 433,000
- Freehold Semi-detached property
CA10 3RG - 212,000
- Freehold Semi-detached house
CA10 3RG - 468,000
- Freehold Semi-detached property
CA10 3RG - 274,000
- Freehold Mid terrace house
CA10 3RG - 280,000
- Freehold Semi-detached house
CA10 3RG - 233,000
- Freehold Semi-detached house
CA10 3RG - 412,000
- Freehold Detached bungalow
CA10 3RG - 262,000
- Freehold Semi-detached property
CA10 3RG - 385,000
- Freehold Semi-detached house
CA10 3RG - 569,000
- Freehold Detached house
CA10 3RG - 236,000
- Freehold Semi-detached property
CA10 3RG - 564,000
- Freehold Detached house
CA10 3RG - 366,000
- Freehold Detached house
CA10 3RG - 248,000
- Freehold Semi-detached house
CA10 3RG - 315,000
- Freehold Semi-detached house
CA10 3RG - 363,000
- Freehold Detached house
CA10 3RG - 481,000
- Freehold Detached house
CA10 3RG - 610,000
- Freehold Detached house
CA10 3RG - 528,000
- Freehold Detached house
CA10 3RG - 493,000
- Freehold Detached house
CA10 3RG - 512,000
- Freehold Detached house