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 8LR' order by fulladdress
GU9 8LR - 713,000
- Semi-detached house
GU9 8LR - 534,000
- Mid terrace bungalow
GU9 8LR - 736,000
- Semi-detached house
GU9 8LR - 771,000
- Freehold Semi-detached house
GU9 8LR - 737,000
- Semi-detached house
GU9 8LR - 714,000
- Semi-detached house
GU9 8LR - 754,000
- Freehold Semi-detached house
GU9 8LR - 757,000
- Freehold Semi-detached house
GU9 8LR - 746,000
- Freehold Semi-detached house
GU9 8LR - 834,000
- Freehold Semi-detached house
GU9 8LR - 989,000
- Freehold Semi-detached house
GU9 8LR - 762,000
- Semi-detached house
GU9 8LR - 736,000
- Semi-detached house
GU9 8LR - 720,000
- Semi-detached house
GU9 8LR - 708,000
- Freehold Semi-detached property
GU9 8LR - 714,000
- Semi-detached house
GU9 8LR - 904,000
- Freehold Semi-detached house
GU9 8LR - 784,000
- Freehold Semi-detached house
GU9 8LR - 801,000
- Freehold Semi-detached house
GU9 8LR - 902,000
- Freehold Semi-detached house
GU9 8LR - 1,087,000
- Freehold Detached house
GU9 8LR - 1,111,000
- Freehold Detached property
GU9 8LR - 1,074,000
- Freehold Detached house
GU9 8LR - 1,132,000
- Detached property
GU9 8LR - 780,000
- Freehold Semi-detached house
GU9 8LR - 698,000
- Freehold Semi-detached house
GU9 8LR - 699,000
- Semi-detached house
GU9 8LR - 751,000
- Freehold Mid terrace house
GU9 8LR - 706,000
- Freehold Semi-detached house
GU9 8LR - 901,000
- Freehold Detached bungalow
