SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N16 9AE' order by fulladdress
N16 9AE - 1,223,000
- Freehold End terrace house
N16 9AE - 745,000
- Leasehold Converted flat
N16 9AE - 717,000
- Leasehold Converted flat
N16 9AE - 768,000
- Leasehold Converted flat
N16 9AE - 721,000
- Leasehold Converted flat
N16 9AE - 729,000
- Feudal Purpose built flat
N16 9AE - 666,000
- Leasehold Purpose built flat
N16 9AE - 891,000
- Leasehold Flat/Maisonette
N16 9AE - 802,000
- Feudal Converted flat
N16 9AE - 831,000
- Leasehold Flat/Maisonette
N16 9AE - 774,000
- Freehold Flat/Maisonette
N16 9AE - 1,244,000
- Freehold Mid terrace house
N16 9AE - 763,000
- Leasehold Flat/Maisonette
N16 9AE - 1,056,000
- Freehold Terrace property
N16 9AE - 1,084,000
- Freehold Mid terrace house
N16 9AE - 1,206,000
- Freehold Mid terrace house
N16 9AE - 1,097,000
- Freehold Mid terrace house
N16 9AE - 936,000
- Leasehold Flat/Maisonette
N16 9AE - 911,000
- Leasehold Flat/Maisonette
N16 9AE - 747,000
- Feudal Converted flat
N16 9AE - 742,000
- Leasehold Flat/Maisonette
N16 9AE - 708,000
- Leasehold Converted flat
N16 9AE - 1,242,000
- Freehold Terrace property
N16 9AE - 707,000
- Leasehold Flat/Maisonette
N16 9AE - 862,000
- Leasehold Flat/Maisonette
N16 9AE - 894,000
- Leasehold Converted flat
N16 9AE - 854,000
- Leasehold Converted flat
N16 9AE - 873,000
- Leasehold Converted flat
N16 9AE - 837,000
- Leasehold Converted flat
N16 9AE - 780,000
- Feudal Converted flat
N16 9AE - 894,000
- Feudal Purpose built flat
N16 9AE - 872,000
- Leasehold Converted flat
N16 9AE - 775,000
- Leasehold Flat/Maisonette
N16 9AE - 813,000
- Leasehold Converted flat
N16 9AE - 913,000
- Leasehold Converted flat
N16 9AE - 815,000
- Leasehold Converted flat
N16 9AE - 878,000
- Leasehold Converted flat
N16 9AE - 926,000
- Leasehold Flat/Maisonette
N16 9AE - 892,000
- Leasehold Purpose built flat
N16 9AE - 775,000
- Leasehold Flat/Maisonette
N16 9AE - 766,000
- Leasehold Converted flat
N16 9AE - 715,000
- Leasehold Converted flat
N16 9AE - 711,000
- Leasehold Converted flat
N16 9AE - 800,000
- Leasehold Converted flat
