SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT10 9PG' order by fulladdress
KT10 9PG - 4,627,000
- Freehold Detached house
KT10 9PG - 4,592,000
- Freehold Detached house
KT10 9PG - 3,365,000
- Freehold Detached house
KT10 9PG - 3,035,000
- Freehold Detached house
KT10 9PG - 645,000
- Leasehold Converted flat
KT10 9PG - 3,204,000
- Freehold Detached house
KT10 9PG - 4,416,000
- Freehold Detached house
KT10 9PG - 4,887,000
- Freehold Detached house
KT10 9PG - 3,343,000
- Freehold Detached house
KT10 9PG - 3,139,000
- Freehold Detached house
KT10 9PG - 2,081,000
- Freehold Detached bungalow
KT10 9PG - 3,149,000
- Freehold Detached house
KT10 9PG - 2,347,000
- Freehold Semi-detached house
KT10 9PG - 2,623,000
- Freehold Detached house
KT10 9PG - 4,933,000
- Freehold Detached property
KT10 9PG - 1,048,000
- Freehold Flat/Maisonette
KT10 9PG - 4,370,000
- Freehold Detached house
KT10 9PG - 2,568,000
- Freehold Detached house
KT10 9PG - 645,000
- Leasehold Purpose built flat
KT10 9PG - 822,000
- Leasehold Purpose built flat
KT10 9PG - 842,000
- Leasehold Flat/Maisonette
KT10 9PG - 800,000
- Leasehold Purpose built flat
KT10 9PG - 785,000
- Leasehold Flat/Maisonette
KT10 9PG - 2,249,000
- Freehold Detached house
KT10 9PG - 1,935,000
- Freehold Detached house
KT10 9PG - 4,425,000
- Freehold Detached house
KT10 9PG - 2,719,000
- Freehold Semi-detached house
KT10 9PG - 4,263,000
- Freehold Detached house
KT10 9PG - 2,971,000
- Freehold Detached property
KT10 9PG - 2,516,000
- Freehold Semi-detached house
KT10 9PG - 2,715,000
- Freehold Detached property
