SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W1H 6LJ' order by fulladdress
W1H 6LJ - 991,000
- Leasehold Flat/Maisonette
W1H 6LJ - 1,682,000
- Leasehold Purpose built flat
W1H 6LJ - 1,412,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,887,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,197,000
- Leasehold Flat/Maisonette
W1H 6LJ - 3,126,000
- Leasehold Purpose built flat
W1H 6LJ - 1,066,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,536,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,188,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,169,000
- Leasehold Purpose built flat
W1H 6LJ - 2,743,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,044,000
- Leasehold Flat/Maisonette
W1H 6LJ - 4,296,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,363,000
- Leasehold Flat/Maisonette
W1H 6LJ - 547,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,560,000
- Leasehold Purpose built flat
W1H 6LJ - 2,370,000
- Leasehold Flat/Maisonette
W1H 6LJ - 1,854,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,294,000
- Leasehold Flat/Maisonette
W1H 6LJ - 1,863,000
- Leasehold Purpose built flat
W1H 6LJ - 2,005,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,316,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,498,000
- Leasehold Flat/Maisonette
W1H 6LJ - 1,211,000
- Leasehold Purpose built flat
W1H 6LJ - 3,572,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,338,000
- Leasehold Purpose built flat
W1H 6LJ - 1,796,000
- Leasehold Purpose built flat
W1H 6LJ - 1,939,000
- Leasehold Flat/Maisonette
W1H 6LJ - 1,336,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,195,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,346,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,471,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,216,000
- Leasehold Flat/Maisonette
W1H 6LJ - 2,233,000
- Leasehold Purpose built flat
W1H 6LJ - 5,049,000
- Leasehold Flat/Maisonette
W1H 6LJ - 3,027,000
- Leasehold Flat/Maisonette