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 8GH' order by fulladdress
N1 8GH - 1,231,000
- Leasehold Flat/Maisonette
N1 8GH - 1,381,000
- Leasehold Flat/Maisonette
N1 8GH - 1,392,000
- Leasehold Flat/Maisonette
N1 8GH - 1,341,000
- Leasehold Purpose built flat
N1 8GH - 1,427,000
- Leasehold Flat/Maisonette
N1 8GH - 1,175,000
- Leasehold Purpose built flat
N1 8GH - 1,300,000
- Leasehold Flat/Maisonette
N1 8GH - 1,202,000
- Leasehold Purpose built flat
N1 8GH - 1,260,000
- Leasehold Flat/Maisonette
N1 8GH - 1,214,000
- Flat/Maisonette
N1 8GH - 1,013,000
- Leasehold Flat/Maisonette
N1 8GH - 1,201,000
- Leasehold Flat/Maisonette
N1 8GH - 1,345,000
- Leasehold Flat/Maisonette
N1 8GH - 1,311,000
- Leasehold Flat/Maisonette
N1 8GH - 1,130,000
- Leasehold Flat/Maisonette
N1 8GH - 1,215,000
- Leasehold Purpose built flat
N1 8GH - 1,215,000
- Leasehold Purpose built flat
N1 8GH - 1,348,000
- Leasehold Purpose built flat
N1 8GH - 1,349,000
- Leasehold Flat/Maisonette
N1 8GH - 1,367,000
- Leasehold Flat/Maisonette
N1 8GH - 1,466,000
- Leasehold Purpose built flat
N1 8GH - 1,369,000
- Leasehold Flat/Maisonette
N1 8GH - 1,170,000
- Leasehold Purpose built flat
N1 8GH - 1,166,000
- Leasehold Flat/Maisonette
N1 8GH - 1,066,000
- Leasehold Purpose built flat
N1 8GH - 1,278,000
- Leasehold Flat/Maisonette
N1 8GH - 1,737,000
- Leasehold Purpose built flat
N1 8GH - 1,080,000
- Leasehold Flat/Maisonette
N1 8GH - 1,098,000
- Leasehold Flat/Maisonette
N1 8GH - 1,218,000
- Leasehold Flat/Maisonette
N1 8GH - 1,042,000
- Leasehold Purpose built flat
N1 8GH - 1,062,000
- Leasehold Purpose built flat
N1 8GH - 1,175,000
- Leasehold Flat/Maisonette
N1 8GH - 1,019,000
- Leasehold Flat/Maisonette
N1 8GH - 1,079,000
- Leasehold Flat/Maisonette
N1 8GH - 1,141,000
- Leasehold Purpose built flat
N1 8GH - 1,271,000
- Leasehold Flat/Maisonette
N1 8GH - 1,149,000
- Leasehold Purpose built flat
N1 8GH - 1,147,000
- Leasehold Flat/Maisonette
N1 8GH - 1,087,000
- Leasehold Flat/Maisonette
N1 8GH - 1,000,000
- Leasehold Flat/Maisonette
N1 8GH - 1,121,000
- Leasehold Flat/Maisonette
N1 8GH - 1,003,000
- Leasehold Flat/Maisonette
N1 8GH - 1,688,000
- Leasehold Purpose built flat
N1 8GH - 1,005,000
- Leasehold Flat/Maisonette
N1 8GH - 992,000
- Leasehold Flat/Maisonette
N1 8GH - 1,001,000
- Leasehold Flat/Maisonette
N1 8GH - 990,000
- Leasehold Flat/Maisonette
N1 8GH - 989,000
- Leasehold Flat/Maisonette
N1 8GH - 992,000
- Leasehold Flat/Maisonette
N1 8GH - 984,000
- Leasehold Flat/Maisonette
N1 8GH - 1,026,000
- Leasehold Flat/Maisonette
N1 8GH - 1,227,000
- Leasehold Purpose built flat
N1 8GH - 1,174,000
- Leasehold Flat/Maisonette
N1 8GH - 1,348,000
- Leasehold Flat/Maisonette
N1 8GH - 1,247,000
- Leasehold Purpose built flat
