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 8ND' order by fulladdress
N1 8ND - 761,000
- Leasehold Converted flat
N1 8ND - 700,000
- Leasehold Purpose built flat
N1 8ND - 772,000
- Leasehold Flat/Maisonette
N1 8ND - 663,000
- Leasehold Purpose built flat
N1 8ND - 839,000
- Leasehold Flat/Maisonette
N1 8ND - 702,000
- Leasehold Purpose built flat
N1 8ND - 818,000
- Leasehold Flat/Maisonette
N1 8ND - 576,000
- Leasehold Flat/Maisonette
N1 8ND - 614,000
- Leasehold Flat/Maisonette
N1 8ND - 910,000
- Leasehold End terrace house
N1 8ND - 762,000
- Freehold Purpose built flat
N1 8ND - 673,000
- Leasehold Flat/Maisonette
N1 8ND - 674,000
- Leasehold Purpose built flat
N1 8ND - 850,000
- Leasehold Purpose built flat
N1 8ND - 507,000
- Feudal Purpose built flat
N1 8ND - 702,000
- Leasehold Flat/Maisonette
N1 8ND - 679,000
- Feudal Purpose built flat
N1 8ND - 746,000
- Leasehold Flat/Maisonette
N1 8ND - 654,000
- Leasehold Purpose built flat
N1 8ND - 537,000
- Leasehold Purpose built flat
N1 8ND - 701,000
- Leasehold Purpose built flat
N1 8ND - 694,000
- Leasehold Flat/Maisonette
N1 8ND - 585,000
- Leasehold Flat/Maisonette
N1 8ND - 568,000
- Leasehold Purpose built flat
N1 8ND - 582,000
- Leasehold Flat/Maisonette
N1 8ND - 537,000
- Leasehold Flat/Maisonette
N1 8ND - 499,000
- Leasehold Purpose built flat
N1 8ND - 578,000
- Leasehold Purpose built flat
N1 8ND - 593,000
- Leasehold Purpose built flat
N1 8ND - 409,000
- Leasehold Flat/Maisonette
N1 8ND - 802,000
- Leasehold Flat/Maisonette
N1 8ND - 489,000
- Leasehold Purpose built flat
N1 8ND - 491,000
- Leasehold Purpose built flat
N1 8ND - 506,000
- Leasehold Flat/Maisonette