SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT2 6AD' order by fulladdress
KT2 6AD - 1,141,000
- Freehold Detached property
KT2 6AD - 1,302,000
- Freehold Detached house
KT2 6AD - 1,161,000
- Freehold Semi-detached house
KT2 6AD - 1,145,000
- Freehold Detached house
KT2 6AD - 1,467,000
- Freehold Semi-detached house
KT2 6AD - 1,215,000
- Freehold Semi-detached property
KT2 6AD - 1,359,000
- Freehold Detached house
KT2 6AD - 690,000
- Freehold End terrace property
KT2 6AD - 878,000
- Freehold Mid terrace house
KT2 6AD - 1,384,000
- Freehold Semi-detached house
KT2 6AD - 1,412,000
- Freehold Semi-detached house
KT2 6AD - 1,531,000
- Freehold Semi-detached house
KT2 6AD - 1,530,000
- Freehold Semi-detached house
KT2 6AD - 1,167,000
- Freehold Detached house
KT2 6AD - 1,205,000
- Freehold Detached house
KT2 6AD - 1,031,000
- Semi-detached house
KT2 6AD - 552,000
- Leasehold Converted flat
KT2 6AD - 728,000
- Freehold End terrace house
KT2 6AD - 702,000
- Freehold End terrace house
KT2 6AD - 1,438,000
- Freehold Semi-detached house
KT2 6AD - 1,429,000
- Freehold Semi-detached house
KT2 6AD - 1,429,000
- Freehold Detached house
KT2 6AD - 1,120,000
- Semi-detached house
KT2 6AD - 1,247,000
- Freehold Detached house
KT2 6AD - 1,611,000
- Freehold Detached house
KT2 6AD - 1,284,000
- Freehold Detached house
KT2 6AD - 1,328,000
- Freehold Semi-detached house
KT2 6AD - 1,282,000
- Freehold Semi-detached property
KT2 6AD - 1,352,000
- Freehold Detached house
KT2 6AD - 1,444,000
- Freehold Semi-detached house
KT2 6AD - 1,533,000
- Freehold Detached house
KT2 6AD - 1,418,000
- Freehold Detached house
KT2 6AD - 1,179,000
- Freehold Detached house
KT2 6AD - 1,632,000
- Freehold Converted flat
KT2 6AD - 1,178,000
- Freehold Detached house
