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 9LT' order by fulladdress
KT8 9LT - 876,000
- Freehold Semi-detached house
KT8 9LT - 975,000
- Freehold Semi-detached property
KT8 9LT - 1,001,000
- Freehold Detached house
KT8 9LT - 1,008,000
- Freehold Detached house
KT8 9LT - 992,000
- Freehold Semi-detached house
KT8 9LT - 938,000
- Freehold Semi-detached house
KT8 9LT - 1,492,000
- Freehold Detached property
KT8 9LT - 1,518,000
- Freehold Detached house
KT8 9LT - 716,000
- Freehold Semi-detached house
KT8 9LT - 1,736,000
- Freehold Detached house
KT8 9LT - 1,081,000
- Freehold Detached house
KT8 9LT - 1,103,000
- Freehold Detached house
KT8 9LT - 1,065,000
- Freehold Detached house
KT8 9LT - 1,188,000
- Freehold Detached house
KT8 9LT - 920,000
- Freehold Semi-detached house
KT8 9LT - 981,000
- Freehold Semi-detached house
KT8 9LT - 1,059,000
- Freehold Semi-detached house
KT8 9LT - 1,060,000
- Freehold Semi-detached house
KT8 9LT - 1,011,000
- Freehold Detached house
KT8 9LT - 765,000
- Freehold Mid terrace house
KT8 9LT - 927,000
- Freehold Detached house
KT8 9LT - 805,000
- Freehold End terrace house
KT8 9LT - 1,011,000
- Freehold Detached house
KT8 9LT - 1,025,000
- Freehold Detached house
KT8 9LT - 1,011,000
- Freehold Detached property
