SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W9 2JE' order by fulladdress
W9 2JE - 1,287,000
- Freehold Mid terrace house
W9 2JE - 2,056,000
- Freehold Mid terrace house
W9 2JE - 1,780,000
- Freehold Terraced
W9 2JE - 1,758,000
- Freehold Terrace property
W9 2JE - 1,823,000
- Freehold Mid terrace house
W9 2JE - 2,131,000
- Freehold Mid terrace house
W9 2JE - 1,850,000
- Freehold Mid terrace house
W9 2JE - 2,277,000
- Freehold Mid terrace house
W9 2JE - 2,085,000
- Freehold Terraced
W9 2JE - 2,253,000
- Freehold Mid terrace house
W9 2JE - 2,014,000
- Freehold Mid terrace house
W9 2JE - 1,688,000
- Freehold End terrace house
W9 2JE - 2,170,000
- Freehold Mid terrace house
W9 2JE - 1,718,000
- Freehold Mid terrace house
W9 2JE - 2,123,000
- Freehold Mid terrace house
W9 2JE - 1,936,000
- Freehold Mid terrace house
W9 2JE - 1,408,000
- Freehold Mid terrace house
W9 2JE - 1,985,000
- Freehold Mid terrace house
W9 2JE - 1,945,000
- Freehold Terraced
W9 2JE - 1,912,000
- Freehold Terraced
W9 2JE - 1,888,000
- Freehold Terraced
W9 2JE - 1,944,000
- Freehold Terrace property
W9 2JE - 1,439,000
- Freehold Terrace property
W9 2JE - 1,773,000
- Freehold Mid terrace house
W9 2JE - 1,552,000
- Freehold Terrace property
W9 2JE - 1,680,000
- Freehold Mid terrace house
W9 2JE - 2,320,000
- Freehold Mid terrace house
W9 2JE - 1,921,000
- Freehold Terraced
W9 2JE - 1,899,000
- Freehold Mid terrace house
W9 2JE - 1,698,000
- Freehold Terrace property
W9 2JE - 1,757,000
- Freehold Mid terrace house
W9 2JE - 1,561,000
- Freehold Terrace property
W9 2JE - 2,098,000
- Freehold Mid terrace house
W9 2JE - 2,014,000
- Freehold Terraced
W9 2JE - 1,780,000
- Freehold End terrace house
W9 2JE - 1,913,000
- Freehold Mid terrace house
W9 2JE - 1,908,000
- Freehold Terrace property
W9 2JE - 1,764,000
- Freehold Terrace property
W9 2JE - 2,033,000
- Freehold Terrace property
W9 2JE - 2,265,000
- Freehold Mid terrace house
W9 2JE - 2,123,000
- Freehold Mid terrace house
W9 2JE - 1,831,000
- Freehold Terraced
W9 2JE - 1,976,000
- Freehold Mid terrace house
W9 2JE - 1,600,000
- Freehold Mid terrace house
W9 2JE - 1,992,000
- Freehold Terraced
W9 2JE - 1,839,000
- Freehold Mid terrace house
W9 2JE - 1,735,000
- Freehold Mid terrace house