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 3AS' order by fulladdress
AL1 3AS - 728,000
- Leasehold Purpose built flat
AL1 3AS - 1,135,000
- Leasehold Mid terrace house
AL1 3AS - 1,155,000
- Leasehold Mid terrace house
AL1 3AS - 1,127,000
- Leasehold Mid terrace house
AL1 3AS - 1,078,000
- Mid terrace house
AL1 3AS - 1,140,000
- Leasehold Mid terrace house
AL1 3AS - 1,120,000
- Leasehold Terrace property
AL1 3AS - 1,366,000
- Leasehold End terrace house
AL1 3AS - 770,000
- Leasehold End terrace property
AL1 3AS - 736,000
- Leasehold Flat/Maisonette
AL1 3AS - 416,000
- Leasehold Flat/Maisonette
AL1 3AS - 768,000
- Leasehold Flat/Maisonette
AL1 3AS - 401,000
- Leasehold Flat/Maisonette
AL1 3AS - 426,000
- Leasehold Purpose built flat
AL1 3AS - 415,000
- Leasehold Flat/Maisonette
AL1 3AS - 672,000
- Leasehold Flat/Maisonette
AL1 3AS - 689,000
- Leasehold Flat/Maisonette
AL1 3AS - 783,000
- Leasehold Purpose built flat
AL1 3AS - 739,000
- Leasehold Purpose built flat
AL1 3AS - 1,181,000
- Leasehold Mid terrace house
AL1 3AS - 1,194,000
- Mid terrace house
AL1 3AS - 1,214,000
- Leasehold Mid terrace house
AL1 3AS - 769,000
- Leasehold Mid terrace house
AL1 3AS - 1,243,000
- Leasehold Mid terrace house
AL1 3AS - 1,300,000
- Leasehold Mid terrace house
AL1 3AS - 1,108,000
- Leasehold Mid terrace house
AL1 3AS - 1,321,000
- Leasehold Mid terrace house
AL1 3AS - 1,230,000
- Leasehold Mid terrace house
AL1 3AS - 1,224,000
- Leasehold Mid terrace house
AL1 3AS - 1,286,000
- Leasehold Mid terrace house
AL1 3AS - 1,259,000
- Mid terrace house
AL1 3AS - 1,213,000
- Leasehold Mid terrace house
AL1 3AS - 1,255,000
- Leasehold Mid terrace house
AL1 3AS - 620,000
- Leasehold Flat/Maisonette
AL1 3AS - 1,269,000
- Leasehold Mid terrace house
AL1 3AS - 1,262,000
- Leasehold Mid terrace house
AL1 3AS - 1,230,000
- Mid terrace house
AL1 3AS - 1,266,000
- Leasehold Mid terrace house
AL1 3AS - 1,234,000
- End terrace house
AL1 3AS - 1,192,000
- Leasehold End terrace property
AL1 3AS - 1,164,000
- Leasehold Mid terrace house
AL1 3AS - 1,248,000
- Leasehold Mid terrace house
AL1 3AS - 1,211,000
- Leasehold Terrace property
AL1 3AS - 1,290,000
- Leasehold Mid terrace house
AL1 3AS - 649,000
- Leasehold Purpose built flat
AL1 3AS - 1,292,000
- Leasehold Mid terrace house
AL1 3AS - 1,199,000
- Leasehold Mid terrace house
AL1 3AS - 1,237,000
- Freehold Mid terrace house
AL1 3AS - 1,295,000
- Leasehold Mid terrace house
AL1 3AS - 1,248,000
- Leasehold Mid terrace house
AL1 3AS - 750,000
- Leasehold Flat/Maisonette
AL1 3AS - 745,000
- Leasehold Purpose built flat
AL1 3AS - 805,000
- Leasehold End terrace house
AL1 3AS - 644,000
- Leasehold Flat/Maisonette
AL1 3AS - 593,000
- Leasehold Flat/Maisonette
AL1 3AS - 1,025,000
- Leasehold Purpose built flat
AL1 3AS - 991,000
- Leasehold Purpose built flat
AL1 3AS - 1,393,000
- Leasehold End terrace house
AL1 3AS - 1,316,000
- Leasehold Mid terrace house
AL1 3AS - 1,290,000
- Leasehold Mid terrace house
AL1 3AS - 1,334,000
- Leasehold Mid terrace house
AL1 3AS - 1,305,000
- Mid terrace house
AL1 3AS - 1,310,000
- Leasehold Mid terrace house
AL1 3AS - 1,283,000
- Leasehold Mid terrace house
AL1 3AS - 1,424,000
- Leasehold Detached bungalow
AL1 3AS - 1,236,000
- Mid terrace house
AL1 3AS - 1,135,000
- Leasehold Mid terrace house
AL1 3AS - 1,316,000
- Leasehold Mid terrace house
AL1 3AS - 1,112,000
- Leasehold Mid terrace house
AL1 3AS - 1,178,000
- Leasehold Mid terrace house