SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TN6 1TE' order by fulladdress
TN6 1TE - 971,000
- Freehold Detached house
TN6 1TE - 921,000
- Freehold Detached property
TN6 1TE - 973,000
- Freehold Detached house
TN6 1TE - 1,062,000
- Freehold Detached property
TN6 1TE - 841,000
- Freehold Detached property
TN6 1TE - 929,000
- Freehold Detached house
TN6 1TE - 965,000
- Freehold Detached house
TN6 1TE - 1,192,000
- Freehold Detached house
TN6 1TE - 1,065,000
- Freehold Detached house
TN6 1TE - 953,000
- Freehold Detached property
TN6 1TE - 943,000
- Freehold Detached house
TN6 1TE - 1,032,000
- Freehold Detached house
TN6 1TE - 1,091,000
- Freehold Detached house
TN6 1TE - 1,047,000
- Freehold Detached house
TN6 1TE - 890,000
- Freehold Detached house
TN6 1TE - 1,191,000
- Freehold Detached house
TN6 1TE - 973,000
- Freehold Detached house
TN6 1TE - 931,000
- Freehold Detached house
TN6 1TE - 863,000
- Freehold Detached property
TN6 1TE - 1,222,000
- Freehold Detached property
TN6 1TE - 796,000
- Freehold Detached house
TN6 1TE - 783,000
- Freehold Detached bungalow
TN6 1TE - 979,000
- Freehold Detached house
TN6 1TE - 814,000
- Freehold Detached house
TN6 1TE - 1,114,000
- Freehold Detached property
TN6 1TE - 1,074,000
- Freehold Detached house
TN6 1TE - 877,000
- Freehold Detached property
