SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N1 6DH' order by fulladdress
N1 6DH - 827,000
- Leasehold Converted flat
N1 6DH - 1,124,000
- Leasehold Flat/Maisonette
N1 6DH - 668,000
- Leasehold Flat/Maisonette
N1 6DH - 957,000
- Leasehold Converted flat
N1 6DH - 981,000
- Leasehold Flat/Maisonette
N1 6DH - 711,000
- Leasehold Flat/Maisonette
N1 6DH - 891,000
- Leasehold Converted flat
N1 6DH - 742,000
- Leasehold Converted flat
N1 6DH - 782,000
- Leasehold Flat/Maisonette
N1 6DH - 1,217,000
- Leasehold Converted flat
N1 6DH - 719,000
- Leasehold Flat/Maisonette
N1 6DH - 1,180,000
- Leasehold Flat/Maisonette
N1 6DH - 683,000
- Leasehold Flat/Maisonette
N1 6DH - 1,084,000
- Leasehold Converted flat
N1 6DH - 1,271,000
- Leasehold Flat/Maisonette
N1 6DH - 687,000
- Leasehold Flat/Maisonette
N1 6DH - 623,000
- Feudal Converted flat
N1 6DH - 600,000
- Leasehold Converted flat
N1 6DH - 738,000
- Leasehold Converted flat
N1 6DH - 600,000
- Leasehold Converted flat
N1 6DH - 656,000
- Leasehold Flat/Maisonette
N1 6DH - 663,000
- Leasehold Converted flat
N1 6DH - 1,259,000
- Leasehold Flat/Maisonette
N1 6DH - 580,000
- Leasehold Flat/Maisonette
N1 6DH - 685,000
- Feudal Converted flat
N1 6DH - 728,000
- Leasehold Flat/Maisonette
N1 6DH - 901,000
- Leasehold Converted flat
N1 6DH - 935,000
- Leasehold Purpose built flat
N1 6DH - 905,000
- Leasehold Converted flat
N1 6DH - 1,268,000
- Leasehold Converted flat
N1 6DH - 1,258,000
- Leasehold Flat/Maisonette
N1 6DH - 1,251,000
- Leasehold Flat/Maisonette
N1 6DH - 1,253,000
- Freehold Flat/Maisonette
N1 6DH - 829,000
- Leasehold Converted flat
N1 6DH - 924,000
- Leasehold Flat/Maisonette
N1 6DH - 799,000
- Leasehold Converted flat
N1 6DH - 1,266,000
- Leasehold Flat/Maisonette
N1 6DH - 1,144,000
- Leasehold Flat/Maisonette
N1 6DH - 722,000
- Leasehold Flat/Maisonette
N1 6DH - 685,000
- Leasehold Purpose built flat