Should you buy property or invest in Castlecrag or Middle Cove on Sydney’s lower north shore? Here’s why these areas have so much appeal.