SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W8 5SH' order by fulladdress
W8 5SH - 2,386,000
- Leasehold Purpose built flat
W8 5SH - 1,123,000
- Leasehold Purpose built flat
W8 5SH - 1,897,000
- Leasehold Flat/Maisonette
W8 5SH - 1,442,000
- Leasehold Flat/Maisonette
W8 5SH - 1,925,000
- Leasehold Flat/Maisonette
W8 5SH - 2,487,000
- Leasehold Flat/Maisonette
W8 5SH - 2,740,000
- Leasehold Flat/Maisonette
W8 5SH - 1,349,000
- Leasehold Flat/Maisonette
W8 5SH - 1,733,000
- Leasehold Purpose built flat
W8 5SH - 1,718,000
- Leasehold Flat/Maisonette
W8 5SH - 1,164,000
- Leasehold Flat/Maisonette
W8 5SH - 2,368,000
- Leasehold Flat/Maisonette
W8 5SH - 2,639,000
- Leasehold Flat/Maisonette
W8 5SH - 1,106,000
- Leasehold Flat/Maisonette
W8 5SH - 1,953,000
- Leasehold Flat/Maisonette
W8 5SH - 1,935,000
- Leasehold Flat/Maisonette
W8 5SH - 983,000
- Leasehold Flat/Maisonette
W8 5SH - 2,177,000
- Leasehold Flat/Maisonette
W8 5SH - 2,450,000
- Leasehold Flat/Maisonette
W8 5SH - 1,286,000
- Leasehold Flat/Maisonette
W8 5SH - 1,553,000
- Leasehold Flat/Maisonette
W8 5SH - 1,846,000
- Leasehold Purpose built flat
W8 5SH - 1,153,000
- Leasehold Flat/Maisonette
W8 5SH - 2,454,000
- Leasehold Flat/Maisonette
W8 5SH - 2,438,000
- Leasehold Flat/Maisonette
W8 5SH - 1,977,000
- Leasehold Flat/Maisonette
W8 5SH - 2,057,000
- Leasehold Flat/Maisonette
W8 5SH - 1,180,000
- Leasehold Flat/Maisonette
W8 5SH - 2,620,000
- Leasehold Flat/Maisonette
W8 5SH - 2,519,000
- Leasehold Flat/Maisonette
W8 5SH - 988,000
- Leasehold Flat/Maisonette
W8 5SH - 1,824,000
- Leasehold Flat/Maisonette
W8 5SH - 1,771,000
- Leasehold Flat/Maisonette
W8 5SH - 1,247,000
- Leasehold Flat/Maisonette
W8 5SH - 1,851,000
- Leasehold Flat/Maisonette
W8 5SH - 1,734,000
- Leasehold Flat/Maisonette
W8 5SH - 3,231,000
- Leasehold Flat/Maisonette
W8 5SH - 2,681,000
- Leasehold Flat/Maisonette
W8 5SH - 3,031,000
- Leasehold Flat/Maisonette
W8 5SH - 3,016,000
- Leasehold Flat/Maisonette
W8 5SH - 2,897,000
- Leasehold Flat/Maisonette
W8 5SH - 1,837,000
- Leasehold Flat/Maisonette