So I normally use OSX's iterm which has tabs built in, however Windows doesn't have this nice feature. But I found a passable solution and the answer is Console2. To get this up and running you need 2 things:
Cygwin (x86 version) : http://www.cygwin.com/
Console2 : http://sourceforge.net/projects/console
So to get started, install Cygwin and any extra packages you want (I recommend getting zsh over bash but will cover both).
When that is completed, unzip Console2. There is no installer for this so move it to any place you want. Fire up Console2 and you will be greeted with the ugly cmd prompt from good old windows. To get Cygwin up and running Console2, go to Edit-->Settings-->Tabs. Click add and a new tab profile will be created. Under Main you can give it a name (Mine is Cygwin), give it a custom icon if you want. The important part you need to edit is under Shell. You want to browse your cygwin shell executable. If using bash it's <cygwin path>\bin\bash.exe or zsh.exe if you're using zsh. Click open and then edit the line to pass some arguments to get it to load up correctly. Bash should look like this:
<cygwin path>\bin\bash.exe -login -i and zsh should look like this: <cygwin path>\bin\zsh -l -i.
Move your newly created tab up or down, top one is what starts when you load Console2. Hit ok and you should be good to go with a new tabbed terminal in windows.