SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N8 8RH' order by fulladdress
N8 8RH - 785,000
- Leasehold Converted flat
N8 8RH - 1,740,000
- Freehold Terraced
N8 8RH - 1,992,000
- Freehold Mid terrace house
N8 8RH - 1,941,000
- Freehold Terrace property
N8 8RH - 2,092,000
- Freehold End terrace house
N8 8RH - 661,000
- Share of freehold Flat/Maisonette
N8 8RH - 1,805,000
- Freehold Terraced
N8 8RH - 1,929,000
- Freehold Mid terrace house
N8 8RH - 1,792,000
- Freehold Mid terrace house
N8 8RH - 1,900,000
- Freehold Mid terrace house
N8 8RH - 1,767,000
- Freehold Mid terrace house
N8 8RH - 2,075,000
- Freehold Mid terrace house
N8 8RH - 2,074,000
- Freehold Semi-detached property
N8 8RH - 1,760,000
- Freehold End terrace house
N8 8RH - 1,913,000
- Freehold Mid terrace house
N8 8RH - 1,851,000
- Freehold Mid terrace house
N8 8RH - 1,990,000
- Freehold Terrace property
N8 8RH - 1,744,000
- Freehold Mid terrace house
N8 8RH - 2,010,000
- Freehold Mid terrace house
N8 8RH - 687,000
- Leasehold Flat/Maisonette
N8 8RH - 1,783,000
- Freehold Terrace property
N8 8RH - 2,148,000
- Freehold Mid terrace house
N8 8RH - 2,225,000
- Freehold Terraced
N8 8RH - 2,231,000
- Freehold Semi-detached house
N8 8RH - 2,166,000
- Freehold Semi-detached property
N8 8RH - 2,122,000
- Freehold Semi-detached house
N8 8RH - 2,289,000
- Freehold Semi-detached property
N8 8RH - 1,653,000
- Freehold Mid terrace house
