SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT23 4BH' order by fulladdress
KT23 4BH - 1,193,000
- Freehold Detached house
KT23 4BH - 1,696,000
- Freehold Detached house
KT23 4BH - 1,787,000
- Freehold Detached house
KT23 4BH - 982,000
- Freehold Detached bungalow
KT23 4BH - 1,260,000
- Freehold Detached house
KT23 4BH - 1,097,000
- Freehold Detached house
KT23 4BH - 1,145,000
- Freehold Detached house
KT23 4BH - 914,000
- Freehold Detached house
KT23 4BH - 1,273,000
- Freehold Detached property
KT23 4BH - 1,232,000
- Freehold Detached house
KT23 4BH - 1,276,000
- Freehold Detached property
KT23 4BH - 1,664,000
- Freehold Detached house
KT23 4BH - 1,638,000
- Freehold Detached house
KT23 4BH - 1,335,000
- Freehold Detached house
KT23 4BH - 958,000
- Freehold Detached house
KT23 4BH - 938,000
- Freehold Detached house
KT23 4BH - 1,675,000
- Freehold Detached house
KT23 4BH - 1,180,000
- Freehold Detached house
KT23 4BH - 1,927,000
- Freehold Detached house
KT23 4BH - 1,149,000
- Freehold Detached property
KT23 4BH - 949,000
- Freehold Detached house
KT23 4BH - 1,352,000
- Freehold Detached house
KT23 4BH - 1,142,000
- Freehold Detached property
KT23 4BH - 1,374,000
- Freehold Detached house
