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 6AX' order by fulladdress
W8 6AX - 4,072,000
- Leasehold Flat/Maisonette
W8 6AX - 1,453,000
- Leasehold Flat/Maisonette
W8 6AX - 3,372,000
- Leasehold Flat/Maisonette
W8 6AX - 4,577,000
- Leasehold Flat/Maisonette
W8 6AX - 3,476,000
- Leasehold Flat/Maisonette
W8 6AX - 1,479,000
- Leasehold Flat/Maisonette
W8 6AX - 3,482,000
- Leasehold Flat/Maisonette
W8 6AX - 4,425,000
- Leasehold Flat/Maisonette
W8 6AX - 3,517,000
- Leasehold Flat/Maisonette
W8 6AX - 2,506,000
- Leasehold Flat/Maisonette
W8 6AX - 4,995,000
- Leasehold Flat/Maisonette
W8 6AX - 4,060,000
- Leasehold Flat/Maisonette
W8 6AX - 4,623,000
- Leasehold Flat/Maisonette
W8 6AX - 5,721,000
- Leasehold Flat/Maisonette
W8 6AX - 4,485,000
- Leasehold Flat/Maisonette
W8 6AX - 3,891,000
- Flat/Maisonette
W8 6AX - 4,441,000
- Leasehold Flat/Maisonette
W8 6AX - 3,295,000
- Leasehold Flat/Maisonette
W8 6AX - 3,813,000
- Leasehold Flat/Maisonette
W8 6AX - 3,550,000
- Leasehold Flat/Maisonette
W8 6AX - 3,346,000
- Leasehold Flat/Maisonette
W8 6AX - 3,940,000
- Leasehold Flat/Maisonette
W8 6AX - 3,891,000
- Flat/Maisonette
W8 6AX - 5,649,000
- Leasehold Flat/Maisonette
W8 6AX - 5,939,000
- Leasehold Flat/Maisonette
W8 6AX - 5,877,000
- Leasehold Flat/Maisonette
W8 6AX - 5,682,000
- Leasehold Flat/Maisonette
W8 6AX - 5,681,000
- Leasehold Flat/Maisonette
W8 6AX - 5,811,000
- Leasehold Flat/Maisonette
W8 6AX - 6,452,000
- Leasehold Flat/Maisonette
W8 6AX - 5,419,000
- Leasehold Flat/Maisonette
W8 6AX - 5,647,000
- Leasehold Flat/Maisonette
W8 6AX - 5,940,000
- Leasehold Flat/Maisonette
W8 6AX - 5,630,000
- Leasehold Flat/Maisonette
W8 6AX - 5,712,000
- Leasehold Flat/Maisonette
W8 6AX - 5,636,000
- Leasehold Flat/Maisonette
W8 6AX - 5,616,000
- Leasehold Flat/Maisonette
W8 6AX - 5,419,000
- Flat/Maisonette
W8 6AX - 2,557,000
- Leasehold Flat/Maisonette
W8 6AX - 5,484,000
- Leasehold Flat/Maisonette
W8 6AX - 5,578,000
- Leasehold Flat/Maisonette
W8 6AX - 5,394,000
- Leasehold Flat/Maisonette
W8 6AX - 5,523,000
- Leasehold Flat/Maisonette
W8 6AX - 5,330,000
- Leasehold Flat/Maisonette
W8 6AX - 1,487,000
- Leasehold Flat/Maisonette
W8 6AX - 4,785,000
- Leasehold Flat/Maisonette
W8 6AX - 5,165,000
- Leasehold Flat/Maisonette
W8 6AX - 5,104,000
- Leasehold Flat/Maisonette
W8 6AX - 5,290,000
- Flat/Maisonette
W8 6AX - 3,916,000
- Leasehold Flat/Maisonette
W8 6AX - 2,611,000
- Leasehold Flat/Maisonette
W8 6AX - 4,078,000
- Leasehold Flat/Maisonette