SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT6 4AJ' order by fulladdress
KT6 4AJ - 1,010,000
- Freehold Semi-detached house
KT6 4AJ - 875,000
- Freehold Semi-detached house
KT6 4AJ - 923,000
- Freehold End terrace house
KT6 4AJ - 834,000
- Freehold Mid terrace house
KT6 4AJ - 862,000
- Freehold Terrace property
KT6 4AJ - 857,000
- Freehold Mid terrace house
KT6 4AJ - 841,000
- Freehold Terrace property
KT6 4AJ - 829,000
- Freehold Bungalow property
KT6 4AJ - 860,000
- Freehold Detached house
KT6 4AJ - 833,000
- Freehold Mid terrace house
KT6 4AJ - 903,000
- Freehold Mid terrace house
KT6 4AJ - 905,000
- Freehold Semi-detached house
KT6 4AJ - 876,000
- Freehold End terrace house
KT6 4AJ - 1,014,000
- Freehold End terrace house
KT6 4AJ - 931,000
- Freehold Mid terrace house
KT6 4AJ - 942,000
- Freehold End terrace house
KT6 4AJ - 884,000
- Freehold End terrace house
KT6 4AJ - 907,000
- Freehold Mid terrace house
KT6 4AJ - 838,000
- Freehold Terrace property
KT6 4AJ - 957,000
- Freehold Mid terrace house
KT6 4AJ - 896,000
- Freehold Mid terrace house
KT6 4AJ - 925,000
- Freehold Mid terrace house
KT6 4AJ - 874,000
- Freehold Mid terrace house
KT6 4AJ - 898,000
- Freehold Mid terrace house
KT6 4AJ - 980,000
- Freehold Mid terrace house
KT6 4AJ - 974,000
- Freehold Detached house
KT6 4AJ - 944,000
- Freehold Mid terrace house
KT6 4AJ - 945,000
- Freehold Mid terrace house
KT6 4AJ - 942,000
- Freehold Mid terrace house
KT6 4AJ - 958,000
- Freehold Mid terrace house
KT6 4AJ - 930,000
- Freehold Mid terrace house
KT6 4AJ - 585,000
- Freehold Mid terrace house
KT6 4AJ - 891,000
- Freehold Semi-detached house
KT6 4AJ - 919,000
- Freehold Semi-detached house
KT6 4AJ - 330,000
- Leasehold Purpose built flat
KT6 4AJ - 344,000
- Leasehold Converted flat
KT6 4AJ - 325,000
- Leasehold Converted flat
KT6 4AJ - 353,000
- Leasehold Converted flat
KT6 4AJ - 347,000
- Share of freehold Converted flat
KT6 4AJ - 552,000
- Leasehold Converted flat
KT6 4AJ - 528,000
- Leasehold Converted flat
KT6 4AJ - 362,000
- Leasehold Converted flat
KT6 4AJ - 626,000
- Leasehold Converted flat
