Reconciliation of Tradition - Heaven and Hell

The common message is we go to Heaven when we die. But what does the Bible say? Is Sheol an actual place? What is our actual destination after we die, and how can we be assured where we go?