SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT10 0DT' order by fulladdress
KT10 0DT - 987,000
- Freehold Semi-detached house
KT10 0DT - 869,000
- Freehold Semi-detached house
KT10 0DT - 872,000
- Freehold Semi-detached house
KT10 0DT - 883,000
- Freehold Semi-detached property
KT10 0DT - 775,000
- Freehold Semi-detached house
KT10 0DT - 938,000
- Freehold Semi-detached house
KT10 0DT - 888,000
- Freehold Semi-detached house
KT10 0DT - 931,000
- Freehold Semi-detached property
KT10 0DT - 889,000
- Freehold Semi-detached house
KT10 0DT - 784,000
- Freehold Semi-detached house
KT10 0DT - 857,000
- Freehold Semi-detached house
KT10 0DT - 761,000
- Freehold Semi-detached house
KT10 0DT - 1,019,000
- Freehold Semi-detached house
KT10 0DT - 1,234,000
- Freehold Detached house
KT10 0DT - 1,149,000
- Freehold Detached house
KT10 0DT - 850,000
- Freehold Semi-detached house
KT10 0DT - 935,000
- Freehold Semi-detached house
KT10 0DT - 891,000
- Freehold Semi-detached house
KT10 0DT - 942,000
- Freehold Semi-detached house
KT10 0DT - 958,000
- Freehold Semi-detached property
KT10 0DT - 860,000
- Freehold Semi-detached house
KT10 0DT - 901,000
- Freehold Semi-detached property
KT10 0DT - 896,000
- Freehold Semi-detached house
KT10 0DT - 850,000
- Freehold Semi-detached house
KT10 0DT - 863,000
- Freehold Semi-detached property
KT10 0DT - 805,000
- Freehold Semi-detached house
KT10 0DT - 872,000
- Freehold Semi-detached house
KT10 0DT - 877,000
- Freehold Semi-detached house
KT10 0DT - 867,000
- Freehold Semi-detached house
KT10 0DT - 822,000
- Freehold Semi-detached house