SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TN13 2LN' order by fulladdress
TN13 2LN - 767,000
- Leasehold Flat/Maisonette
TN13 2LN - 733,000
- Leasehold Flat/Maisonette
TN13 2LN - 714,000
- Leasehold Converted flat
TN13 2LN - 823,000
- Leasehold Flat/Maisonette
TN13 2LN - 769,000
- Leasehold Flat/Maisonette
TN13 2LN - 2,027,000
- Freehold Detached house
TN13 2LN - 2,702,000
- Freehold Detached house
TN13 2LN - 517,000
- Leasehold Converted flat
TN13 2LN - 604,000
- Leasehold Purpose built flat
TN13 2LN - 3,899,000
- Freehold Detached house
TN13 2LN - 2,814,000
- Freehold Detached house
TN13 2LN - 2,797,000
- Freehold Detached property
TN13 2LN - 2,060,000
- Freehold Detached house
TN13 2LN - 1,683,000
- Freehold Detached house
TN13 2LN - 2,315,000
- Freehold Detached house
TN13 2LN - 3,638,000
- Freehold Detached house
TN13 2LN - 3,008,000
- Freehold Detached house
TN13 2LN - 2,280,000
- Freehold Detached house
TN13 2LN - 3,992,000
- Freehold Detached house
TN13 2LN - 3,325,000
- Freehold Detached house
TN13 2LN - 3,324,000
- Freehold Detached house
TN13 2LN - 3,882,000
- Freehold Detached house
TN13 2LN - 1,923,000
- Freehold End terrace house
TN13 2LN - 2,062,000
- Freehold Detached property
TN13 2LN - 3,283,000
- Freehold Detached house
