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 7LB' order by fulladdress
W6 7LB - 759,000
- Leasehold Flat/Maisonette
W6 7LB - 646,000
- Leasehold Flat/Maisonette
W6 7LB - 749,000
- Leasehold Flat/Maisonette
W6 7LB - 741,000
- Freehold Flat/Maisonette
W6 7LB - 823,000
- Leasehold Flat/Maisonette
W6 7LB - 920,000
- Leasehold Purpose built flat
W6 7LB - 817,000
- Leasehold Flat/Maisonette
W6 7LB - 818,000
- Leasehold Purpose built flat
W6 7LB - 803,000
- Leasehold Flat/Maisonette
W6 7LB - 976,000
- Leasehold Flat/Maisonette
W6 7LB - 774,000
- Leasehold Flat/Maisonette
W6 7LB - 813,000
- Leasehold Flat/Maisonette
W6 7LB - 748,000
- Leasehold Purpose built flat
W6 7LB - 453,000
- Leasehold Purpose built flat
W6 7LB - 434,000
- Leasehold Flat/Maisonette
W6 7LB - 432,000
- Leasehold Flat/Maisonette
W6 7LB - 438,000
- Leasehold Purpose built flat
W6 7LB - 646,000
- Leasehold Purpose built flat
W6 7LB - 494,000
- Leasehold Purpose built flat
W6 7LB - 421,000
- Leasehold Flat/Maisonette
W6 7LB - 455,000
- Leasehold Purpose built flat
W6 7LB - 510,000
- Leasehold Flat/Maisonette
W6 7LB - 544,000
- Leasehold Flat/Maisonette
W6 7LB - 432,000
- Leasehold Flat/Maisonette
W6 7LB - 441,000
- Feudal Purpose built flat
W6 7LB - 549,000
- Leasehold Purpose built flat
W6 7LB - 553,000
- Leasehold Purpose built flat
W6 7LB - 426,000
- Leasehold Flat/Maisonette
W6 7LB - 507,000
- Leasehold Flat/Maisonette
W6 7LB - 553,000
- Leasehold Flat/Maisonette
W6 7LB - 448,000
- Leasehold Purpose built flat
