SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW18 4XT' order by fulladdress
TW18 4XT - 695,000
- Freehold Detached house
TW18 4XT - 1,028,000
- Freehold Detached house
TW18 4XT - 1,004,000
- Freehold Detached house
TW18 4XT - 722,000
- Freehold Detached house
TW18 4XT - 655,000
- Freehold Semi-detached house
TW18 4XT - 634,000
- Freehold Semi-detached property
TW18 4XT - 498,000
- Freehold Semi-detached house
TW18 4XT - 512,000
- Freehold Semi-detached house
TW18 4XT - 635,000
- Freehold Semi-detached house
TW18 4XT - 606,000
- Freehold Semi-detached house
TW18 4XT - 948,000
- Freehold Detached house
TW18 4XT - 867,000
- Freehold Detached house
TW18 4XT - 876,000
- Freehold Detached house
TW18 4XT - 905,000
- Freehold Detached property
TW18 4XT - 827,000
- Freehold Detached house
TW18 4XT - 900,000
- Freehold Detached house
TW18 4XT - 663,000
- Freehold Semi-detached property
TW18 4XT - 632,000
- Freehold Semi-detached house
TW18 4XT - 652,000
- Freehold Semi-detached house
TW18 4XT - 951,000
- Freehold Detached property
TW18 4XT - 763,000
- Freehold End terrace house
TW18 4XT - 765,000
- Freehold Mid terrace house
TW18 4XT - 960,000
- Freehold Detached house
TW18 4XT - 723,000
- Freehold Mid terrace house
TW18 4XT - 789,000
- Freehold Mid terrace house
TW18 4XT - 753,000
- Freehold Semi-detached house
TW18 4XT - 721,000
- Freehold Terrace property
TW18 4XT - 734,000
- Freehold Detached house
TW18 4XT - 716,000
- Freehold Mid terrace house
TW18 4XT - 676,000
- Freehold Terrace property
TW18 4XT - 936,000
- Freehold Detached house
TW18 4XT - 1,004,000
- Freehold Detached house
TW18 4XT - 982,000
- Freehold Detached house
TW18 4XT - 998,000
- Freehold Detached property
TW18 4XT - 1,008,000
- Freehold Detached house
TW18 4XT - 925,000
- Freehold Detached property