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 7PL' order by fulladdress
KT6 7PL - 761,000
- Freehold Semi-detached house
KT6 7PL - 748,000
- Semi-detached house
KT6 7PL - 746,000
- Freehold Semi-detached house
KT6 7PL - 374,000
- Freehold Converted flat
KT6 7PL - 388,000
- Leasehold Converted flat
KT6 7PL - 401,000
- Leasehold Converted flat
KT6 7PL - 385,000
- Leasehold Converted flat
KT6 7PL - 665,000
- Freehold Semi-detached house
KT6 7PL - 656,000
- Freehold Semi-detached house
KT6 7PL - 668,000
- Freehold Semi-detached house
KT6 7PL - 666,000
- Freehold Semi-detached house
KT6 7PL - 726,000
- Freehold Semi-detached house
KT6 7PL - 782,000
- Freehold Semi-detached house
KT6 7PL - 679,000
- Semi-detached house
KT6 7PL - 788,000
- Freehold Semi-detached house
KT6 7PL - 0
- Freehold Mid terrace house
KT6 7PL - 705,000
- Freehold Mid terrace house
KT6 7PL - 655,000
- Freehold Mid terrace house
KT6 7PL - 714,000
- Freehold Mid terrace house
KT6 7PL - 700,000
- Freehold End terrace house
KT6 7PL - 711,000
- Freehold Semi-detached house
KT6 7PL - 754,000
- Freehold Semi-detached house
KT6 7PL - 674,000
- Semi-detached house
KT6 7PL - 730,000
- Freehold Semi-detached house
KT6 7PL - 763,000
- Freehold Semi-detached house
KT6 7PL - 596,000
- Freehold Semi-detached house
KT6 7PL - 761,000
- Freehold Semi-detached house
KT6 7PL - 354,000
- Leasehold Purpose built flat
