SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT17 2NX' order by fulladdress
KT17 2NX - 766,000
- Freehold Semi-detached house
KT17 2NX - 750,000
- Freehold Semi-detached property
KT17 2NX - 700,000
- Freehold Semi-detached house
KT17 2NX - 743,000
- Freehold Semi-detached house
KT17 2NX - 820,000
- Freehold Semi-detached house
KT17 2NX - 731,000
- Freehold Semi-detached house
KT17 2NX - 750,000
- Freehold Semi-detached house
KT17 2NX - 728,000
- Freehold Semi-detached house
KT17 2NX - 696,000
- Freehold Semi-detached house
KT17 2NX - 921,000
- Freehold Detached house
KT17 2NX - 812,000
- Freehold Semi-detached house
KT17 2NX - 754,000
- Freehold Semi-detached house
KT17 2NX - 849,000
- Freehold Semi-detached house
KT17 2NX - 726,000
- Freehold Semi-detached house
KT17 2NX - 791,000
- Freehold Semi-detached house
KT17 2NX - 886,000
- Freehold Semi-detached house
KT17 2NX - 806,000
- Freehold Semi-detached house
KT17 2NX - 759,000
- Freehold Semi-detached bungalow
KT17 2NX - 811,000
- Freehold Semi-detached house
KT17 2NX - 835,000
- Freehold Semi-detached house
KT17 2NX - 868,000
- Freehold Semi-detached property
KT17 2NX - 797,000
- Freehold Semi-detached bungalow
KT17 2NX - 825,000
- Freehold Semi-detached house
KT17 2NX - 839,000
- Freehold Semi-detached house
KT17 2NX - 778,000
- Freehold Semi-detached property
KT17 2NX - 612,000
- Freehold Detached bungalow
KT17 2NX - 758,000
- Freehold Semi-detached house
KT17 2NX - 840,000
- Freehold Semi-detached property
KT17 2NX - 786,000
- Freehold Semi-detached house
KT17 2NX - 855,000
- Freehold Semi-detached house
KT17 2NX - 826,000
- Freehold Semi-detached house