Welcome JBuck!
My story isn't all that encouraging, but I'll share it anyway...I'm still hoping it'll have a happy ending!
I got my agent (actually, three offers of rep) very quickly for my first completed ms. And...then it didn't sell. We did three rounds with pubs (each lasting about two months) and no luck. It seemed more a trend/timing thing and rather than do a lot of revision or continue to sub we decided to retire it because I'd started writing a second book. Three or four months after ms 1 was retired, we went out on sub with ms 2. And...it didn't sell. Two rounds on that one, but again, by the time it wasn't looking good I was already well into writing ms 3, which I was IN LOVE WITH. It felt like it had all the pieces I needed - commercial premise, interesting characters, series potential, fun world-building...AND it took something I was struggling with at the time - my husband's deployment - and turned it into a fun YA adventure (with some war drama thrown in). And I realized THIS was the book I wanted to commit to. I revised/rewrote it over the course of 9 months (longer by far than I spent on the other two) and then we did a small "practice" sub round. Got a lot of feedback (though not the kind I had been hoping for) and all no's. My agent suggested working with a professional editor (my agent isn't editorial). Which I did. (And it was GREAT.) And now we're on sub again. And I try every single day not to completely freak out. :-/
It's been about three weeks, with one no so far. I'm so invested in this book I've found it hard to concentrate on writing anything else, so the waiting is really starting to get to me. But I'm determined to do nano (two of my three mss were written as nano first drafts), so hopefully that will distract me!
I'm still hoping this is going to be THE ONE. I know *I'm* determined to do whatever I can, whether that means more revisions, or going to mid-sized or smaller presses.
So anyway...hang in there! And big hugs to Miss Plum and Mid. This industry does its damnedest to kill all our hopes and dreams. But we just can't let it!