Hey, Jerry! Sorry to hear about your friend. I know you have known him for ten years online, but, I think that is what is the keyword: online. He had things that you never knew about and in some ways, I think everything works out the way it is supposed to. I know it doesn't seem like that now, but, it will.
I hope something falls into your lap, but, you need to prepare yourself so you will be ready. It is hard to get back on that wagon once you jump off, but, you don't want a great roommate to be turned off by the drinking.
I love your house, it looks so nice and has lots of space. You have really made it comfortable inside. I truly wish you luck.