SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT8 1RG' order by fulladdress
KT8 1RG - 894,000
- Freehold Semi-detached house
KT8 1RG - 680,000
- Freehold Detached bungalow
KT8 1RG - 783,000
- Freehold Semi-detached property
KT8 1RG - 830,000
- Freehold Semi-detached house
KT8 1RG - 616,000
- Freehold Detached bungalow
KT8 1RG - 1,107,000
- Freehold Detached house
KT8 1RG - 645,000
- Freehold Detached bungalow
KT8 1RG - 1,230,000
- Freehold Detached property
KT8 1RG - 633,000
- Freehold Detached bungalow
KT8 1RG - 872,000
- Freehold Semi-detached house
KT8 1RG - 759,000
- Freehold Detached house
KT8 1RG - 972,000
- Freehold Detached bungalow
KT8 1RG - 702,000
- Freehold Detached bungalow
KT8 1RG - 790,000
- Freehold Detached bungalow
KT8 1RG - 835,000
- Freehold Detached property
KT8 1RG - 652,000
- Freehold Semi-detached house
KT8 1RG - 868,000
- Freehold Semi-detached house
KT8 1RG - 837,000
- Semi-detached house
KT8 1RG - 582,000
- Freehold Detached bungalow
KT8 1RG - 949,000
- Freehold Detached house
KT8 1RG - 923,000
- Freehold Detached house
KT8 1RG - 1,034,000
- Freehold Detached bungalow
KT8 1RG - 763,000
- Freehold Detached bungalow
KT8 1RG - 797,000
- Freehold Detached bungalow
KT8 1RG - 843,000
- Freehold Detached bungalow
KT8 1RG - 744,000
- Freehold Detached bungalow
KT8 1RG - 860,000
- Freehold Semi-detached house
KT8 1RG - 714,000
- Freehold Semi-detached house
KT8 1RG - 936,000
- Freehold Detached house
KT8 1RG - 600,000
- Freehold Semi-detached bungalow
KT8 1RG - 629,000
- Freehold Semi-detached bungalow
KT8 1RG - 686,000
- Freehold Detached property
KT8 1RG - 641,000
- Freehold Detached house
KT8 1RG - 673,000
- Freehold Detached bungalow
KT8 1RG - 672,000
- Freehold Detached bungalow
KT8 1RG - 751,000
- Freehold Detached bungalow
KT8 1RG - 936,000
- Freehold Detached house
KT8 1RG - 806,000
- Freehold Detached house
KT8 1RG - 654,000
- Freehold Semi-detached house
KT8 1RG - 1,061,000
- Freehold Detached property
KT8 1RG - 952,000
- Freehold Detached house
KT8 1RG - 928,000
- Freehold Detached house
KT8 1RG - 928,000
- Freehold Detached house
KT8 1RG - 930,000
- Freehold Detached house
KT8 1RG - 699,000
- Semi-detached house
KT8 1RG - 748,000
- Semi-detached house
KT8 1RG - 638,000
- Freehold Semi-detached house
KT8 1RG - 1,017,000
- Freehold Detached house