SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W6 9LH' order by fulladdress
W6 9LH - 809,000
- Leasehold Purpose built flat
W6 9LH - 946,000
- Leasehold Flat/Maisonette
W6 9LH - 245,000
- Leasehold Purpose built flat
W6 9LH - 250,000
- Leasehold Purpose built flat
W6 9LH - 550,000
- Leasehold Flat/Maisonette
W6 9LH - 241,000
- Leasehold Purpose built flat
W6 9LH - 569,000
- Leasehold Flat/Maisonette
W6 9LH - 592,000
- Leasehold Flat/Maisonette
W6 9LH - 1,121,000
- Leasehold Flat/Maisonette
W6 9LH - 1,108,000
- Leasehold Flat/Maisonette
W6 9LH - 688,000
- Leasehold Flat/Maisonette
W6 9LH - 663,000
- Leasehold Flat/Maisonette
W6 9LH - 706,000
- Leasehold Flat/Maisonette
W6 9LH - 1,149,000
- Leasehold Flat/Maisonette
W6 9LH - 241,000
- Leasehold Flat/Maisonette
W6 9LH - 241,000
- Leasehold Flat/Maisonette
W6 9LH - 566,000
- Leasehold Flat/Maisonette
W6 9LH - 229,000
- Leasehold Purpose built flat
W6 9LH - 569,000
- Leasehold Flat/Maisonette
W6 9LH - 710,000
- Leasehold Flat/Maisonette
W6 9LH - 1,095,000
- Leasehold Flat/Maisonette
W6 9LH - 1,095,000
- Leasehold Flat/Maisonette
W6 9LH - 1,063,000
- Leasehold Flat/Maisonette
W6 9LH - 962,000
- Leasehold Flat/Maisonette
W6 9LH - 248,000
- Leasehold Flat/Maisonette
W6 9LH - 235,000
- Leasehold Flat/Maisonette
W6 9LH - 246,000
- Leasehold Purpose built flat
W6 9LH - 550,000
- Leasehold Flat/Maisonette
W6 9LH - 723,000
- Leasehold Flat/Maisonette
W6 9LH - 570,000
- Leasehold Flat/Maisonette
W6 9LH - 1,129,000
- Leasehold Flat/Maisonette
W6 9LH - 1,182,000
- Leasehold Flat/Maisonette
W6 9LH - 1,070,000
- Leasehold Flat/Maisonette
W6 9LH - 1,876,000
- Leasehold Flat/Maisonette
W6 9LH - 979,000
- Leasehold Flat/Maisonette
W6 9LH - 259,000
- Leasehold Flat/Maisonette
W6 9LH - 258,000
- Leasehold Flat/Maisonette
W6 9LH - 566,000
- Leasehold Flat/Maisonette
W6 9LH - 262,000
- Leasehold Flat/Maisonette
W6 9LH - 569,000
- Leasehold Flat/Maisonette
W6 9LH - 1,123,000
- Leasehold Flat/Maisonette
W6 9LH - 696,000
- Leasehold Flat/Maisonette
W6 9LH - 1,129,000
- Leasehold Flat/Maisonette
W6 9LH - 739,000
- Leasehold Flat/Maisonette
W6 9LH - 1,110,000
- Leasehold Flat/Maisonette
W6 9LH - 1,633,000
- Leasehold Flat/Maisonette
W6 9LH - 726,000
- Leasehold Flat/Maisonette
W6 9LH - 257,000
- Leasehold Purpose built flat
W6 9LH - 258,000
- Leasehold Flat/Maisonette
W6 9LH - 565,000
- Leasehold Purpose built flat
W6 9LH - 262,000
- Leasehold Flat/Maisonette
W6 9LH - 1,220,000
- Leasehold Purpose built flat
W6 9LH - 551,000
- Leasehold Flat/Maisonette
W6 9LH - 707,000
- Leasehold Purpose built flat
W6 9LH - 1,200,000
- Leasehold Flat/Maisonette
W6 9LH - 964,000
- Leasehold Purpose built flat
W6 9LH - 1,793,000
- Leasehold Flat/Maisonette
W6 9LH - 972,000
- Leasehold Flat/Maisonette
W6 9LH - 1,014,000
- Leasehold Flat/Maisonette
W6 9LH - 699,000
- Leasehold Flat/Maisonette
W6 9LH - 1,099,000
- Leasehold Flat/Maisonette
W6 9LH - 681,000
- Leasehold Flat/Maisonette
W6 9LH - 1,030,000
- Leasehold Flat/Maisonette
W6 9LH - 1,102,000
- Leasehold Purpose built flat
W6 9LH - 1,818,000
- Leasehold Flat/Maisonette
W6 9LH - 2,215,000
- Leasehold Flat/Maisonette
W6 9LH - 1,148,000
- Leasehold Flat/Maisonette
W6 9LH - 1,094,000
- Leasehold Flat/Maisonette
W6 9LH - 1,054,000
- Leasehold Flat/Maisonette
W6 9LH - 2,060,000
- Leasehold Flat/Maisonette
W6 9LH - 4,096,000
- Leasehold Flat/Maisonette
W6 9LH - 1,802,000
- Leasehold Flat/Maisonette
W6 9LH - 683,000
- Leasehold Flat/Maisonette
W6 9LH - 1,147,000
- Leasehold Flat/Maisonette