You have to go out of the door by the altar to get to the house. After the cut-scene where you find out he isn't there anymore, the door should be kind of in front of you to the right. Follow this guide for more info: The Quarter Moon Murders Case Guide
