SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W8 6LP' order by fulladdress
W8 6LP - 19,457,000
- Freehold Terraced
W8 6LP - 13,861,000
- Freehold Mid terrace house
W8 6LP - 17,699,000
- Freehold Detached house
W8 6LP - 15,911,000
- Freehold Terraced
W8 6LP - 14,456,000
- Freehold Terrace property
W8 6LP - 14,914,000
- Freehold Terrace property
W8 6LP - 14,053,000
- Freehold Mid terrace house
W8 6LP - 14,584,000
- Freehold Flat/Maisonette
W8 6LP - 14,730,000
- Freehold Mid terrace house
W8 6LP - 13,777,000
- Freehold Terrace property
W8 6LP - 10,834,000
- Freehold Mid terrace house
W8 6LP - 15,670,000
- Freehold Terraced
W8 6LP - 15,432,000
- Freehold Terrace property
W8 6LP - 14,521,000
- Freehold Terrace property
W8 6LP - 14,348,000
- Terrace property
W8 6LP - 12,968,000
- Freehold Mid terrace house
W8 6LP - 14,338,000
- Mid terrace house
W8 6LP - 14,417,000
- Freehold Mid terrace house
W8 6LP - 16,313,000
- Freehold Mid terrace house
W8 6LP - 1,249,000
- Leasehold Flat/Maisonette
W8 6LP - 945,000
- Leasehold Flat/Maisonette
W8 6LP - 1,180,000
- Leasehold Flat/Maisonette
W8 6LP - 1,236,000
- Leasehold Flat/Maisonette
W8 6LP - 884,000
- Leasehold Converted flat
W8 6LP - 847,000
- Leasehold Flat/Maisonette
W8 6LP - 880,000
- Leasehold Flat/Maisonette
W8 6LP - 1,045,000
- Leasehold Converted flat
W8 6LP - 1,028,000
- Leasehold Flat/Maisonette
