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 1TZ' order by fulladdress
W4 1TZ - 4,324,000
- Freehold Semi-detached house
W4 1TZ - 3,591,000
- Detached property
W4 1TZ - 4,027,000
- Freehold Semi-detached house
W4 1TZ - 3,508,000
- Freehold Semi-detached house
W4 1TZ - 1,105,000
- Leasehold Flat/Maisonette
W4 1TZ - 4,030,000
- Freehold Semi-detached house
W4 1TZ - 3,859,000
- Freehold Detached house
W4 1TZ - 5,056,000
- Freehold Semi-detached property
W4 1TZ - 4,257,000
- Freehold Semi-detached property
W4 1TZ - 4,235,000
- Freehold Semi-detached house
W4 1TZ - 4,205,000
- Freehold Semi-detached house
W4 1TZ - 3,912,000
- Freehold Detached property
W4 1TZ - 4,254,000
- Freehold Semi-detached property
W4 1TZ - 5,193,000
- Freehold Detached property
W4 1TZ - 6,355,000
- Freehold Detached property
