SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT14 6AN' order by fulladdress
KT14 6AN - 744,000
- Freehold Detached house
KT14 6AN - 599,000
- Freehold Detached bungalow
KT14 6AN - 816,000
- Freehold Detached house
KT14 6AN - 662,000
- Freehold Detached bungalow
KT14 6AN - 618,000
- Freehold Detached bungalow
KT14 6AN - 563,000
- Freehold Detached house
KT14 6AN - 749,000
- Freehold Detached house
KT14 6AN - 946,000
- Freehold Detached house
KT14 6AN - 848,000
- Freehold Detached bungalow
KT14 6AN - 648,000
- Freehold Detached house
KT14 6AN - 766,000
- Freehold Detached house
KT14 6AN - 840,000
- Freehold Detached house
KT14 6AN - 766,000
- Freehold Detached house
KT14 6AN - 976,000
- Freehold Detached house
KT14 6AN - 701,000
- Freehold Detached bungalow
KT14 6AN - 868,000
- Freehold Detached house
KT14 6AN - 795,000
- Freehold Detached house
KT14 6AN - 876,000
- Freehold Detached house
KT14 6AN - 841,000
- Freehold Detached house
KT14 6AN - 810,000
- Freehold Detached house
KT14 6AN - 794,000
- Freehold Detached house
KT14 6AN - 801,000
- Freehold Detached house
KT14 6AN - 773,000
- Freehold Detached house
KT14 6AN - 776,000
- Freehold Detached house
KT14 6AN - 821,000
- Freehold Detached house
