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 7AY' order by fulladdress
N1 7AY - 758,000
- Leasehold Purpose built flat
N1 7AY - 1,600,000
- Freehold Mid terrace house
N1 7AY - 943,000
- Feudal Converted flat
N1 7AY - 697,000
- Leasehold Converted flat
N1 7AY - 871,000
- Leasehold Flat/Maisonette
N1 7AY - 1,725,000
- Freehold Mid terrace house
N1 7AY - 1,618,000
- Freehold Mid terrace house
N1 7AY - 1,600,000
- Freehold Mid terrace house
N1 7AY - 1,894,000
- Freehold Terraced
N1 7AY - 834,000
- Leasehold Purpose built flat
N1 7AY - 1,474,000
- Semi-detached house
N1 7AY - 1,441,000
- Mid terrace house
N1 7AY - 1,439,000
- Mid terrace house
N1 7AY - 1,437,000
- Mid terrace house
N1 7AY - 1,457,000
- Mid terrace house
N1 7AY - 1,455,000
- Mid terrace house
N1 7AY - 1,448,000
- Mid terrace house
N1 7AY - 1,446,000
- Mid terrace house
N1 7AY - 1,421,000
- Mid terrace house
N1 7AY - 1,418,000
- Mid terrace house
N1 7AY - 1,154,000
- Feudal Converted flat
N1 7AY - 519,000
- Leasehold Flat/Maisonette
N1 7AY - 641,000
- Leasehold Flat/Maisonette
N1 7AY - 512,000
- Leasehold Flat/Maisonette
N1 7AY - 434,000
- Leasehold Flat/Maisonette
N1 7AY - 500,000
- Leasehold Purpose built flat
N1 7AY - 808,000
- Leasehold Flat/Maisonette
N1 7AY - 525,000
- Leasehold Purpose built flat
N1 7AY - 664,000
- Leasehold Flat/Maisonette
N1 7AY - 517,000
- Leasehold Purpose built flat
N1 7AY - 463,000
- Leasehold Purpose built flat
N1 7AY - 510,000
- Feudal Flat/Maisonette
N1 7AY - 559,000
- Leasehold Flat/Maisonette
N1 7AY - 530,000
- Leasehold Flat/Maisonette
N1 7AY - 843,000
- Leasehold Purpose built flat
N1 7AY - 530,000
- Leasehold Flat/Maisonette
N1 7AY - 535,000
- Leasehold Purpose built flat
N1 7AY - 513,000
- Leasehold Purpose built flat
N1 7AY - 470,000
- Leasehold Flat/Maisonette
N1 7AY - 501,000
- Leasehold Purpose built flat
N1 7AY - 816,000
- Leasehold Flat/Maisonette
N1 7AY - 526,000
- Leasehold Flat/Maisonette
N1 7AY - 500,000
- Leasehold Flat/Maisonette
N1 7AY - 471,000
- Leasehold Purpose built flat
N1 7AY - 579,000
- Leasehold Converted flat
N1 7AY - 528,000
- Leasehold Purpose built flat
N1 7AY - 512,000
- Leasehold Purpose built flat
N1 7AY - 835,000
- Leasehold Purpose built flat
N1 7AY - 640,000
- Leasehold Converted flat
N1 7AY - 695,000
- Leasehold Flat/Maisonette
N1 7AY - 639,000
- Leasehold Converted flat
N1 7AY - 512,000
- Leasehold Flat/Maisonette
N1 7AY - 842,000
- Feudal Converted flat
N1 7AY - 472,000
- Leasehold Flat/Maisonette
N1 7AY - 502,000
- Leasehold Purpose built flat
N1 7AY - 806,000
- Leasehold Flat/Maisonette
N1 7AY - 525,000
- Leasehold Flat/Maisonette
