Blink,
Try to hit downtown Raleigh on a Thursday, Friday, or Saturday night. Hit the Glenwood Avenue South Areas (Glenwood Avenue section between Peace Street and Hillsborough Street) Tons of bars, restaurants and night life. There are also pockets of activity down around Moore Square and Parts of Fayetteville street. Some other places in and around downtown to consider checking out:
The
Remedy Diner (tiny restaurant & bar w/ interesting atmosphere)
Boylan Bridge Brewpub (sit outside for a nice view of Downtown)
Raleigh Times Bar (sit inside by a window or outside to people watch)
Morning Times Coffee (go upstairs)
Solas (trendy "upscale" dance club)
Grab some Cue' at
The Pit (nice Bar there too)
Stop by
Seaboard Wine (Free Wine Tasting Sat 12-4)
Helios (
The downtown Coffee Cafe (has beer and wine too & free wifi)
Natty Greens (New Brewpub that opened this week)
Tir Na Nog (Irish Pub in Moore Square)
If you are in town on the frist Friday of the Month check out
Art Space
Another Option
Get in your Car and drive over to Five Points
Grab some Pizza at
Lilly's Pizza
Have some Coffee at
Third Place (http://www.thirdplacecoffee.com/ - broken link)
See a Movie at the
Rialto (http://www.therialto.com/joomla/index.php?option=com_content&task=view&id=16&Itemi d=9 - broken link)
Other Options:
Go to the
Flea Market at noon on Saturday and People Watch (Its HUGE)
Drive a few miles north of downtown and Check out
North Hills (lots of shopping and restaurants)
Visit the
LoneRider Brewery on a Thur, Fri, or Sat and have a pint at their friendly tasting Bar.
For apartments, I would look into places in and around
Cameron Village if you want to be closer to downtown. If you end up needing to be out in the burbs look into places near Lake Lynn around Creedmoor & Lynn Road.
Google "New Raleigh" and "Go Go Raleigh" read these blogs during the months leading up to your visit. You will learn a lot about new things coming to the area and stuff to do.
Good Luck!