The bear is an example of Contra-rotating propellors - twin propellors on a common axis with an opposing spin.

Counter rotating propellors are multi engine aircraft where the left and right engines turn opposite.

I believe all of the Piper twins (Navajo, Semenole etc) were counter rotating. The Cessnas aren't.