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 4EY' order by fulladdress
KT6 4EY - 593,000
- Leasehold Purpose built flat
KT6 4EY - 645,000
- Leasehold Purpose built flat
KT6 4EY - 585,000
- Leasehold Purpose built flat
KT6 4EY - 613,000
- Leasehold Flat/Maisonette
KT6 4EY - 638,000
- Leasehold Flat/Maisonette
KT6 4EY - 641,000
- Leasehold Flat/Maisonette
KT6 4EY - 630,000
- Leasehold Purpose built flat
KT6 4EY - 651,000
- Leasehold Purpose built flat
KT6 4EY - 428,000
- Share of freehold Purpose built flat
KT6 4EY - 416,000
- Leasehold Flat/Maisonette
KT6 4EY - 605,000
- Leasehold Flat/Maisonette
KT6 4EY - 668,000
- Leasehold Purpose built flat
KT6 4EY - 467,000
- Leasehold Flat/Maisonette
KT6 4EY - 434,000
- Leasehold Flat/Maisonette
KT6 4EY - 642,000
- Leasehold Flat/Maisonette
KT6 4EY - 570,000
- Leasehold Purpose built flat
KT6 4EY - 640,000
- Leasehold Flat/Maisonette
KT6 4EY - 524,000
- Leasehold Purpose built flat
KT6 4EY - 663,000
- Freehold Purpose built flat
KT6 4EY - 583,000
- Leasehold Purpose built flat
KT6 4EY - 644,000
- Leasehold Flat/Maisonette
KT6 4EY - 538,000
- Leasehold Flat/Maisonette
KT6 4EY - 564,000
- Leasehold Purpose built flat
KT6 4EY - 432,000
- Leasehold Purpose built flat
KT6 4EY - 566,000
- Leasehold Purpose built flat
KT6 4EY - 498,000
- Leasehold Purpose built flat
KT6 4EY - 603,000
- Leasehold Purpose built flat
KT6 4EY - 427,000
- Leasehold Purpose built flat
KT6 4EY - 577,000
- Leasehold Purpose built flat
KT6 4EY - 597,000
- Leasehold Purpose built flat
KT6 4EY - 594,000
- Leasehold Flat/Maisonette
KT6 4EY - 668,000
- Leasehold Flat/Maisonette
KT6 4EY - 627,000
- Leasehold Purpose built flat
KT6 4EY - 610,000
- Leasehold Flat/Maisonette
