SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='AL1 2AZ' order by fulladdress
AL1 2AZ - 323,000
- Leasehold Converted flat
AL1 2AZ - 948,000
- Freehold Semi-detached house
AL1 2AZ - 873,000
- Freehold Semi-detached house
AL1 2AZ - 757,000
- Freehold Detached house
AL1 2AZ - 864,000
- Freehold Semi-detached house
AL1 2AZ - 745,000
- Freehold Detached house
AL1 2AZ - 901,000
- Freehold Detached bungalow
AL1 2AZ - 1,065,000
- Freehold Detached bungalow
AL1 2AZ - 1,131,000
- Freehold Semi-detached house
AL1 2AZ - 490,000
- Leasehold Converted flat
AL1 2AZ - 835,000
- Freehold Detached house
AL1 2AZ - 1,158,000
- Freehold Semi-detached house
AL1 2AZ - 880,000
- Freehold Semi-detached house
AL1 2AZ - 945,000
- Freehold Semi-detached house
AL1 2AZ - 998,000
- Freehold Semi-detached house
AL1 2AZ - 921,000
- Freehold Semi-detached house
AL1 2AZ - 832,000
- Freehold Semi-detached house
AL1 2AZ - 810,000
- Freehold Detached house
AL1 2AZ - 905,000
- Freehold Semi-detached house
AL1 2AZ - 908,000
- Freehold Semi-detached house
AL1 2AZ - 987,000
- Freehold Detached house
AL1 2AZ - 1,004,000
- Freehold Detached house
AL1 2AZ - 984,000
- Freehold Semi-detached house
AL1 2AZ - 980,000
- Freehold Semi-detached house
AL1 2AZ - 806,000
- Freehold End terrace house
