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 1AG' order by fulladdress
W4 1AG - 669,000
- Leasehold Purpose built flat
W4 1AG - 590,000
- Leasehold Converted flat
W4 1AG - 593,000
- Leasehold Converted flat
W4 1AG - 655,000
- Leasehold Purpose built flat
W4 1AG - 680,000
- Leasehold Purpose built flat
W4 1AG - 601,000
- Leasehold Purpose built flat
W4 1AG - 584,000
- Leasehold Purpose built flat
W4 1AG - 684,000
- Leasehold Purpose built flat
W4 1AG - 625,000
- Leasehold Converted flat
W4 1AG - 593,000
- Leasehold Purpose built flat
W4 1AG - 694,000
- Leasehold Purpose built flat
W4 1AG - 519,000
- Leasehold Flat/Maisonette
W4 1AG - 507,000
- Leasehold Flat/Maisonette
W4 1AG - 469,000
- Leasehold Flat/Maisonette
W4 1AG - 485,000
- Leasehold Flat/Maisonette
W4 1AG - 348,000
- Leasehold Purpose built flat
W4 1AG - 377,000
- Leasehold Purpose built flat
W4 1AG - 363,000
- Leasehold Flat/Maisonette
W4 1AG - 387,000
- Leasehold Flat/Maisonette
W4 1AG - 487,000
- Leasehold Purpose built flat
W4 1AG - 498,000
- Leasehold Flat/Maisonette
W4 1AG - 598,000
- Leasehold Flat/Maisonette
W4 1AG - 516,000
- Leasehold Flat/Maisonette
W4 1AG - 678,000
- Freehold Purpose built flat
W4 1AG - 680,000
- Feudal Purpose built flat
W4 1AG - 695,000
- Leasehold Purpose built flat
W4 1AG - 548,000
- Leasehold Flat/Maisonette
W4 1AG - 559,000
- Leasehold Purpose built flat
W4 1AG - 706,000
- Feudal Purpose built flat
W4 1AG - 675,000
- Leasehold Purpose built flat
W4 1AG - 603,000
- Leasehold Purpose built flat
W4 1AG - 820,000
- Leasehold Purpose built flat
