SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CW8 2BS' order by fulladdress
CW8 2BS - 438,000
- Freehold Semi-detached house
CW8 2BS - 565,000
- Freehold Detached house
CW8 2BS - 573,000
- Freehold Detached house
CW8 2BS - 517,000
- Freehold Detached house
CW8 2BS - 480,000
- Freehold Detached house
CW8 2BS - 356,000
- Freehold Detached property
CW8 2BS - 448,000
- Freehold Detached house
CW8 2BS - 339,000
- Freehold Semi-detached property
CW8 2BS - 361,000
- Freehold Detached house
CW8 2BS - 481,000
- Freehold Detached property
CW8 2BS - 355,000
- Freehold Detached house
CW8 2BS - 0
- Freehold Semi-detached property
CW8 2BS - 445,000
- Freehold Detached house
CW8 2BS - 0
- Freehold Semi-detached property
CW8 2BS - 329,000
- Freehold Detached house
CW8 2BS - 503,000
- Freehold Detached house
CW8 2BS - 313,000
- Freehold Semi-detached house
CW8 2BS - 467,000
- Freehold Detached property
CW8 2BS - 325,000
- Freehold Semi-detached property
CW8 2BS - 456,000
- Freehold Detached property
CW8 2BS - 267,000
- Freehold Semi-detached house
CW8 2BS - 327,000
- Freehold Detached property
CW8 2BS - 257,000
- Freehold Semi-detached house
CW8 2BS - 441,000
- Freehold Detached house
CW8 2BS - 227,000
- Freehold Semi-detached house
CW8 2BS - 393,000
- Freehold Detached house
CW8 2BS - 341,000
- Freehold Detached house
CW8 2BS - 228,000
- Leasehold Semi-detached house
CW8 2BS - 437,000
- Freehold Detached house
CW8 2BS - 348,000
- Freehold Detached house
CW8 2BS - 344,000
- Freehold Semi-detached house
CW8 2BS - 0
- Freehold End terrace house
CW8 2BS - 268,000
- Freehold Mid terrace house
CW8 2BS - 545,000
- Freehold Detached house
CW8 2BS - 352,000
- Freehold Detached house
CW8 2BS - 428,000
- Freehold Detached house
CW8 2BS - 430,000
- Freehold Detached property
CW8 2BS - 446,000
- Freehold Detached house
CW8 2BS - 420,000
- Freehold Detached house
CW8 2BS - 547,000
- Freehold Detached house
CW8 2BS - 422,000
- Freehold Detached house
CW8 2BS - 545,000
- Freehold Detached house
CW8 2BS - 366,000
- Freehold Detached house
CW8 2BS - 583,000
- Freehold Detached house