The plot involves a man who makes a bet with his friends that he can spend the night alone in a haunted house. He doesn't make it through the night and tries to run out the front gate. The next morning, his friends find him waiting for them at the front gate --- but he is actually impaled and dead hanging on the gate.

Cannot remember the title of this memorable horror film from my childhood. Help, horror movie fans!

House of Usher?

No. Not a Poe story - more modern setting.

Sounds like Castle of Blood (http://www.hermenaut.com/a95.shtml).