I would suggest talking to an advisor for pre-nursing, or someone in the nursing program directly. In addition to ace'ing the next three semesters (which is totally do-able if you put your mind and effort into it

), they may be able to suggest other ways to make your application more appealing. I think that getting some work experience as a CNA is a great idea. There may be other things you can do that would increase your chances. I would also write a kick-butt essay when you apply
anywhere (whether it's required or not), that expresses your desire to be in the school, why you may have had trouble in the past, and what you are doing that would make you a good nursing student for their program. Unfortunately, it will ultimately depend not on just how well you present yourself, but what's also on paper. Don't fret, though. My friend applied to the program I'm in now with a 2.9 from a previous degree, got all A's and B's in her pre-req's (anatomy in the summer, no less!), and was waitlisted for the spring. I know that's not
exactly what you wanted to hear, but she was appealing enough that they gave her a chance!! Also, don't limit yourself to one school. If you are going to finish your first degree, go ahead and apply to several programs, accelerated second degree as well as ADN. You'll give yourself a better chance of getting into
one if them. Also, it's just my two cents, but I would
try to get into a BSN program before resorting to a community college.
Not because one is better or worse, but because you've already done all the work to get the bachelor's degree, and why not try to get a second one in nursing?!? It's the same length of time to become an RN (pretty much) no matter what type of school you go through. I am working on my second bachelor's in nursing now, and I love it!
Best of luck to you, and keep your eye on the prize!