SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GU1 1XF' order by fulladdress
GU1 1XF - 1,554,000
- Freehold Detached house
GU1 1XF - 1,355,000
- Freehold Detached house
GU1 1XF - 1,163,000
- Freehold Detached house
GU1 1XF - 1,517,000
- Freehold Detached property
GU1 1XF - 1,629,000
- Freehold Detached house
GU1 1XF - 2,023,000
- Freehold Detached house
GU1 1XF - 1,775,000
- Freehold Detached bungalow
GU1 1XF - 1,724,000
- Freehold Detached house
GU1 1XF - 1,952,000
- Freehold Detached property
GU1 1XF - 1,913,000
- Freehold Detached house
GU1 1XF - 2,003,000
- Freehold Detached house
GU1 1XF - 1,730,000
- Freehold Detached house
GU1 1XF - 1,535,000
- Freehold Detached house
GU1 1XF - 1,662,000
- Freehold Detached house
GU1 1XF - 1,585,000
- Freehold Detached house
GU1 1XF - 1,814,000
- Freehold Detached house
GU1 1XF - 1,558,000
- Freehold Detached house