SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CH61 4XY' order by fulladdress
CH61 4XY - 218,000
- Freehold Semi-detached bungalow
CH61 4XY - 233,000
- Freehold Semi-detached bungalow
CH61 4XY - 234,000
- Freehold Semi-detached bungalow
CH61 4XY - 229,000
- Freehold Semi-detached bungalow
CH61 4XY - 230,000
- Freehold Semi-detached bungalow
CH61 4XY - 226,000
- Freehold Semi-detached bungalow
CH61 4XY - 227,000
- Freehold Semi-detached bungalow
CH61 4XY - 368,000
- Freehold Detached house
CH61 4XY - 311,000
- Freehold Semi-detached property
CH61 4XY - 376,000
- Freehold Detached house
CH61 4XY - 416,000
- Freehold Detached house
CH61 4XY - 398,000
- Freehold Detached house
CH61 4XY - 242,000
- Freehold Semi-detached house
CH61 4XY - 253,000
- Freehold Semi-detached house
CH61 4XY - 249,000
- Freehold Semi-detached house
CH61 4XY - 277,000
- Freehold Semi-detached house
CH61 4XY - 235,000
- Freehold Semi-detached house
CH61 4XY - 252,000
- Freehold Semi-detached house
CH61 4XY - 246,000
- Freehold Semi-detached property
CH61 4XY - 331,000
- Freehold Detached house
CH61 4XY - 332,000
- Freehold Detached house
CH61 4XY - 342,000
- Freehold Detached house
CH61 4XY - 250,000
- Freehold Semi-detached house
CH61 4XY - 252,000
- Freehold Semi-detached house
CH61 4XY - 291,000
- Freehold Semi-detached house
CH61 4XY - 251,000
- Freehold Semi-detached property
CH61 4XY - 207,000
- Freehold Semi-detached bungalow