SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W12 9DE' order by fulladdress
W12 9DE - 846,000
- Leasehold Purpose built flat
W12 9DE - 831,000
- Leasehold Flat/Maisonette
W12 9DE - 860,000
- Leasehold Purpose built flat
W12 9DE - 859,000
- Leasehold Purpose built flat
W12 9DE - 856,000
- Leasehold Purpose built flat
W12 9DE - 347,000
- Leasehold Purpose built flat
W12 9DE - 934,000
- Leasehold Purpose built flat
W12 9DE - 439,000
- Leasehold Flat/Maisonette
W12 9DE - 543,000
- Leasehold Flat/Maisonette
W12 9DE - 691,000
- Leasehold Flat/Maisonette
W12 9DE - 368,000
- Leasehold Purpose built flat
W12 9DE - 378,000
- Leasehold Purpose built flat
W12 9DE - 701,000
- Leasehold Flat/Maisonette
W12 9DE - 433,000
- Leasehold Flat/Maisonette
W12 9DE - 431,000
- Leasehold Purpose built flat
W12 9DE - 649,000
- Leasehold Flat/Maisonette
W12 9DE - 482,000
- Leasehold Flat/Maisonette
W12 9DE - 657,000
- Leasehold Flat/Maisonette
W12 9DE - 893,000
- Leasehold Flat/Maisonette
W12 9DE - 911,000
- Feudal Purpose built flat
W12 9DE - 826,000
- Leasehold Purpose built flat
W12 9DE - 859,000
- Leasehold Purpose built flat
W12 9DE - 378,000
- Leasehold Purpose built flat
W12 9DE - 661,000
- Leasehold Flat/Maisonette
W12 9DE - 420,000
- Leasehold Flat/Maisonette
W12 9DE - 470,000
- Leasehold Flat/Maisonette
W12 9DE - 700,000
- Leasehold Flat/Maisonette
W12 9DE - 356,000
- Leasehold Flat/Maisonette
W12 9DE - 621,000
- Leasehold Flat/Maisonette
W12 9DE - 764,000
- Leasehold Flat/Maisonette
W12 9DE - 926,000
- Leasehold Flat/Maisonette
W12 9DE - 774,000
- Leasehold Flat/Maisonette
W12 9DE - 655,000
- Leasehold Flat/Maisonette
W12 9DE - 352,000
- Leasehold Flat/Maisonette
W12 9DE - 659,000
- Leasehold Purpose built flat
W12 9DE - 582,000
- Leasehold Purpose built flat
W12 9DE - 797,000
- Leasehold Flat/Maisonette
W12 9DE - 807,000
- Leasehold Flat/Maisonette
W12 9DE - 695,000
- Leasehold Flat/Maisonette