SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TN22 4AS' order by fulladdress
TN22 4AS - 238,000
- Leasehold Flat/Maisonette
TN22 4AS - 240,000
- Leasehold Flat/Maisonette
TN22 4AS - 386,000
- Freehold Semi-detached house
TN22 4AS - 226,000
- Leasehold Purpose built flat
TN22 4AS - 385,000
- Freehold Semi-detached house
TN22 4AS - 645,000
- Freehold Detached house
TN22 4AS - 498,000
- Freehold Semi-detached house
TN22 4AS - 486,000
- Freehold Semi-detached house
TN22 4AS - 493,000
- Freehold Detached house
TN22 4AS - 799,000
- Freehold Detached house
TN22 4AS - 469,000
- Freehold Semi-detached house
TN22 4AS - 396,000
- Freehold End terrace house
TN22 4AS - 462,000
- Freehold Semi-detached house
TN22 4AS - 365,000
- Freehold Terrace property
TN22 4AS - 252,000
- Leasehold Flat/Maisonette
TN22 4AS - 523,000
- Freehold Terrace property
TN22 4AS - 547,000
- Freehold Mid terrace house
TN22 4AS - 547,000
- Freehold Detached house
TN22 4AS - 264,000
- Freehold Flat/Maisonette
TN22 4AS - 698,000
- Freehold Detached house
TN22 4AS - 666,000
- Freehold Detached house
TN22 4AS - 593,000
- Freehold Detached house
TN22 4AS - 566,000
- Freehold Semi-detached house
TN22 4AS - 498,000
- Freehold Semi-detached house
TN22 4AS - 498,000
- Freehold Semi-detached house
TN22 4AS - 544,000
- Freehold Semi-detached house
TN22 4AS - 683,000
- Freehold Detached house
TN22 4AS - 663,000
- Freehold Detached house
TN22 4AS - 241,000
- Leasehold Flat/Maisonette
TN22 4AS - 780,000
- Freehold Detached house
TN22 4AS - 266,000
- Leasehold Flat/Maisonette
TN22 4AS - 210,000
- Leasehold Purpose built flat
