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 1JT' order by fulladdress
W4 1JT - 667,000
- Leasehold Flat/Maisonette
W4 1JT - 568,000
- Leasehold Purpose built flat
W4 1JT - 612,000
- Leasehold Flat/Maisonette
W4 1JT - 712,000
- Leasehold Converted flat
W4 1JT - 729,000
- Leasehold Purpose built flat
W4 1JT - 620,000
- Leasehold Flat/Maisonette
W4 1JT - 734,000
- Leasehold Purpose built flat
W4 1JT - 759,000
- Leasehold Purpose built flat
W4 1JT - 635,000
- Leasehold Flat/Maisonette
W4 1JT - 702,000
- Leasehold Flat/Maisonette
W4 1JT - 722,000
- Leasehold Purpose built flat
W4 1JT - 715,000
- Freehold Flat/Maisonette
W4 1JT - 637,000
- Leasehold Flat/Maisonette
W4 1JT - 703,000
- Leasehold Purpose built flat
W4 1JT - 722,000
- Leasehold Purpose built flat
W4 1JT - 666,000
- Leasehold Flat/Maisonette
W4 1JT - 623,000
- Leasehold Flat/Maisonette
W4 1JT - 679,000
- Purpose built flat
W4 1JT - 574,000
- Leasehold Flat/Maisonette
W4 1JT - 693,000
- Leasehold Converted flat
W4 1JT - 764,000
- Leasehold Flat/Maisonette
W4 1JT - 758,000
- Leasehold Purpose built flat
W4 1JT - 658,000
- Leasehold Purpose built flat
W4 1JT - 751,000
- Leasehold Purpose built flat
W4 1JT - 752,000
- Leasehold Flat/Maisonette
W4 1JT - 634,000
- Leasehold Purpose built flat
W4 1JT - 622,000
- Leasehold Purpose built flat
W4 1JT - 569,000
- Leasehold Flat/Maisonette
W4 1JT - 608,000
- Leasehold Converted flat
W4 1JT - 752,000
- Leasehold Purpose built flat
W4 1JT - 686,000
- Leasehold Purpose built flat
W4 1JT - 614,000
- Leasehold Purpose built flat
W4 1JT - 667,000
- Leasehold Flat/Maisonette
W4 1JT - 790,000
- Leasehold Flat/Maisonette
W4 1JT - 593,000
- Leasehold Purpose built flat
W4 1JT - 770,000
- Leasehold Purpose built flat
W4 1JT - 595,000
- Feudal Purpose built flat