SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TN2 4NS' order by fulladdress
TN2 4NS - 560,000
- Freehold Semi-detached house
TN2 4NS - 632,000
- Freehold Detached house
TN2 4NS - 599,000
- Freehold Semi-detached house
TN2 4NS - 666,000
- Freehold Detached house
TN2 4NS - 610,000
- Freehold Semi-detached house
TN2 4NS - 594,000
- Freehold Semi-detached property
TN2 4NS - 685,000
- Freehold Detached house
TN2 4NS - 666,000
- Freehold Detached house
TN2 4NS - 658,000
- Freehold Detached house
TN2 4NS - 655,000
- Freehold Detached house
TN2 4NS - 642,000
- Freehold Detached house
TN2 4NS - 677,000
- Freehold Detached house
TN2 4NS - 666,000
- Freehold Detached house
TN2 4NS - 662,000
- Freehold Detached house
TN2 4NS - 638,000
- Freehold Semi-detached property
TN2 4NS - 747,000
- Freehold Detached house
TN2 4NS - 639,000
- Freehold Semi-detached house
TN2 4NS - 599,000
- Freehold Semi-detached house
TN2 4NS - 624,000
- Freehold Semi-detached house
TN2 4NS - 627,000
- Freehold Detached house
TN2 4NS - 666,000
- Freehold Detached house
TN2 4NS - 644,000
- Freehold Detached house
TN2 4NS - 684,000
- Freehold Detached house
TN2 4NS - 652,000
- Freehold Semi-detached property
TN2 4NS - 597,000
- Freehold Semi-detached house
