I feel like maybe I've gotten "over-the-hump" with my apartment situation. I spoke to the guy who is moving out of the place in Queens (he's a close friend of my current roommate, but I'm also friendly with him) and finally made arrangements to see the space (tomorrow). I told him I DEFINITELY want to move into the apartment (I don't care what it looks like), and asked him to inform his roommate not to rent the space out to anyone else. He assured me that the place was mine if I wanted it.
I'm not doing any celebrating quite yet. Anything could happen, and I have yet to meet my new roommate, but as of right this moment I feel a little better about what's going on.
Keep your fingers crossed.