SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='N5 1TZ' order by fulladdress
N5 1TZ - 2,353,000
- Freehold End terrace house
N5 1TZ - 1,803,000
- Terrace property
N5 1TZ - 686,000
- Leasehold Converted flat
N5 1TZ - 2,163,000
- Freehold End terrace house
N5 1TZ - 2,271,000
- Freehold Terraced
N5 1TZ - 2,137,000
- Freehold Mid terrace house
N5 1TZ - 2,067,000
- Freehold Mid terrace house
N5 1TZ - 2,062,000
- Freehold Mid terrace house
N5 1TZ - 2,197,000
- Freehold Mid terrace house
N5 1TZ - 820,000
- Leasehold Converted flat
N5 1TZ - 2,056,000
- Freehold Mid terrace house
N5 1TZ - 902,000
- Leasehold Converted flat
N5 1TZ - 2,040,000
- Freehold Terraced
N5 1TZ - 844,000
- Leasehold Converted flat
N5 1TZ - 2,078,000
- Freehold Mid terrace house
N5 1TZ - 1,033,000
- Leasehold Mid terrace house
N5 1TZ - 2,027,000
- Freehold End terrace house
N5 1TZ - 1,028,000
- Flat/Maisonette
N5 1TZ - 2,087,000
- Freehold Mid terrace house
N5 1TZ - 2,039,000
- Freehold Mid terrace house
N5 1TZ - 2,050,000
- Freehold Mid terrace house
N5 1TZ - 2,090,000
- Freehold Mid terrace house
N5 1TZ - 1,050,000
- Flat/Maisonette
N5 1TZ - 971,000
- Leasehold Converted flat
N5 1TZ - 876,000
- Leasehold Converted flat
N5 1TZ - 956,000
- Leasehold Converted flat
N5 1TZ - 846,000
- Leasehold Converted flat
N5 1TZ - 730,000
- Leasehold Converted flat
N5 1TZ - 715,000
- Leasehold Flat/Maisonette
N5 1TZ - 613,000
- Leasehold Converted flat
N5 1TZ - 593,000
- Leasehold Converted flat
N5 1TZ - 2,083,000
- Mid terrace property
N5 1TZ - 1,071,000
- Leasehold Converted flat
