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 4ET' order by fulladdress
KT6 4ET - 1,741,000
- Freehold Terraced
KT6 4ET - 1,653,000
- Freehold Mid terrace house
KT6 4ET - 1,724,000
- Freehold Mid terrace house
KT6 4ET - 1,749,000
- Freehold Terraced
KT6 4ET - 1,602,000
- Freehold Terrace property
KT6 4ET - 1,542,000
- Freehold Terrace property
KT6 4ET - 1,637,000
- Freehold Mid terrace house
KT6 4ET - 1,591,000
- Mid terrace house
KT6 4ET - 1,722,000
- Freehold Mid terrace house
KT6 4ET - 1,689,000
- Freehold End terrace house
KT6 4ET - 1,585,000
- Freehold Terrace property
KT6 4ET - 1,832,000
- Freehold End terrace house
KT6 4ET - 1,749,000
- Freehold Mid terrace house
KT6 4ET - 1,764,000
- Freehold Mid terrace house
KT6 4ET - 1,694,000
- Freehold Mid terrace house
KT6 4ET - 1,856,000
- Freehold Terraced
KT6 4ET - 1,825,000
- Freehold Mid terrace house
KT6 4ET - 1,813,000
- Freehold Terraced
KT6 4ET - 1,819,000
- Freehold Mid terrace house
KT6 4ET - 1,817,000
- Freehold Mid terrace house
KT6 4ET - 1,920,000
- Freehold End terrace house
KT6 4ET - 1,730,000
- Freehold Mid terrace house
KT6 4ET - 945,000
- Leasehold Flat/Maisonette
KT6 4ET - 893,000
- Leasehold Purpose built flat
KT6 4ET - 903,000
- Leasehold Flat/Maisonette
KT6 4ET - 0
- Leasehold Flat/Maisonette
KT6 4ET - 868,000
- Leasehold Flat/Maisonette
KT6 4ET - 912,000
- Leasehold Flat/Maisonette
KT6 4ET - 973,000
- Leasehold Flat/Maisonette
KT6 4ET - 1,015,000
- Leasehold Purpose built flat
KT6 4ET - 903,000
- Leasehold Purpose built flat
KT6 4ET - 863,000
- Leasehold Purpose built flat
KT6 4ET - 1,908,000
- Freehold Mid terrace house
KT6 4ET - 892,000
- Leasehold Purpose built flat
KT6 4ET - 1,111,000
- Leasehold Purpose built flat
KT6 4ET - 870,000
- Leasehold Flat/Maisonette
KT6 4ET - 875,000
- Leasehold Flat/Maisonette
KT6 4ET - 941,000
- Leasehold Purpose built flat
KT6 4ET - 961,000
- Leasehold Flat/Maisonette
KT6 4ET - 0
- Leasehold Purpose built flat
KT6 4ET - 1,435,000
- Freehold Mid terrace house
KT6 4ET - 1,647,000
- Freehold End terrace house
KT6 4ET - 1,829,000
- Freehold Terraced
KT6 4ET - 1,728,000
- Freehold Detached property
KT6 4ET - 1,721,000
- Freehold Mid terrace house
