SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TN15 8FP' order by fulladdress
TN15 8FP - 493,000
- Freehold Semi-detached house
TN15 8FP - 441,000
- Freehold Mid terrace house
TN15 8FP - 503,000
- Freehold Mid terrace house
TN15 8FP - 421,000
- Freehold Terrace property
TN15 8FP - 465,000
- Freehold Terrace property
TN15 8FP - 438,000
- Freehold Mid terrace house
TN15 8FP - 448,000
- Freehold Mid terrace house
TN15 8FP - 312,000
- Leasehold Purpose built flat
TN15 8FP - 323,000
- Freehold Detached house
TN15 8FP - 497,000
- Freehold Detached house
TN15 8FP - 461,000
- Freehold Semi-detached house
TN15 8FP - 482,000
- Freehold Semi-detached property
TN15 8FP - 373,000
- Freehold Semi-detached house
TN15 8FP - 500,000
- Freehold End terrace house
TN15 8FP - 437,000
- Freehold End terrace house
TN15 8FP - 376,000
- Freehold End terrace house
TN15 8FP - 432,000
- Freehold Mid terrace house
TN15 8FP - 378,000
- Freehold Mid terrace house
TN15 8FP - 439,000
- Freehold End terrace house
TN15 8FP - 469,000
- Freehold Semi-detached house
TN15 8FP - 439,000
- Freehold End terrace house
TN15 8FP - 423,000
- Freehold End terrace house
TN15 8FP - 491,000
- Freehold Detached house
TN15 8FP - 444,000
- Freehold Mid terrace house
TN15 8FP - 470,000
- Freehold Semi-detached property
TN15 8FP - 381,000
- Freehold End terrace house
TN15 8FP - 508,000
- Freehold Semi-detached house
TN15 8FP - 517,000
- Freehold Detached house
TN15 8FP - 374,000
- Freehold End terrace house
TN15 8FP - 365,000
- Freehold Mid terrace house
TN15 8FP - 455,000
- Freehold Semi-detached house
TN15 8FP - 445,000
- Freehold End terrace house
TN15 8FP - 388,000
- Freehold End terrace house
TN15 8FP - 500,000
- Freehold Semi-detached house
TN15 8FP - 739,000
- Freehold Detached house
TN15 8FP - 475,000
- Freehold Semi-detached house
TN15 8FP - 712,000
- Freehold Detached house
TN15 8FP - 497,000
- Freehold Detached house
TN15 8FP - 750,000
- Freehold Detached house
TN15 8FP - 756,000
- Freehold Detached house
TN15 8FP - 765,000
- Freehold Detached house
TN15 8FP - 427,000
- Freehold Mid terrace house
TN15 8FP - 794,000
- Freehold Detached house
TN15 8FP - 750,000
- Freehold Detached house
TN15 8FP - 649,000
- Freehold Detached house
TN15 8FP - 802,000
- Freehold Detached house
TN15 8FP - 570,000
- Freehold Semi-detached house
TN15 8FP - 427,000
- Freehold Semi-detached house
TN15 8FP - 569,000
- Freehold Semi-detached house
TN15 8FP - 801,000
- Freehold Detached house
TN15 8FP - 317,000
- Freehold Flat/Maisonette
TN15 8FP - 448,000
- Freehold Mid terrace house
