How do I make this decision?

I am so conflicted right now. I feel like I’m either going to have to make a decision that’s going to leave me heartbroken or decide to stay in an area that isn’t the most supportive of me except for my best friend. The opportunity in Charleston is looking more and more realistic, the only thing stopping it is if the negotiations with the seller of the company go bad. But that means I will have to leave Knoxville, I’m not tied to the area. But I made the most amazing friend here. I've cried so many times when I think about leaving. I’m being pulled in two directions and I don’t know what’s right for me. im not working at the moment so an opportunity would be nice and Charleston is offering that but I could get a job here and be ok. How do I decide?