SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N2 9BX' order by fulladdress
N2 9BX - 1,308,000
- Freehold End terrace house
N2 9BX - 1,455,000
- Freehold End terrace house
N2 9BX - 1,296,000
- Mid terrace property
N2 9BX - 1,310,000
- Freehold Mid terrace house
N2 9BX - 1,407,000
- Freehold End terrace house
N2 9BX - 1,289,000
- Freehold Semi-detached house
N2 9BX - 1,381,000
- Freehold Semi-detached house
N2 9BX - 1,376,000
- Freehold Mid terrace house
N2 9BX - 1,341,000
- Freehold Mid terrace house
N2 9BX - 1,152,000
- Freehold Mid terrace house
N2 9BX - 1,348,000
- Freehold Terraced
N2 9BX - 1,275,000
- Freehold Terraced
N2 9BX - 1,251,000
- Freehold Mid terrace house
N2 9BX - 1,223,000
- Mid terrace house
N2 9BX - 506,000
- Leasehold Purpose built flat
N2 9BX - 543,000
- Leasehold Converted flat
N2 9BX - 1,463,000
- Freehold Semi-detached house
N2 9BX - 1,324,000
- Freehold Semi-detached house
N2 9BX - 1,265,000
- Freehold End terrace house
N2 9BX - 1,314,000
- Freehold Mid terrace house
N2 9BX - 1,389,000
- Freehold Mid terrace house
N2 9BX - 1,389,000
- Freehold Mid terrace house
N2 9BX - 1,245,000
- Freehold Mid terrace house
N2 9BX - 1,357,000
- Freehold Mid terrace house
N2 9BX - 1,332,000
- Freehold End terrace house
N2 9BX - 1,342,000
- Freehold Mid terrace house
N2 9BX - 1,410,000
- Freehold Terrace property
N2 9BX - 1,454,000
- Freehold Mid terrace house
N2 9BX - 1,326,000
- Freehold Terraced
N2 9BX - 1,246,000
- Freehold Mid terrace house
N2 9BX - 1,267,000
- Mid terrace house
N2 9BX - 1,408,000
- Freehold Terrace property
N2 9BX - 1,410,000
- Freehold Mid terrace house
N2 9BX - 1,178,000
- Freehold Semi-detached property
N2 9BX - 1,262,000
- Freehold Mid terrace house
N2 9BX - 1,366,000
- Freehold Mid terrace house
N2 9BX - 1,359,000
- Freehold End terrace house
N2 9BX - 1,305,000
- Freehold End terrace house
N2 9BX - 1,323,000
- Mid terrace house
N2 9BX - 1,413,000
- Freehold Semi-detached property
N2 9BX - 1,243,000
- Freehold Mid terrace house
N2 9BX - 639,000
- Leasehold Flat/Maisonette
N2 9BX - 1,428,000
- Freehold Semi-detached house
N2 9BX - 1,439,000
- Freehold Semi-detached house
