SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CT5 2EL' order by fulladdress
CT5 2EL - 509,000
- Freehold Detached house
CT5 2EL - 575,000
- Freehold Detached bungalow
CT5 2EL - 545,000
- Freehold Mid terrace house
CT5 2EL - 491,000
- Freehold Detached bungalow
CT5 2EL - 640,000
- Freehold Mid terrace house
CT5 2EL - 453,000
- Freehold Semi-detached property
CT5 2EL - 223,000
- Feudal Converted flat
CT5 2EL - 379,000
- Freehold Semi-detached house
CT5 2EL - 560,000
- Freehold Mid terrace house
CT5 2EL - 843,000
- Freehold Detached house
CT5 2EL - 655,000
- Freehold Detached house
CT5 2EL - 483,000
- Freehold Semi-detached bungalow
CT5 2EL - 596,000
- Freehold Mid terrace house
CT5 2EL - 535,000
- Freehold Terrace property
CT5 2EL - 680,000
- Freehold Terrace property
CT5 2EL - 542,000
- Freehold Mid terrace house
CT5 2EL - 628,000
- Freehold Terrace property
CT5 2EL - 527,000
- Freehold Mid terrace house
CT5 2EL - 620,000
- Freehold Mid terrace house
CT5 2EL - 474,000
- Freehold Terrace property
CT5 2EL - 617,000
- Freehold Semi-detached house
CT5 2EL - 721,000
- Freehold Semi-detached property
CT5 2EL - 668,000
- Freehold Mid terrace house
CT5 2EL - 546,000
- Freehold Mid terrace house
CT5 2EL - 377,000
- Freehold Semi-detached property
CT5 2EL - 574,000
- Freehold Mid terrace house
CT5 2EL - 574,000
- Freehold Terrace property
CT5 2EL - 558,000
- Freehold Mid terrace house
CT5 2EL - 300,000
- Freehold Converted flat
CT5 2EL - 513,000
- Freehold Terrace property
CT5 2EL - 781,000
- Freehold Semi-detached house
CT5 2EL - 390,000
- Freehold Semi-detached property
CT5 2EL - 536,000
- Freehold End terrace house
CT5 2EL - 557,000
- Freehold Mid terrace house
CT5 2EL - 460,000
- Freehold Detached bungalow
