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 5QU' order by fulladdress
N6 5QU - 1,456,000
- Freehold Semi-detached house
N6 5QU - 1,678,000
- Freehold Semi-detached house
N6 5QU - 1,731,000
- Semi-detached house
N6 5QU - 1,464,000
- Freehold Semi-detached house
N6 5QU - 1,588,000
- Freehold Semi-detached house
N6 5QU - 1,625,000
- Freehold Terrace property
N6 5QU - 1,668,000
- Freehold Semi-detached house
N6 5QU - 1,506,000
- Freehold Semi-detached house
N6 5QU - 1,626,000
- Freehold Semi-detached house
N6 5QU - 1,695,000
- Freehold Semi-detached property
N6 5QU - 1,672,000
- Freehold Semi-detached house
N6 5QU - 1,739,000
- Freehold Semi-detached property
N6 5QU - 1,855,000
- Freehold Semi-detached house
N6 5QU - 1,697,000
- Freehold Semi-detached property
N6 5QU - 1,874,000
- Freehold Semi-detached house
N6 5QU - 1,999,000
- Freehold Detached house
N6 5QU - 1,969,000
- Freehold Semi-detached house
N6 5QU - 2,071,000
- Freehold Semi-detached house
N6 5QU - 1,795,000
- Freehold Semi-detached house
N6 5QU - 1,643,000
- Freehold Semi-detached house
N6 5QU - 1,777,000
- Freehold Semi-detached house
N6 5QU - 1,958,000
- Freehold Semi-detached house
N6 5QU - 1,880,000
- Freehold Semi-detached house
N6 5QU - 2,029,000
- Freehold Semi-detached property
