SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N6 5HL' order by fulladdress
N6 5HL - 2,275,000
- Freehold Mid terrace house
N6 5HL - 2,250,000
- Freehold Mid terrace house
N6 5HL - 2,413,000
- Freehold Terraced
N6 5HL - 2,251,000
- Freehold Semi-detached house
N6 5HL - 2,073,000
- Freehold Mid terrace house
N6 5HL - 2,200,000
- Freehold Mid terrace house
N6 5HL - 2,047,000
- Freehold Mid terrace house
N6 5HL - 2,300,000
- Freehold Terraced
N6 5HL - 2,388,000
- Freehold Mid terrace house
N6 5HL - 2,400,000
- Freehold Mid terrace house
N6 5HL - 2,203,000
- Freehold Terraced
N6 5HL - 2,058,000
- Freehold Mid terrace house
N6 5HL - 1,980,000
- Freehold End terrace house
N6 5HL - 2,263,000
- Freehold Terrace property
N6 5HL - 2,252,000
- Freehold Mid terrace house
N6 5HL - 2,207,000
- Freehold Semi-detached house
N6 5HL - 2,288,000
- Freehold Mid terrace house
N6 5HL - 2,288,000
- Mid terrace house
N6 5HL - 2,638,000
- Freehold Semi-detached house
N6 5HL - 3,616,000
- Freehold Semi-detached house
N6 5HL - 3,637,000
- Freehold Semi-detached house
N6 5HL - 2,895,000
- Freehold Semi-detached property
N6 5HL - 537,000
- Freehold Flat/Maisonette
N6 5HL - 3,499,000
- Freehold Semi-detached house
N6 5HL - 2,319,000
- Mid terrace house
N6 5HL - 608,000
- Leasehold Flat/Maisonette
N6 5HL - 765,000
- Leasehold Converted flat
N6 5HL - 2,086,000
- Freehold Semi-detached house
N6 5HL - 835,000
- Leasehold Converted flat
N6 5HL - 658,000
- Leasehold Converted flat
