Heaven, Hell and the Intermediate State

Do we go to heaven when we die? That's what many Christians hope for, but other Christians say that no, we are asleep until the resurrection. No one is in heaven, no one is in hell. What does the Bible say about what we are between death and the resurrection at the return of Christ?