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 3HP' order by fulladdress
W4 3HP - 2,065,000
- Freehold Semi-detached house
W4 3HP - 1,867,000
- Freehold Semi-detached house
W4 3HP - 1,539,000
- Freehold Semi-detached house
W4 3HP - 1,608,000
- Freehold Semi-detached house
W4 3HP - 1,557,000
- Freehold Semi-detached house
W4 3HP - 1,597,000
- Freehold Semi-detached house
W4 3HP - 1,346,000
- Freehold Semi-detached house
W4 3HP - 1,631,000
- Freehold Semi-detached house
W4 3HP - 2,197,000
- Freehold Semi-detached house
W4 3HP - 1,985,000
- Freehold Semi-detached property
W4 3HP - 2,504,000
- Freehold Detached house
W4 3HP - 2,318,000
- Freehold Semi-detached house
W4 3HP - 2,409,000
- Freehold Semi-detached house
W4 3HP - 2,302,000
- Freehold Semi-detached house
W4 3HP - 2,534,000
- Freehold Semi-detached house
W4 3HP - 2,419,000
- Freehold Semi-detached house
W4 3HP - 1,922,000
- Freehold Semi-detached house
W4 3HP - 1,341,000
- Detached bungalow
W4 3HP - 1,489,000
- Freehold Detached house
W4 3HP - 1,676,000
- Freehold Detached house
