SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='AL6 9GH' order by fulladdress
AL6 9GH - 1,229,000
- Freehold Detached house
AL6 9GH - 1,343,000
- Freehold Detached property
AL6 9GH - 1,160,000
- Freehold Semi-detached house
AL6 9GH - 963,000
- Freehold Semi-detached house
AL6 9GH - 1,282,000
- Freehold Detached property
AL6 9GH - 1,167,000
- Freehold Detached house
AL6 9GH - 1,255,000
- Freehold Detached house
AL6 9GH - 1,144,000
- Freehold Semi-detached house
AL6 9GH - 942,000
- Freehold Detached house
AL6 9GH - 1,188,000
- Freehold Semi-detached house
AL6 9GH - 834,000
- Freehold Mid terrace house
AL6 9GH - 879,000
- Freehold Semi-detached house
AL6 9GH - 1,251,000
- Freehold Detached house
AL6 9GH - 953,000
- Freehold Semi-detached property
AL6 9GH - 1,073,000
- Freehold Detached house
AL6 9GH - 962,000
- Freehold Semi-detached property
AL6 9GH - 1,138,000
- Freehold Semi-detached house
AL6 9GH - 1,292,000
- Freehold Detached house
AL6 9GH - 1,108,000
- Freehold Semi-detached house
AL6 9GH - 1,261,000
- Freehold Detached house
AL6 9GH - 1,043,000
- Freehold Detached house
AL6 9GH - 1,371,000
- Freehold Detached house
AL6 9GH - 1,062,000
- Freehold Semi-detached house
AL6 9GH - 936,000
- Freehold Semi-detached house
AL6 9GH - 1,071,000
- Freehold Semi-detached house
AL6 9GH - 961,000
- Freehold Semi-detached house
AL6 9GH - 791,000
- Freehold End terrace house
AL6 9GH - 1,223,000
- Freehold Detached house
AL6 9GH - 757,000
- Freehold Semi-detached house
AL6 9GH - 793,000
- Freehold End terrace house
AL6 9GH - 400,000
- Leasehold Mid terrace house
AL6 9GH - 1,102,000
- Freehold Semi-detached house
AL6 9GH - 834,000
- Freehold Detached house
AL6 9GH - 400,000
- Freehold Mid terrace house
AL6 9GH - 1,019,000
- Freehold Detached house
AL6 9GH - 495,000
- Freehold Semi-detached house
AL6 9GH - 970,000
- Semi-detached house
AL6 9GH - 738,000
- Freehold Mid terrace house
AL6 9GH - 724,000
- Freehold Terrace property
AL6 9GH - 812,000
- Freehold End terrace house
AL6 9GH - 743,000
- Freehold Terrace property
AL6 9GH - 1,120,000
- Freehold Semi-detached property
AL6 9GH - 792,000
- Freehold Semi-detached house
AL6 9GH - 753,000
- Freehold Semi-detached house
AL6 9GH - 1,105,000
- Freehold Semi-detached house
AL6 9GH - 1,149,000
- Freehold Semi-detached house
AL6 9GH - 1,331,000
- Freehold Detached house
AL6 9GH - 1,224,000
- Freehold Detached house
