SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GU9 0DT' order by fulladdress
GU9 0DT - 722,000
- Freehold Detached house
GU9 0DT - 630,000
- Freehold Detached bungalow
GU9 0DT - 488,000
- Freehold Semi-detached bungalow
GU9 0DT - 492,000
- Freehold Semi-detached property
GU9 0DT - 609,000
- Freehold Detached house
GU9 0DT - 706,000
- Freehold Detached house
GU9 0DT - 681,000
- Freehold Detached property
GU9 0DT - 713,000
- Freehold Detached house
GU9 0DT - 509,000
- Freehold Semi-detached house
GU9 0DT - 525,000
- Freehold Semi-detached house
GU9 0DT - 684,000
- Freehold Detached house
GU9 0DT - 707,000
- Freehold Detached house
GU9 0DT - 504,000
- Freehold Semi-detached house
GU9 0DT - 507,000
- Freehold Semi-detached house
GU9 0DT - 608,000
- Freehold Semi-detached house
GU9 0DT - 496,000
- Freehold Semi-detached house
GU9 0DT - 484,000
- Freehold Semi-detached house
GU9 0DT - 575,000
- Freehold Semi-detached property
GU9 0DT - 715,000
- Freehold Detached house
GU9 0DT - 673,000
- Freehold Detached property
GU9 0DT - 662,000
- Freehold Detached house
GU9 0DT - 550,000
- Freehold Detached bungalow
GU9 0DT - 428,000
- Freehold Bungalow property
GU9 0DT - 457,000
- Freehold Semi-detached bungalow
GU9 0DT - 696,000
- Freehold Detached bungalow