SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GL51 3AH' order by fulladdress
GL51 3AH - 833,000
- Freehold Detached house
GL51 3AH - 1,326,000
- Freehold Detached house
GL51 3AH - 775,000
- Freehold Detached house
GL51 3AH - 904,000
- Freehold Detached property
GL51 3AH - 718,000
- Freehold Detached property
GL51 3AH - 957,000
- Freehold Detached house
GL51 3AH - 1,006,000
- Freehold Detached house
GL51 3AH - 1,406,000
- Freehold Detached house
GL51 3AH - 876,000
- Freehold Detached property
GL51 3AH - 814,000
- Freehold Detached house
GL51 3AH - 1,418,000
- Freehold Detached house
GL51 3AH - 855,000
- Freehold Detached house
GL51 3AH - 1,083,000
- Freehold Detached house
GL51 3AH - 1,008,000
- Freehold Detached house
GL51 3AH - 851,000
- Freehold Detached house
GL51 3AH - 806,000
- Freehold Detached property
GL51 3AH - 815,000
- Freehold Detached property
GL51 3AH - 1,123,000
- Freehold Detached house
GL51 3AH - 1,041,000
- Freehold Detached property
GL51 3AH - 872,000
- Freehold Detached house
GL51 3AH - 984,000
- Freehold Detached house
GL51 3AH - 957,000
- Freehold Detached house
GL51 3AH - 952,000
- Freehold Detached house
GL51 3AH - 949,000
- Freehold Detached property
GL51 3AH - 1,083,000
- Freehold Detached house
GL51 3AH - 743,000
- Freehold Detached house
GL51 3AH - 735,000
- Freehold Semi-detached house
GL51 3AH - 684,000
- Freehold Semi-detached house
GL51 3AH - 956,000
- Freehold Detached house
GL51 3AH - 887,000
- Freehold Detached house