SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W7 2JW' order by fulladdress
W7 2JW - 436,000
- Leasehold Purpose built flat
W7 2JW - 439,000
- Leasehold Purpose built flat
W7 2JW - 654,000
- Leasehold Purpose built flat
W7 2JW - 495,000
- Leasehold Purpose built flat
W7 2JW - 445,000
- Leasehold Purpose built flat
W7 2JW - 451,000
- Leasehold Converted flat
W7 2JW - 491,000
- Leasehold Purpose built flat
W7 2JW - 444,000
- Leasehold Converted flat
W7 2JW - 923,000
- Freehold Mid terrace house
W7 2JW - 834,000
- Freehold Mid terrace house
W7 2JW - 933,000
- Freehold Mid terrace house
W7 2JW - 931,000
- Freehold End terrace house
W7 2JW - 939,000
- Freehold Mid terrace house
W7 2JW - 840,000
- Freehold Mid terrace house
W7 2JW - 949,000
- Freehold Mid terrace house
W7 2JW - 932,000
- Freehold Mid terrace house
W7 2JW - 484,000
- Leasehold Purpose built flat
W7 2JW - 885,000
- Freehold Mid terrace house
W7 2JW - 981,000
- Freehold Mid terrace house
W7 2JW - 914,000
- Freehold Mid terrace house
W7 2JW - 874,000
- Freehold Mid terrace house
W7 2JW - 851,000
- Freehold Mid terrace house
W7 2JW - 927,000
- Freehold Mid terrace house
W7 2JW - 840,000
- Freehold Mid terrace house
W7 2JW - 829,000
- Freehold Mid terrace house
W7 2JW - 913,000
- Freehold Terrace property
W7 2JW - 820,000
- Freehold Mid terrace house
W7 2JW - 865,000
- Freehold Terrace property
W7 2JW - 925,000
- Freehold End terrace house
W7 2JW - 949,000
- Freehold Terraced
W7 2JW - 864,000
- Freehold Mid terrace house
