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 9BJ' order by fulladdress
N2 9BJ - 2,985,000
- Freehold Detached house
N2 9BJ - 3,177,000
- Freehold Detached house
N2 9BJ - 2,420,000
- Freehold Detached house
N2 9BJ - 3,032,000
- Freehold Detached house
N2 9BJ - 2,349,000
- Freehold Semi-detached house
N2 9BJ - 2,637,000
- Freehold Detached house
N2 9BJ - 1,923,000
- Freehold Terraced
N2 9BJ - 2,190,000
- Freehold Semi-detached house
N2 9BJ - 2,573,000
- Freehold Detached house
N2 9BJ - 2,987,000
- Freehold Detached house
N2 9BJ - 1,703,000
- Semi-detached house
N2 9BJ - 1,990,000
- Freehold Semi-detached house
N2 9BJ - 1,774,000
- Freehold Semi-detached house
N2 9BJ - 1,793,000
- Freehold Semi-detached house
N2 9BJ - 1,508,000
- Freehold Semi-detached house
N2 9BJ - 2,221,000
- Freehold Semi-detached house
N2 9BJ - 1,568,000
- Semi-detached house
N2 9BJ - 2,515,000
- Freehold Detached house
N2 9BJ - 2,280,000
- Freehold Semi-detached house
N2 9BJ - 1,963,000
- Freehold Semi-detached house
N2 9BJ - 1,243,000
- Feudal Converted flat
N2 9BJ - 631,000
- Leasehold Flat/Maisonette
N2 9BJ - 574,000
- Leasehold Converted flat
