SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CW12 4FY' order by fulladdress
CW12 4FY - 164,000
- Freehold Semi-detached house
CW12 4FY - 185,000
- Freehold Semi-detached property
CW12 4FY - 182,000
- Freehold Terrace property
CW12 4FY - 165,000
- Freehold End terrace house
CW12 4FY - 168,000
- Freehold Mid terrace house
CW12 4FY - 211,000
- Freehold Semi-detached house
CW12 4FY - 184,000
- Leasehold Purpose built flat
CW12 4FY - 193,000
- Freehold Semi-detached house
CW12 4FY - 183,000
- Leasehold Flat/Maisonette
CW12 4FY - 199,000
- Freehold Semi-detached house
CW12 4FY - 188,000
- Leasehold Purpose built flat
CW12 4FY - 165,000
- Freehold Terrace property
CW12 4FY - 206,000
- Leasehold Flat/Maisonette
CW12 4FY - 165,000
- Freehold Terrace property
CW12 4FY - 179,000
- Leasehold Purpose built flat
CW12 4FY - 179,000
- Freehold End terrace house
CW12 4FY - 175,000
- Leasehold Flat/Maisonette
CW12 4FY - 201,000
- Leasehold Purpose built flat
CW12 4FY - 202,000
- Leasehold Flat/Maisonette
CW12 4FY - 507,000
- Freehold Detached house
CW12 4FY - 175,000
- Leasehold Purpose built flat
CW12 4FY - 470,000
- Freehold Detached house
CW12 4FY - 469,000
- Freehold Detached house
CW12 4FY - 168,000
- Freehold Semi-detached house
CW12 4FY - 492,000
- Freehold Detached house
CW12 4FY - 515,000
- Freehold Detached property
CW12 4FY - 454,000
- Freehold Detached house
CW12 4FY - 465,000
- Freehold Detached property
CW12 4FY - 430,000
- Freehold Detached house
CW12 4FY - 413,000
- Freehold Detached house
CW12 4FY - 499,000
- Freehold Detached house
CW12 4FY - 410,000
- Freehold Detached house
CW12 4FY - 466,000
- Freehold Detached house
CW12 4FY - 425,000
- Freehold Detached house
CW12 4FY - 451,000
- Freehold Detached house
CW12 4FY - 415,000
- Freehold Detached house
CW12 4FY - 449,000
- Freehold Detached house
CW12 4FY - 514,000
- Freehold Detached property
CW12 4FY - 421,000
- Freehold Detached house
CW12 4FY - 487,000
- Freehold Detached house
CW12 4FY - 547,000
- Freehold Detached house
CW12 4FY - 443,000
- Freehold Detached house
CW12 4FY - 546,000
- Freehold Detached house
CW12 4FY - 184,000
- Freehold Semi-detached property
CW12 4FY - 411,000
- Freehold Detached house
CW12 4FY - 476,000
- Freehold Detached house
CW12 4FY - 546,000
- Freehold Detached house
CW12 4FY - 482,000
- Freehold Detached house
CW12 4FY - 465,000
- Freehold Detached property
CW12 4FY - 478,000
- Freehold Detached house
CW12 4FY - 361,000
- Freehold Detached house
CW12 4FY - 380,000
- Freehold Detached house
CW12 4FY - 546,000
- Freehold Detached house
CW12 4FY - 351,000
- Freehold Detached house
CW12 4FY - 511,000
- Freehold Detached house
CW12 4FY - 395,000
- Freehold Detached house
CW12 4FY - 347,000
- Freehold Detached house
CW12 4FY - 351,000
- Freehold Detached house
CW12 4FY - 407,000
- Freehold Detached house
CW12 4FY - 165,000
- Freehold Terrace property