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 2NW' order by fulladdress
W4 2NW - 2,742,000
- Freehold Semi-detached house
W4 2NW - 2,771,000
- Freehold Semi-detached house
W4 2NW - 2,980,000
- Freehold Semi-detached house
W4 2NW - 3,301,000
- Freehold Semi-detached house
W4 2NW - 2,635,000
- Freehold Semi-detached house
W4 2NW - 2,748,000
- Freehold Semi-detached house
W4 2NW - 2,793,000
- Freehold Semi-detached house
W4 2NW - 2,819,000
- Freehold Semi-detached house
W4 2NW - 2,620,000
- Freehold Semi-detached house
W4 2NW - 2,609,000
- Semi-detached house
W4 2NW - 2,601,000
- Freehold Semi-detached house
W4 2NW - 2,982,000
- Freehold Semi-detached house
W4 2NW - 3,007,000
- Freehold Semi-detached house
W4 2NW - 2,562,000
- Freehold Semi-detached property
W4 2NW - 3,031,000
- Freehold Semi-detached house
W4 2NW - 2,969,000
- Freehold Semi-detached house
W4 2NW - 2,857,000
- Freehold Semi-detached house
W4 2NW - 3,198,000
- Freehold Semi-detached house
W4 2NW - 2,974,000
- Freehold Semi-detached house
W4 2NW - 2,569,000
- Freehold Semi-detached house
W4 2NW - 2,301,000
- Freehold Semi-detached house
W4 2NW - 2,923,000
- Freehold Semi-detached house
W4 2NW - 2,616,000
- Freehold End terrace house
W4 2NW - 2,797,000
- Freehold Semi-detached house
W4 2NW - 3,017,000
- Freehold Semi-detached house
W4 2NW - 2,949,000
- Freehold Semi-detached house
W4 2NW - 2,617,000
- Freehold Semi-detached house
W4 2NW - 2,725,000
- Freehold Semi-detached property
W4 2NW - 2,830,000
- Freehold Detached house
W4 2NW - 3,051,000
- Freehold Semi-detached house
W4 2NW - 3,050,000
- Freehold Semi-detached house
W4 2NW - 2,679,000
- Freehold Semi-detached house
W4 2NW - 2,725,000
- Freehold Semi-detached house
W4 2NW - 2,523,000
- Freehold Mid terrace house
W4 2NW - 2,652,000
- Freehold Semi-detached house
W4 2NW - 2,861,000
- Freehold Semi-detached property
W4 2NW - 2,859,000
- Semi-detached property
W4 2NW - 2,905,000
- Freehold Semi-detached house
W4 2NW - 2,984,000
- Freehold Semi-detached house