SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GU34 4FB' order by fulladdress
GU34 4FB - 1,529,000
- Freehold Detached house
GU34 4FB - 779,000
- Freehold Mid terrace house
GU34 4FB - 561,000
- Freehold Semi-detached house
GU34 4FB - 690,000
- Freehold Mid terrace house
GU34 4FB - 696,000
- Freehold Mid terrace house
GU34 4FB - 663,000
- Freehold Mid terrace house
GU34 4FB - 518,000
- Leasehold End terrace house
GU34 4FB - 825,000
- Freehold End terrace house
GU34 4FB - 464,000
- Freehold Mid terrace house
GU34 4FB - 536,000
- Leasehold End terrace house
GU34 4FB - 690,000
- Freehold Mid terrace house
GU34 4FB - 547,000
- Freehold Semi-detached house
GU34 4FB - 662,000
- Freehold Mid terrace house
GU34 4FB - 543,000
- Freehold Semi-detached house
GU34 4FB - 381,000
- Leasehold Flat/Maisonette
GU34 4FB - 1,592,000
- Freehold Detached house
GU34 4FB - 674,000
- Freehold Mid terrace house
GU34 4FB - 1,672,000
- Freehold Detached house
GU34 4FB - 1,706,000
- Freehold Detached house
GU34 4FB - 679,000
- Freehold Terrace property
GU34 4FB - 1,543,000
- Freehold Detached house
GU34 4FB - 632,000
- Freehold Mid terrace house
GU34 4FB - 711,000
- Freehold Mid terrace house
GU34 4FB - 1,020,000
- Freehold Detached house
GU34 4FB - 1,440,000
- Freehold Detached house
GU34 4FB - 907,000
- Freehold Mid terrace house
GU34 4FB - 1,022,000
- Freehold Detached house
GU34 4FB - 563,000
- Freehold Semi-detached house
