SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT19 8RN' order by fulladdress
KT19 8RN - 941,000
- Freehold Detached house
KT19 8RN - 853,000
- Freehold Detached house
KT19 8RN - 985,000
- Freehold Detached house
KT19 8RN - 1,144,000
- Freehold Detached house
KT19 8RN - 864,000
- Freehold Detached house
KT19 8RN - 1,014,000
- Freehold Detached bungalow
KT19 8RN - 950,000
- Freehold Detached house
KT19 8RN - 818,000
- Freehold Detached bungalow
KT19 8RN - 822,000
- Freehold Detached house
KT19 8RN - 946,000
- Freehold Detached bungalow
KT19 8RN - 772,000
- Freehold Detached property
KT19 8RN - 853,000
- Freehold Semi-detached house
KT19 8RN - 865,000
- Freehold Semi-detached house
KT19 8RN - 1,075,000
- Freehold Detached property
KT19 8RN - 1,022,000
- Freehold Detached house
KT19 8RN - 819,000
- Freehold Detached property
KT19 8RN - 1,045,000
- Freehold Detached house
KT19 8RN - 787,000
- Freehold Detached bungalow
KT19 8RN - 1,102,000
- Freehold Detached house
KT19 8RN - 833,000
- Freehold Semi-detached house
KT19 8RN - 822,000
- Freehold Semi-detached house
KT19 8RN - 993,000
- Freehold Detached house
KT19 8RN - 772,000
- Freehold Semi-detached house
KT19 8RN - 819,000
- Freehold Detached property
KT19 8RN - 930,000
- Freehold Detached house
KT19 8RN - 860,000
- Freehold Detached house
KT19 8RN - 317,000
- Leasehold Purpose built flat
KT19 8RN - 340,000
- Leasehold Mid terrace house
KT19 8RN - 933,000
- Freehold Detached bungalow
