SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W9 3TB' order by fulladdress
W9 3TB - 717,000
- Leasehold Flat/Maisonette
W9 3TB - 518,000
- Leasehold Flat/Maisonette
W9 3TB - 720,000
- Leasehold Flat/Maisonette
W9 3TB - 553,000
- Leasehold Flat/Maisonette
W9 3TB - 700,000
- Leasehold Flat/Maisonette
W9 3TB - 527,000
- Leasehold Purpose built flat
W9 3TB - 518,000
- Leasehold Purpose built flat
W9 3TB - 734,000
- Leasehold Flat/Maisonette
W9 3TB - 531,000
- Leasehold Purpose built flat
W9 3TB - 632,000
- Leasehold Purpose built flat
W9 3TB - 779,000
- Feudal Purpose built flat
W9 3TB - 713,000
- Leasehold Purpose built flat
W9 3TB - 546,000
- Leasehold Purpose built flat
W9 3TB - 718,000
- Leasehold Purpose built flat
W9 3TB - 699,000
- Leasehold Purpose built flat
W9 3TB - 974,000
- Leasehold Purpose built flat
W9 3TB - 758,000
- Leasehold Flat/Maisonette
W9 3TB - 684,000
- Leasehold Flat/Maisonette
W9 3TB - 547,000
- Leasehold Purpose built flat
W9 3TB - 637,000
- Leasehold Purpose built flat
W9 3TB - 518,000
- Leasehold Purpose built flat
W9 3TB - 518,000
- Leasehold Purpose built flat
W9 3TB - 526,000
- Leasehold Purpose built flat
W9 3TB - 698,000
- Leasehold Flat/Maisonette
W9 3TB - 567,000
- Leasehold Purpose built flat
W9 3TB - 535,000
- Leasehold Flat/Maisonette
W9 3TB - 685,000
- Leasehold Purpose built flat
W9 3TB - 579,000
- Leasehold Purpose built flat
W9 3TB - 508,000
- Leasehold Purpose built flat
W9 3TB - 542,000
- Leasehold Purpose built flat
W9 3TB - 558,000
- Leasehold Flat/Maisonette
W9 3TB - 544,000
- Leasehold Flat/Maisonette
W9 3TB - 559,000
- Leasehold Purpose built flat
W9 3TB - 691,000
- Leasehold Purpose built flat
W9 3TB - 627,000
- Leasehold Flat/Maisonette
W9 3TB - 506,000
- Leasehold Flat/Maisonette
W9 3TB - 711,000
- Leasehold Flat/Maisonette
W9 3TB - 833,000
- Leasehold Flat/Maisonette
W9 3TB - 712,000
- Leasehold Purpose built flat
W9 3TB - 541,000
- Leasehold Flat/Maisonette
W9 3TB - 644,000
- Leasehold Flat/Maisonette
W9 3TB - 687,000
- Leasehold Purpose built flat
W9 3TB - 540,000
- Leasehold Flat/Maisonette