SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CB6 1QF' order by fulladdress
CB6 1QF - 245,000
- Freehold Semi-detached house
CB6 1QF - 290,000
- Freehold Detached house
CB6 1QF - 237,000
- Freehold Semi-detached property
CB6 1QF - 251,000
- Freehold Semi-detached house
CB6 1QF - 266,000
- Freehold Semi-detached bungalow
CB6 1QF - 299,000
- Freehold Detached bungalow
CB6 1QF - 186,000
- Semi-detached house
CB6 1QF - 353,000
- Freehold Detached bungalow
CB6 1QF - 404,000
- Freehold Detached bungalow
CB6 1QF - 308,000
- Freehold Detached house
CB6 1QF - 329,000
- Freehold Detached house
CB6 1QF - 314,000
- Freehold Detached house
CB6 1QF - 284,000
- Freehold Semi-detached house
CB6 1QF - 275,000
- Freehold Semi-detached house
CB6 1QF - 329,000
- Freehold Detached house
CB6 1QF - 312,000
- Freehold Detached property
CB6 1QF - 204,000
- Freehold Semi-detached house
CB6 1QF - 215,000
- Freehold Semi-detached house
CB6 1QF - 374,000
- Freehold Detached house
CB6 1QF - 361,000
- Freehold Detached house
CB6 1QF - 391,000
- Freehold Detached house
CB6 1QF - 329,000
- Freehold Detached house
CB6 1QF - 446,000
- Freehold Detached property
CB6 1QF - 453,000
- Freehold Detached house
CB6 1QF - 265,000
- Freehold Semi-detached house
CB6 1QF - 258,000
- Freehold Semi-detached house
CB6 1QF - 285,000
- Freehold Semi-detached house
CB6 1QF - 301,000
- Freehold Semi-detached house
CB6 1QF - 290,000
- Freehold Semi-detached house
CB6 1QF - 297,000
- Semi-detached house
CB6 1QF - 409,000
- Freehold Detached house
CB6 1QF - 514,000
- Freehold Detached house
CB6 1QF - 511,000
- Freehold Detached house
CB6 1QF - 396,000
- Freehold Detached house
CB6 1QF - 401,000
- Freehold Detached house
CB6 1QF - 350,000
- Freehold Detached house
CB6 1QF - 294,000
- Semi-detached house
