SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GU32 1HF' order by fulladdress
GU32 1HF - 1,580,000
- Freehold Detached house
GU32 1HF - 1,141,000
- Leasehold Flat/Maisonette
GU32 1HF - 1,154,000
- Leasehold End terrace house
GU32 1HF - 946,000
- Leasehold End terrace house
GU32 1HF - 824,000
- Leasehold Mid terrace house
GU32 1HF - 1,310,000
- Leasehold Mid terrace house
GU32 1HF - 798,000
- Leasehold Terrace property
GU32 1HF - 767,000
- Leasehold End terrace house
GU32 1HF - 1,547,000
- Freehold Detached house
GU32 1HF - 1,660,000
- Freehold Detached house
GU32 1HF - 1,631,000
- Freehold Detached house
GU32 1HF - 1,803,000
- Freehold Detached house
GU32 1HF - 1,490,000
- Freehold Detached house
GU32 1HF - 1,657,000
- Freehold Detached house
GU32 1HF - 1,489,000
- Freehold Detached house
GU32 1HF - 1,687,000
- Leasehold Detached property
GU32 1HF - 1,611,000
- Freehold Detached property
GU32 1HF - 1,654,000
- Freehold Detached property
GU32 1HF - 1,895,000
- Freehold Detached property
GU32 1HF - 1,696,000
- Freehold Detached house
GU32 1HF - 1,811,000
- Freehold Detached property
GU32 1HF - 1,900,000
- Freehold Detached house
GU32 1HF - 1,360,000
- Leasehold Terrace property
GU32 1HF - 1,471,000
- Leasehold Flat/Maisonette
GU32 1HF - 1,648,000
- Freehold Detached house
GU32 1HF - 1,694,000
- Freehold Detached house
