Good question. I hesitate giving an answer because I am no theologian, but here is my humble opinion as a Christian. Sin is sin in the sense that it all separates us from God. From murder to theft to lying, God cannot tolerate it. BUT a person is able to accept the gift of Mercy which is the payment of debt that Jesus made on our behalf with his death. Anyone can accept it. Now, just because a person does this, does not mean that he ceases to sin. But a true believer will sense a conviction in his soul. Seeing as I do see homosexuality as a sin, I feel that, eventually, a homosexual Christian would feel that their lifestyle is not right. However, we are humans and we will sin. It is human nature to live in rebellion, even denial. Every Christian will die having sinned.
So, in my opinion, if a person has truly accepted the gift of salvation through Jesus, they will got to heaven when they die.
I'm sure there are those who will disagree. But I see no difference in someone dying as a homosexual, an adulterer, or dying with pride in their heart.
I am not trying to be inflammatory, I just wanted to offer my opinion. I cannot judge a person's heart.
This would have been a good forum post. I'm sure a lot of people will want to go back and forth on this issue.