SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW1 1PZ' order by fulladdress
TW1 1PZ - 3,128,000
- Freehold Semi-detached house
TW1 1PZ - 3,925,000
- Freehold Semi-detached house
TW1 1PZ - 3,400,000
- Freehold Semi-detached house
TW1 1PZ - 3,191,000
- Semi-detached house
TW1 1PZ - 4,359,000
- Freehold Detached house
TW1 1PZ - 3,686,000
- Freehold Semi-detached house
TW1 1PZ - 3,606,000
- Freehold Semi-detached house
TW1 1PZ - 3,717,000
- Freehold Semi-detached property
TW1 1PZ - 3,936,000
- Freehold Semi-detached house
TW1 1PZ - 4,560,000
- Freehold Semi-detached property
TW1 1PZ - 3,774,000
- Freehold Semi-detached house
TW1 1PZ - 2,744,000
- Freehold Mid terrace house
TW1 1PZ - 3,798,000
- Freehold Semi-detached house
TW1 1PZ - 3,465,000
- Freehold Semi-detached house
TW1 1PZ - 3,812,000
- Freehold Semi-detached property
TW1 1PZ - 2,656,000
- Freehold End terrace house
TW1 1PZ - 3,198,000
- Freehold Semi-detached house
TW1 1PZ - 3,583,000
- Freehold Semi-detached house
TW1 1PZ - 4,036,000
- Freehold Semi-detached property
TW1 1PZ - 3,255,000
- Freehold Semi-detached house
TW1 1PZ - 3,881,000
- Freehold Detached house
TW1 1PZ - 3,436,000
- Freehold Semi-detached house
