SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TF11 9PF' order by fulladdress
TF11 9PF - 322,000
- Freehold Semi-detached house
TF11 9PF - 307,000
- Freehold Detached property
TF11 9PF - 382,000
- Freehold Detached house
TF11 9PF - 392,000
- Freehold Detached house
TF11 9PF - 432,000
- Freehold Detached house
TF11 9PF - 435,000
- Freehold Detached house
TF11 9PF - 409,000
- Freehold Detached house
TF11 9PF - 425,000
- Freehold Detached house
TF11 9PF - 392,000
- Freehold Detached house
TF11 9PF - 521,000
- Freehold Detached house
TF11 9PF - 297,000
- Freehold Semi-detached house
TF11 9PF - 283,000
- Freehold Semi-detached property
TF11 9PF - 328,000
- Freehold Semi-detached house
TF11 9PF - 280,000
- Freehold Terrace property
TF11 9PF - 241,000
- Freehold End terrace house
TF11 9PF - 240,000
- Freehold End terrace house
TF11 9PF - 213,000
- Freehold Terrace property
TF11 9PF - 219,000
- Freehold Terrace property
TF11 9PF - 273,000
- Freehold End terrace house
TF11 9PF - 287,000
- Freehold End terrace house
TF11 9PF - 215,000
- Freehold Mid terrace house
TF11 9PF - 273,000
- Freehold Terrace property
TF11 9PF - 283,000
- Freehold Semi-detached house
TF11 9PF - 278,000
- Freehold Semi-detached house
TF11 9PF - 293,000
- Freehold Semi-detached house
TF11 9PF - 288,000
- Freehold Semi-detached house
TF11 9PF - 237,000
- Freehold End terrace house
TF11 9PF - 219,000
- Freehold Mid terrace house
TF11 9PF - 224,000
- Freehold Mid terrace house
TF11 9PF - 407,000
- Freehold Detached house
TF11 9PF - 287,000
- Freehold End terrace house
TF11 9PF - 290,000
- Freehold End terrace house
TF11 9PF - 284,000
- Freehold Mid terrace house
TF11 9PF - 232,000
- Freehold Mid terrace house
TF11 9PF - 237,000
- Leasehold Mid terrace house
TF11 9PF - 230,000
- Leasehold Mid terrace house
TF11 9PF - 405,000
- Freehold Detached house
TF11 9PF - 392,000
- Freehold Detached house
TF11 9PF - 336,000
- Freehold Detached property
TF11 9PF - 331,000
- Freehold Detached property
TF11 9PF - 313,000
- Freehold Detached house
TF11 9PF - 426,000
- Freehold Detached house
TF11 9PF - 335,000
- Freehold Detached house