Here is the classic skateboard game you've been looking for. This Nintendo 64 Game Cartridge is the one for you - Tony Hawk's Pro Skater.
This auction is for one (1) Nintendo N64 Game Cartridge Only (Tony Hawk's Pro Skater) - no Manual. The game looks and works great, but it does show normal signs of wear (fading from sticker on both sides of the front, and some residual permanent marker writing on top) - see photos.
It's in good condition and works perfectly, ready to take you on an adventurous skateboard ride. Remember the good old times with this, one of the most iconic games of all time.