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 5UN' order by fulladdress
W8 5UN - 2,189,000
- Leasehold Flat/Maisonette
W8 5UN - 2,597,000
- Leasehold Flat/Maisonette
W8 5UN - 2,115,000
- Leasehold Flat/Maisonette
W8 5UN - 2,643,000
- Leasehold Flat/Maisonette
W8 5UN - 2,858,000
- Leasehold Flat/Maisonette
W8 5UN - 2,766,000
- Leasehold Flat/Maisonette
W8 5UN - 1,192,000
- Leasehold Flat/Maisonette
W8 5UN - 1,407,000
- Leasehold Flat/Maisonette
W8 5UN - 1,209,000
- Leasehold Flat/Maisonette
W8 5UN - 1,444,000
- Leasehold Flat/Maisonette
W8 5UN - 2,339,000
- Leasehold Flat/Maisonette
W8 5UN - 2,422,000
- Leasehold Flat/Maisonette
W8 5UN - 1,580,000
- Leasehold Flat/Maisonette
W8 5UN - 2,037,000
- Leasehold Flat/Maisonette
W8 5UN - 2,386,000
- Leasehold Purpose built flat
W8 5UN - 2,681,000
- Leasehold Flat/Maisonette
W8 5UN - 2,220,000
- Flat/Maisonette
W8 5UN - 2,173,000
- Leasehold Flat/Maisonette
W8 5UN - 1,448,000
- Leasehold Flat/Maisonette
W8 5UN - 1,452,000
- Leasehold Flat/Maisonette
W8 5UN - 1,425,000
- Leasehold Flat/Maisonette
W8 5UN - 2,401,000
- Leasehold Flat/Maisonette
W8 5UN - 2,234,000
- Leasehold Flat/Maisonette
W8 5UN - 1,956,000
- Leasehold Flat/Maisonette
W8 5UN - 2,472,000
- Leasehold Purpose built flat
W8 5UN - 2,635,000
- Leasehold Flat/Maisonette
W8 5UN - 2,416,000
- Leasehold Flat/Maisonette
W8 5UN - 1,380,000
- Leasehold Flat/Maisonette
W8 5UN - 2,413,000
- Leasehold Flat/Maisonette
W8 5UN - 2,664,000
- Flat/Maisonette
W8 5UN - 2,558,000
- Leasehold Flat/Maisonette
W8 5UN - 2,806,000
- Leasehold Flat/Maisonette
W8 5UN - 2,023,000
- Flat/Maisonette