SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CA26 3XY' order by fulladdress
CA26 3XY - 172,000
- Freehold End terrace house
CA26 3XY - 130,000
- Freehold End terrace house
CA26 3XY - 161,000
- Freehold Terrace property
CA26 3XY - 430,000
- Freehold Detached property
CA26 3XY - 267,000
- Freehold Terrace property
CA26 3XY - 355,000
- Freehold Detached bungalow
CA26 3XY - 422,000
- Freehold Detached bungalow
CA26 3XY - 382,000
- Freehold Semi-detached house
CA26 3XY - 405,000
- Freehold Detached house
CA26 3XY - 392,000
- Freehold Detached bungalow
CA26 3XY - 373,000
- Freehold Detached house
CA26 3XY - 471,000
- Freehold Detached house
CA26 3XY - 398,000
- Freehold Semi-detached property
CA26 3XY - 360,000
- Freehold Detached bungalow
CA26 3XY - 406,000
- Freehold Detached house
CA26 3XY - 486,000
- Freehold Detached bungalow
CA26 3XY - 417,000
- Freehold Detached property
