SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW2 5EL' order by fulladdress
TW2 5EL - 743,000
- Freehold Detached house
TW2 5EL - 1,003,000
- Freehold Semi-detached house
TW2 5EL - 806,000
- Freehold Semi-detached property
TW2 5EL - 763,000
- Freehold Semi-detached property
TW2 5EL - 1,036,000
- Freehold End terrace house
TW2 5EL - 658,000
- Freehold Mid terrace house
TW2 5EL - 1,100,000
- Freehold End terrace house
TW2 5EL - 712,000
- Freehold Semi-detached house
TW2 5EL - 908,000
- Freehold End terrace house
TW2 5EL - 608,000
- Freehold Semi-detached house
TW2 5EL - 777,000
- Freehold Semi-detached house
TW2 5EL - 786,000
- Freehold Terrace property
TW2 5EL - 884,000
- Freehold Mid terrace house
TW2 5EL - 890,000
- Freehold Mid terrace house
TW2 5EL - 821,000
- Freehold End terrace house
TW2 5EL - 810,000
- Freehold Semi-detached house
TW2 5EL - 729,000
- Freehold Mid terrace house
TW2 5EL - 750,000
- Freehold Mid terrace house
TW2 5EL - 1,018,000
- Freehold Mid terrace house
TW2 5EL - 983,000
- Freehold Semi-detached house
TW2 5EL - 720,000
- Freehold Semi-detached house
TW2 5EL - 718,000
- Freehold Semi-detached house
TW2 5EL - 529,000
- Freehold Semi-detached house
TW2 5EL - 882,000
- Freehold Semi-detached house
TW2 5EL - 499,000
- Freehold Mid terrace house
TW2 5EL - 969,000
- Freehold Terrace property
TW2 5EL - 916,000
- Freehold Mid terrace house
TW2 5EL - 798,000
- Freehold Terrace property
TW2 5EL - 944,000
- Freehold End terrace house
TW2 5EL - 694,000
- Freehold Semi-detached house
TW2 5EL - 900,000
- Freehold Detached house
TW2 5EL - 697,000
- Freehold Semi-detached house
TW2 5EL - 835,000
- Freehold Semi-detached house
TW2 5EL - 1,134,000
- Freehold Detached house
TW2 5EL - 711,000
- Freehold Semi-detached house
TW2 5EL - 690,000
- Freehold Semi-detached house
TW2 5EL - 1,031,000
- Freehold Semi-detached house
TW2 5EL - 942,000
- Freehold Semi-detached house
TW2 5EL - 894,000
- Freehold Detached property
TW2 5EL - 786,000
- Freehold Detached property
