SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NW3 5AU' order by fulladdress
NW3 5AU - 3,291,000
- Freehold Semi-detached house
NW3 5AU - 3,763,000
- Freehold Semi-detached house
NW3 5AU - 2,828,000
- Freehold Detached house
NW3 5AU - 4,363,000
- Freehold Semi-detached house
NW3 5AU - 1,685,000
- Freehold Mid terrace house
NW3 5AU - 1,732,000
- Mid terrace house
NW3 5AU - 3,080,000
- Freehold Mid terrace house
NW3 5AU - 2,209,000
- Freehold Terraced
NW3 5AU - 2,124,000
- Freehold Mid terrace house
NW3 5AU - 2,002,000
- Freehold Semi-detached house
NW3 5AU - 1,955,000
- Freehold End terrace house
NW3 5AU - 1,870,000
- Freehold Mid terrace house
NW3 5AU - 1,932,000
- Freehold Mid terrace house
NW3 5AU - 2,029,000
- End terrace house
NW3 5AU - 1,853,000
- Freehold Semi-detached house
NW3 5AU - 2,850,000
- Freehold End terrace house
NW3 5AU - 2,798,000
- Freehold Mid terrace house
NW3 5AU - 2,253,000
- Freehold Semi-detached property
NW3 5AU - 1,982,000
- Freehold Terraced
NW3 5AU - 1,807,000
- Freehold Mid terrace house
NW3 5AU - 1,632,000
- Freehold Mid terrace house
NW3 5AU - 2,544,000
- Leasehold Mid terrace house
NW3 5AU - 2,503,000
- Leasehold Mid terrace house
NW3 5AU - 2,310,000
- Freehold End terrace house
NW3 5AU - 737,000
- Share of freehold Flat/Maisonette
NW3 5AU - 1,563,000
- Leasehold Converted flat
NW3 5AU - 796,000
- Leasehold Converted flat
NW3 5AU - 2,310,000
- Freehold Mid terrace house
NW3 5AU - 4,051,000
- Freehold Terraced
NW3 5AU - 2,437,000
- Mid terrace house
NW3 5AU - 1,917,000
- Leasehold Converted flat
NW3 5AU - 2,430,000
- Semi-detached house
NW3 5AU - 2,379,000
- Freehold Semi-detached house
NW3 5AU - 2,764,000
- Freehold Semi-detached house
NW3 5AU - 2,204,000
- Freehold Mid terrace house
NW3 5AU - 2,300,000
- Freehold Terraced
NW3 5AU - 1,732,000
- Freehold End terrace house