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 9FG' order by fulladdress
N7 9FG - 565,000
- Leasehold Flat/Maisonette
N7 9FG - 420,000
- Leasehold Purpose built flat
N7 9FG - 572,000
- Leasehold Flat/Maisonette
N7 9FG - 680,000
- Leasehold Flat/Maisonette
N7 9FG - 566,000
- Leasehold Purpose built flat
N7 9FG - 425,000
- Leasehold Flat/Maisonette
N7 9FG - 650,000
- Leasehold Flat/Maisonette
N7 9FG - 566,000
- Leasehold Flat/Maisonette
N7 9FG - 419,000
- Leasehold Flat/Maisonette
N7 9FG - 633,000
- Leasehold Purpose built flat
N7 9FG - 417,000
- Leasehold Flat/Maisonette
N7 9FG - 683,000
- Leasehold Flat/Maisonette
N7 9FG - 596,000
- Leasehold Purpose built flat
N7 9FG - 426,000
- Leasehold Flat/Maisonette
N7 9FG - 431,000
- Leasehold Flat/Maisonette
N7 9FG - 677,000
- Purpose built flat
N7 9FG - 575,000
- Leasehold Purpose built flat
N7 9FG - 537,000
- Leasehold Purpose built flat
N7 9FG - 678,000
- Leasehold Flat/Maisonette
N7 9FG - 443,000
- Leasehold Flat/Maisonette
N7 9FG - 922,000
- Mid terrace house
N7 9FG - 927,000
- Mid terrace house
N7 9FG - 902,000
- Mid terrace house
N7 9FG - 563,000
- Leasehold Purpose built flat
N7 9FG - 592,000
- Leasehold Flat/Maisonette
N7 9FG - 919,000
- Mid terrace house
N7 9FG - 577,000
- Feudal Purpose built flat
N7 9FG - 925,000
- Mid terrace house
N7 9FG - 574,000
- Leasehold Purpose built flat
N7 9FG - 908,000
- Mid terrace house
N7 9FG - 556,000
- Leasehold Purpose built flat
N7 9FG - 913,000
- Mid terrace house
N7 9FG - 610,000
- Leasehold Flat/Maisonette
N7 9FG - 942,000
- Mid terrace house
N7 9FG - 558,000
- Leasehold Purpose built flat
N7 9FG - 593,000
- Leasehold Purpose built flat
N7 9FG - 597,000
- Leasehold Purpose built flat
N7 9FG - 595,000
- Leasehold Purpose built flat
N7 9FG - 578,000
- Leasehold Flat/Maisonette
N7 9FG - 571,000
- Leasehold Purpose built flat