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 5AL' order by fulladdress
W4 5AL - 1,090,000
- Freehold Terrace property
W4 5AL - 518,000
- Leasehold Converted flat
W4 5AL - 471,000
- Freehold Flat/Maisonette
W4 5AL - 544,000
- Leasehold Converted flat
W4 5AL - 560,000
- Leasehold Purpose built flat
W4 5AL - 561,000
- Leasehold Flat/Maisonette
W4 5AL - 1,210,000
- Freehold Mid terrace house
W4 5AL - 577,000
- Leasehold Converted flat
W4 5AL - 1,234,000
- Freehold Mid terrace house
W4 5AL - 634,000
- Leasehold Converted flat
W4 5AL - 609,000
- Leasehold Flat/Maisonette
W4 5AL - 719,000
- Leasehold Flat/Maisonette
W4 5AL - 934,000
- Freehold Mid terrace house
W4 5AL - 967,000
- Freehold Mid terrace house
W4 5AL - 956,000
- Freehold Terraced
W4 5AL - 946,000
- Freehold Mid terrace house
W4 5AL - 1,086,000
- Freehold Mid terrace house
W4 5AL - 956,000
- Freehold End terrace house
W4 5AL - 1,401,000
- Freehold End terrace house
W4 5AL - 1,692,000
- Freehold Mid terrace house
W4 5AL - 510,000
- Leasehold Purpose built flat
W4 5AL - 623,000
- Leasehold Converted flat
W4 5AL - 618,000
- Leasehold Converted flat
W4 5AL - 575,000
- Leasehold Converted flat
W4 5AL - 1,261,000
- Freehold Mid terrace house
W4 5AL - 1,589,000
- Freehold Mid terrace house
W4 5AL - 1,409,000
- Freehold Mid terrace house
W4 5AL - 1,389,000
- Freehold Mid terrace house
W4 5AL - 1,490,000
- Freehold Semi-detached property
W4 5AL - 1,581,000
- Freehold End terrace house
W4 5AL - 835,000
- Freehold Mid terrace house
W4 5AL - 555,000
- Leasehold Flat/Maisonette
W4 5AL - 759,000
- Leasehold Purpose built flat
W4 5AL - 765,000
- Leasehold Purpose built flat
W4 5AL - 751,000
- Leasehold Purpose built flat
W4 5AL - 671,000
- Leasehold Purpose built flat
W4 5AL - 608,000
- Leasehold Purpose built flat
W4 5AL - 552,000
- Leasehold Flat/Maisonette
W4 5AL - 560,000
- Leasehold Flat/Maisonette
