SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W5 4EP' order by fulladdress
W5 4EP - 434,000
- Leasehold Purpose built flat
W5 4EP - 458,000
- Leasehold Purpose built flat
W5 4EP - 956,000
- Freehold Terraced
W5 4EP - 1,010,000
- Freehold Mid terrace house
W5 4EP - 1,013,000
- Freehold Mid terrace house
W5 4EP - 1,051,000
- Freehold Mid terrace house
W5 4EP - 458,000
- Leasehold Flat/Maisonette
W5 4EP - 1,038,000
- Freehold Mid terrace house
W5 4EP - 0
- Leasehold Flat/Maisonette
W5 4EP - 436,000
- Leasehold Flat/Maisonette
W5 4EP - 905,000
- Freehold End terrace house
W5 4EP - 1,012,000
- Freehold Mid terrace house
W5 4EP - 432,000
- Leasehold Purpose built flat
W5 4EP - 931,000
- Freehold Mid terrace house
W5 4EP - 983,000
- Freehold Mid terrace house
W5 4EP - 1,100,000
- Freehold Mid terrace house
W5 4EP - 1,012,000
- Freehold End terrace house
W5 4EP - 435,000
- Leasehold Flat/Maisonette
W5 4EP - 995,000
- Freehold Terrace property
W5 4EP - 1,079,000
- Freehold Mid terrace house
W5 4EP - 905,000
- Freehold Mid terrace house
W5 4EP - 886,000
- Freehold Terrace property
W5 4EP - 958,000
- Freehold End terrace house
W5 4EP - 954,000
- Freehold End terrace house
W5 4EP - 1,063,000
- Freehold Mid terrace house
W5 4EP - 1,129,000
- Freehold Mid terrace house
W5 4EP - 1,044,000
- Freehold Terrace property
W5 4EP - 938,000
- Leasehold Terraced
W5 4EP - 1,063,000
- Freehold Mid terrace house
W5 4EP - 825,000
- Freehold Mid terrace house
W5 4EP - 960,000
- Freehold End terrace house
W5 4EP - 823,000
- Leasehold Converted flat
W5 4EP - 464,000
- Freehold Converted flat
W5 4EP - 961,000
- Freehold End terrace house
W5 4EP - 418,000
- Leasehold Flat/Maisonette
W5 4EP - 492,000
- Leasehold Converted flat
W5 4EP - 469,000
- Leasehold Purpose built flat
W5 4EP - 815,000
- Freehold End terrace house
W5 4EP - 1,001,000
- Freehold Terraced
W5 4EP - 939,000
- Freehold Terraced
W5 4EP - 927,000
- Freehold Mid terrace house
W5 4EP - 917,000
- Freehold Mid terrace house
W5 4EP - 846,000
- Freehold End terrace house
W5 4EP - 415,000
- Leasehold Flat/Maisonette