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 7EW' order by fulladdress
N1 7EW - 631,000
- Leasehold Purpose built flat
N1 7EW - 870,000
- Leasehold Flat/Maisonette
N1 7EW - 701,000
- Leasehold Flat/Maisonette
N1 7EW - 879,000
- Leasehold Purpose built flat
N1 7EW - 925,000
- Leasehold Purpose built flat
N1 7EW - 982,000
- Leasehold Flat/Maisonette
N1 7EW - 913,000
- Leasehold Purpose built flat
N1 7EW - 686,000
- Leasehold Purpose built flat
N1 7EW - 895,000
- Leasehold Flat/Maisonette
N1 7EW - 678,000
- Leasehold Purpose built flat
N1 7EW - 939,000
- Feudal Purpose built flat
N1 7EW - 911,000
- Leasehold Purpose built flat
N1 7EW - 898,000
- Leasehold Flat/Maisonette
N1 7EW - 825,000
- Leasehold Flat/Maisonette
N1 7EW - 696,000
- Leasehold Flat/Maisonette
N1 7EW - 871,000
- Leasehold Purpose built flat
N1 7EW - 790,000
- Leasehold Flat/Maisonette
N1 7EW - 839,000
- Leasehold Purpose built flat
N1 7EW - 861,000
- Leasehold Flat/Maisonette
N1 7EW - 877,000
- Leasehold Flat/Maisonette
N1 7EW - 917,000
- Leasehold Flat/Maisonette
N1 7EW - 1,019,000
- Flat/Maisonette
N1 7EW - 762,000
- Leasehold Flat/Maisonette
N1 7EW - 929,000
- Leasehold Flat/Maisonette
N1 7EW - 677,000
- Leasehold Flat/Maisonette
N1 7EW - 949,000
- Leasehold Flat/Maisonette
N1 7EW - 963,000
- Leasehold Flat/Maisonette
N1 7EW - 943,000
- Leasehold Flat/Maisonette
N1 7EW - 898,000
- Leasehold Purpose built flat
N1 7EW - 944,000
- Feudal Converted flat
N1 7EW - 1,027,000
- Feudal Purpose built flat
N1 7EW - 959,000
- Feudal Purpose built flat
N1 7EW - 801,000
- Leasehold Purpose built flat
N1 7EW - 978,000
- Leasehold Purpose built flat
N1 7EW - 835,000
- Leasehold Flat/Maisonette
N1 7EW - 692,000
- Leasehold Flat/Maisonette
N1 7EW - 897,000
- Leasehold Flat/Maisonette
N1 7EW - 955,000
- Leasehold Flat/Maisonette
N1 7EW - 886,000
- Leasehold Flat/Maisonette
N1 7EW - 890,000
- Leasehold Purpose built flat
N1 7EW - 1,638,000
- Feudal Flat/Maisonette
N1 7EW - 691,000
- Leasehold Purpose built flat
N1 7EW - 799,000
- Leasehold Flat/Maisonette
N1 7EW - 983,000
- Leasehold Flat/Maisonette
N1 7EW - 1,317,000
- Leasehold Flat/Maisonette
N1 7EW - 712,000
- Leasehold Flat/Maisonette
N1 7EW - 727,000
- Leasehold Flat/Maisonette
N1 7EW - 837,000
- Leasehold Purpose built flat
N1 7EW - 1,132,000
- Leasehold Flat/Maisonette
N1 7EW - 1,018,000
- Leasehold Flat/Maisonette
N1 7EW - 1,037,000
- Leasehold Purpose built flat
N1 7EW - 676,000
- Leasehold Purpose built flat
N1 7EW - 780,000
- Leasehold Flat/Maisonette
N1 7EW - 1,109,000
- Leasehold Flat/Maisonette
N1 7EW - 1,684,000
- Leasehold Flat/Maisonette
N1 7EW - 963,000
- Leasehold Purpose built flat
N1 7EW - 968,000
- Leasehold Flat/Maisonette
N1 7EW - 1,911,000
- Leasehold Flat/Maisonette
N1 7EW - 1,991,000
- Leasehold Flat/Maisonette
N1 7EW - 1,739,000
- Leasehold Flat/Maisonette
N1 7EW - 2,072,000
- Leasehold Flat/Maisonette
N1 7EW - 1,129,000
- Leasehold Flat/Maisonette
