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 2LY' order by fulladdress
TW1 2LY - 2,083,000
- Freehold Detached house
TW1 2LY - 2,415,000
- Freehold Semi-detached house
TW1 2LY - 1,856,000
- End terrace house
TW1 2LY - 2,395,000
- Freehold Semi-detached property
TW1 2LY - 2,498,000
- Freehold Semi-detached house
TW1 2LY - 1,553,000
- Leasehold Semi-detached house
TW1 2LY - 2,153,000
- Freehold Semi-detached house
TW1 2LY - 2,329,000
- Freehold Semi-detached house
TW1 2LY - 2,274,000
- Freehold Semi-detached house
TW1 2LY - 2,422,000
- Freehold Semi-detached house
TW1 2LY - 2,194,000
- Freehold Detached house
TW1 2LY - 2,293,000
- Freehold Semi-detached house
TW1 2LY - 2,515,000
- Freehold Semi-detached house
TW1 2LY - 2,182,000
- Freehold Semi-detached house
TW1 2LY - 2,225,000
- Freehold Semi-detached house
TW1 2LY - 2,387,000
- Freehold Semi-detached house
TW1 2LY - 2,506,000
- Freehold Detached house
TW1 2LY - 2,144,000
- Freehold Semi-detached house
TW1 2LY - 2,439,000
- Freehold Semi-detached house
TW1 2LY - 2,143,000
- Freehold Detached property
TW1 2LY - 2,380,000
- Freehold Semi-detached house
TW1 2LY - 2,225,000
- Freehold Semi-detached property
TW1 2LY - 2,208,000
- Semi-detached house
TW1 2LY - 2,219,000
- Freehold Semi-detached house
TW1 2LY - 2,164,000
- Freehold Semi-detached house
TW1 2LY - 2,031,000
- Freehold Semi-detached house
TW1 2LY - 2,314,000
- Freehold Semi-detached property
TW1 2LY - 1,826,000
- Freehold Semi-detached house
TW1 2LY - 2,183,000
- Freehold Semi-detached property
TW1 2LY - 2,219,000
- Freehold Semi-detached house
