Don't give up before you've started! I didn't have the best GPA either; before I was able to "erase" some of my old F's and W's from my transcript, I think I recall my GPA being around 2.5 or 2.7. After they were erased, it went up to 3.2 or somewhere around there.
I applied everywhere in CA, although my GPA did limit my choices somewhat. I was willing to move if I got in somewhere down in the LA area as my dad lives in Chino. Finally, after 4 years of waiting, I got into a local JC. I was working on a back up plan just in case because 4 years is a ridiculous amount of time to wait. I got myself on another JC's xray tech program waiting list and I was taking a couple more pre-reqs to gain entrance into yet another JC's new ultrasound tech program so I don't think it's a bad idea to start other avenues just in case you end up waiting as long as I did. On the first day of nursing school, the profs asked who waited the longest to get in - guess who won?
BUT, I didn't even need to go there because I finally got in and here I am two years later, a newly minted RN (albeit unemployed as an RN). You mentioned you want your BSN which is smart, I wish I would've had the forethought to get better grades to make it into a BSN program. Unfortunately for me, to get into my local state college (Sacramento State), I would've had to have darn near perfect grades and TEAS score to get accepted.
Good luck to you! Don't give up and really, really try to hang in there. If you put your mind to it, it will happen one day but you have to be hungry for it!