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 9SY' order by fulladdress
N7 9SY - 0
- Freehold Semi-detached property
N7 9SY - 427,000
- Leasehold Purpose built flat
N7 9SY - 414,000
- Leasehold Flat/Maisonette
N7 9SY - 391,000
- Leasehold Purpose built flat
N7 9SY - 370,000
- Leasehold Flat/Maisonette
N7 9SY - 354,000
- Leasehold Purpose built flat
N7 9SY - 374,000
- Leasehold Purpose built flat
N7 9SY - 368,000
- Leasehold Flat/Maisonette
N7 9SY - 959,000
- Freehold Semi-detached house
N7 9SY - 364,000
- Leasehold Purpose built flat
N7 9SY - 413,000
- Leasehold Purpose built flat
N7 9SY - 342,000
- Leasehold Purpose built flat
N7 9SY - 380,000
- Leasehold Flat/Maisonette
N7 9SY - 440,000
- Leasehold Purpose built flat
N7 9SY - 413,000
- Leasehold Flat/Maisonette
N7 9SY - 1,021,000
- Freehold Mid terrace house
N7 9SY - 337,000
- Leasehold Purpose built flat
N7 9SY - 350,000
- Leasehold Purpose built flat
N7 9SY - 351,000
- Leasehold Purpose built flat
N7 9SY - 344,000
- Leasehold Flat/Maisonette
N7 9SY - 333,000
- Leasehold Flat/Maisonette
N7 9SY - 352,000
- Leasehold Purpose built flat
N7 9SY - 341,000
- Leasehold Purpose built flat
N7 9SY - 329,000
- Leasehold Purpose built flat
N7 9SY - 951,000
- Freehold Semi-detached property
N7 9SY - 298,000
- Leasehold Purpose built flat
N7 9SY - 346,000
- Leasehold Purpose built flat
N7 9SY - 342,000
- Leasehold Flat/Maisonette
N7 9SY - 361,000
- Leasehold Purpose built flat
N7 9SY - 334,000
- Leasehold Purpose built flat
N7 9SY - 344,000
- Leasehold Purpose built flat
N7 9SY - 350,000
- Leasehold Flat/Maisonette
N7 9SY - 315,000
- Leasehold Purpose built flat
N7 9SY - 345,000
- Leasehold Purpose built flat
N7 9SY - 565,000
- Freehold Flat/Maisonette
N7 9SY - 388,000
- Leasehold Purpose built flat