SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W4 3JF' order by fulladdress
W4 3JF - 908,000
- Leasehold Purpose built flat
W4 3JF - 754,000
- Leasehold Purpose built flat
W4 3JF - 631,000
- Leasehold Purpose built flat
W4 3JF - 642,000
- Leasehold Purpose built flat
W4 3JF - 538,000
- Leasehold Flat/Maisonette
W4 3JF - 677,000
- Leasehold Flat/Maisonette
W4 3JF - 529,000
- Feudal Purpose built flat
W4 3JF - 673,000
- Leasehold Flat/Maisonette
W4 3JF - 502,000
- Leasehold Purpose built flat
W4 3JF - 499,000
- Leasehold Flat/Maisonette
W4 3JF - 683,000
- Leasehold Flat/Maisonette
W4 3JF - 530,000
- Leasehold Purpose built flat
W4 3JF - 831,000
- Leasehold Flat/Maisonette
W4 3JF - 819,000
- Leasehold Purpose built flat
W4 3JF - 534,000
- Leasehold Purpose built flat
W4 3JF - 649,000
- Leasehold Flat/Maisonette
W4 3JF - 524,000
- Leasehold Flat/Maisonette
W4 3JF - 775,000
- Leasehold Flat/Maisonette
W4 3JF - 502,000
- Leasehold Purpose built flat
W4 3JF - 474,000
- Leasehold Flat/Maisonette
W4 3JF - 587,000
- Leasehold Flat/Maisonette
W4 3JF - 489,000
- Leasehold Purpose built flat
W4 3JF - 571,000
- Leasehold Flat/Maisonette
W4 3JF - 484,000
- Leasehold Flat/Maisonette
W4 3JF - 486,000
- Leasehold Flat/Maisonette
W4 3JF - 472,000
- Leasehold Purpose built flat
W4 3JF - 986,000
- Leasehold Flat/Maisonette
W4 3JF - 473,000
- Leasehold Purpose built flat
W4 3JF - 1,170,000
- Leasehold Flat/Maisonette
W4 3JF - 501,000
- Leasehold Flat/Maisonette
W4 3JF - 956,000
- Leasehold Purpose built flat
W4 3JF - 526,000
- Leasehold Flat/Maisonette