SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TQ6 9RH' order by fulladdress
TQ6 9RH - 1,791,000
- Freehold Detached property
TQ6 9RH - 1,280,000
- Freehold Detached house
TQ6 9RH - 697,000
- Freehold Converted flat
TQ6 9RH - 797,000
- Feudal Converted flat
TQ6 9RH - 473,000
- Freehold Semi-detached property
TQ6 9RH - 958,000
- Freehold Terrace property
TQ6 9RH - 619,000
- Freehold Semi-detached house
TQ6 9RH - 437,000
- Freehold Semi-detached property
TQ6 9RH - 515,000
- Freehold Semi-detached property
TQ6 9RH - 748,000
- Freehold Detached property
TQ6 9RH - 1,067,000
- Freehold Detached house
TQ6 9RH - 671,000
- Freehold Semi-detached house
TQ6 9RH - 597,000
- Freehold Detached property
TQ6 9RH - 1,189,000
- Freehold Detached house
TQ6 9RH - 2,056,000
- Freehold Detached house
TQ6 9RH - 1,091,000
- Freehold Detached house
TQ6 9RH - 1,068,000
- Freehold Detached house
TQ6 9RH - 556,000
- Leasehold Flat/Maisonette
TQ6 9RH - 985,000
- Freehold Semi-detached house
TQ6 9RH - 931,000
- Freehold Detached house
TQ6 9RH - 711,000
- Leasehold Flat/Maisonette
TQ6 9RH - 1,161,000
- Freehold Detached house
TQ6 9RH - 674,000
- Leasehold Converted flat
TQ6 9RH - 476,000
- Freehold Flat/Maisonette
TQ6 9RH - 666,000
- Freehold Semi-detached house
TQ6 9RH - 946,000
- Freehold Detached house
TQ6 9RH - 482,000
- Leasehold Flat/Maisonette
TQ6 9RH - 1,435,000
- Freehold Detached house
