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 2DF' order by fulladdress
W4 2DF - 1,259,000
- Freehold Mid terrace house
W4 2DF - 1,245,000
- Freehold Mid terrace house
W4 2DF - 1,429,000
- Mid terrace house
W4 2DF - 1,392,000
- Freehold Mid terrace house
W4 2DF - 1,701,000
- Freehold Mid terrace house
W4 2DF - 1,392,000
- Freehold Mid terrace house
W4 2DF - 1,396,000
- Freehold Terraced
W4 2DF - 1,447,000
- Freehold Mid terrace house
W4 2DF - 1,331,000
- Freehold Terrace property
W4 2DF - 1,379,000
- Freehold Terraced
W4 2DF - 1,360,000
- Freehold Terrace property
W4 2DF - 1,427,000
- Freehold Terraced
W4 2DF - 1,494,000
- Freehold Mid terrace house
W4 2DF - 1,447,000
- Freehold Mid terrace house
W4 2DF - 1,508,000
- Freehold Mid terrace house
W4 2DF - 1,214,000
- Freehold Mid terrace house
W4 2DF - 1,455,000
- Freehold Mid terrace house
W4 2DF - 1,529,000
- Freehold Mid terrace house
W4 2DF - 1,526,000
- Leasehold Mid terrace house
W4 2DF - 810,000
- Freehold Flat/Maisonette
W4 2DF - 1,472,000
- Freehold Mid terrace house
W4 2DF - 1,496,000
- Leasehold Terraced
W4 2DF - 1,574,000
- Leasehold Mid terrace house
W4 2DF - 1,567,000
- Freehold Terrace property
W4 2DF - 1,590,000
- Freehold Mid terrace house
W4 2DF - 1,369,000
- Leasehold Mid terrace house
W4 2DF - 1,466,000
- Leasehold Detached house
W4 2DF - 1,565,000
- Leasehold Detached house
W4 2DF - 1,403,000
- Freehold Terraced
W4 2DF - 1,268,000
- Freehold Mid terrace house
W4 2DF - 1,314,000
- Freehold Terrace property
