SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='AL2 1UX' order by fulladdress
AL2 1UX - 664,000
- Freehold Mid terrace house
AL2 1UX - 663,000
- Freehold Terrace property
AL2 1UX - 521,000
- Freehold Mid terrace house
AL2 1UX - 514,000
- Freehold Mid terrace house
AL2 1UX - 650,000
- Freehold End terrace house
AL2 1UX - 667,000
- Freehold Detached house
AL2 1UX - 620,000
- Freehold Mid terrace house
AL2 1UX - 518,000
- Freehold Mid terrace house
AL2 1UX - 543,000
- Freehold Terrace property
AL2 1UX - 520,000
- Freehold End terrace house
AL2 1UX - 803,000
- Freehold Terrace property
AL2 1UX - 873,000
- Freehold Terrace property
AL2 1UX - 942,000
- Freehold End terrace house
AL2 1UX - 521,000
- Freehold End terrace house
AL2 1UX - 520,000
- Freehold Mid terrace house
AL2 1UX - 518,000
- Freehold Mid terrace house
AL2 1UX - 671,000
- Freehold Terrace property
AL2 1UX - 712,000
- Freehold Terrace property
AL2 1UX - 796,000
- Freehold Semi-detached house
AL2 1UX - 1,078,000
- Freehold Mid terrace house
AL2 1UX - 1,141,000
- Freehold Mid terrace house
AL2 1UX - 1,140,000
- Freehold Mid terrace house
AL2 1UX - 1,141,000
- Freehold End terrace house
AL2 1UX - 1,104,000
- Freehold End terrace house
AL2 1UX - 945,000
- Freehold End terrace house
AL2 1UX - 935,000
- Freehold Flat/Maisonette
AL2 1UX - 1,085,000
- Freehold Mid terrace house
AL2 1UX - 860,000
- Freehold End terrace house
AL2 1UX - 838,000
- Freehold End terrace house
AL2 1UX - 1,049,000
- Freehold Mid terrace house
AL2 1UX - 941,000
- Freehold Detached house
AL2 1UX - 1,138,000
- Freehold Terraced
AL2 1UX - 911,000
- Freehold Terrace property
AL2 1UX - 1,069,000
- Freehold End terrace house
AL2 1UX - 1,014,000
- Freehold Terrace property
AL2 1UX - 1,035,000
- Freehold Mid terrace house
AL2 1UX - 1,045,000
- Freehold Mid terrace house
AL2 1UX - 895,000
- Freehold End terrace house
AL2 1UX - 685,000
- Freehold Terrace property
AL2 1UX - 689,000
- Freehold Terrace property
AL2 1UX - 667,000
- Freehold End terrace house
AL2 1UX - 899,000
- Freehold Terrace property
AL2 1UX - 933,000
- Freehold End terrace house
AL2 1UX - 913,000
- Freehold End terrace house
AL2 1UX - 880,000
- Freehold Mid terrace house
AL2 1UX - 915,000
- Freehold Mid terrace house
AL2 1UX - 658,000
- Freehold Mid terrace house
AL2 1UX - 521,000
- Freehold Terrace property
AL2 1UX - 533,000
- Freehold Terrace property
AL2 1UX - 522,000
- Freehold Mid terrace house
AL2 1UX - 516,000
- Freehold Mid terrace house
AL2 1UX - 516,000
- Freehold Mid terrace house
AL2 1UX - 535,000
- Freehold Mid terrace house
AL2 1UX - 634,000
- Freehold Mid terrace house
AL2 1UX - 647,000
- Freehold End terrace house