SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N7 9UP' order by fulladdress
N7 9UP - 393,000
- Leasehold Purpose built flat
N7 9UP - 481,000
- Leasehold Purpose built flat
N7 9UP - 524,000
- Leasehold Purpose built flat
N7 9UP - 566,000
- Leasehold Purpose built flat
N7 9UP - 490,000
- Leasehold Purpose built flat
N7 9UP - 349,000
- Leasehold Flat/Maisonette
N7 9UP - 328,000
- Leasehold Purpose built flat
N7 9UP - 364,000
- Leasehold Purpose built flat
N7 9UP - 371,000
- Leasehold Flat/Maisonette
N7 9UP - 332,000
- Leasehold Purpose built flat
N7 9UP - 341,000
- Leasehold Terrace property
N7 9UP - 480,000
- Leasehold Purpose built flat
N7 9UP - 579,000
- Leasehold Purpose built flat
N7 9UP - 499,000
- Leasehold Flat/Maisonette
N7 9UP - 593,000
- Leasehold Semi-detached property
N7 9UP - 506,000
- Leasehold Purpose built flat
N7 9UP - 509,000
- Leasehold Purpose built flat
N7 9UP - 481,000
- Leasehold Purpose built flat
N7 9UP - 352,000
- Leasehold Flat/Maisonette
N7 9UP - 349,000
- Leasehold Purpose built flat
N7 9UP - 346,000
- Leasehold Flat/Maisonette
N7 9UP - 316,000
- Leasehold Purpose built flat
N7 9UP - 346,000
- Leasehold Purpose built flat
N7 9UP - 330,000
- Leasehold Purpose built flat
N7 9UP - 327,000
- Leasehold Purpose built flat
N7 9UP - 343,000
- Leasehold Flat/Maisonette
N7 9UP - 372,000
- Freehold Flat/Maisonette
N7 9UP - 348,000
- Leasehold Terrace property
N7 9UP - 457,000
- Freehold Flat/Maisonette
N7 9UP - 473,000
- Leasehold Purpose built flat
N7 9UP - 577,000
- Leasehold Purpose built flat
N7 9UP - 609,000
- Leasehold Semi-detached house
N7 9UP - 473,000
- Leasehold Flat/Maisonette
N7 9UP - 511,000
- Leasehold Purpose built flat