Well, I live in the mountains near Boulder and I am NOT a member of The United Republic of Boulder, or a screamimg liberal.
Boulder is about 50 miles from Denver Intl Airport (DIA) and about 30 miles from Denver.
Yes, we have our yuppies and our hippies and horrendous traffic.
We have four seasons, almost Winter, Winter, still Winter and Construction season...now playing.
There is a new mall being constucted off of Hwy 36 and road work EVERYWHERE.
The Farmer's market happens every weekend and the kite shop (Into the Wind) is still there on the Pearl Street Mall, well worth a visit as are several other "older" shops.
As for food there is lots, some even good.
Tom's Bar and Grill at the west end of Pearl Street makes a great burger.
Lots of Italian, Baccaro is good and on Pearl street too.
The Med (The Mediterranean) is diverse, as mentioned, lots of good bars and grills all around downtown.
There is Sushi and even a Cheesecake Factory which serves everything.
14th Street and Red Dog are yuppie kinda places (if you like that...and I'm not askin).
Illegal Pete's makes killer burritos at the East end of the Pearl Street Mall.
Fat Tire has my vote for the best CO beer and the brewery is just up the road near Fort Collins (
http://www.newbelgium.com/visitus.php)
I'm just not a Coors fan.
Rocky Mountain National Park is 45 minutes to the north via Hwy 36 through Estes Park, a cute artsy-craftsy-touristy town with some excellent custom knife makers.
There are plenty of great trails in and around Boulder itself, the Anne U. White trail is just north of the city, easy, 3 miles round trip (or any length you want to make it) (
http://www.americanhiker.com/viewArea.php?areaID=4)
UC Boulder is located on The Hill if you are into the college scene.
August can be hot. For now we haven't had much of a Spring / Summer.
It has been unseasonally cool and wet, but that makes for green which is great for this time of year...and reduces the risk of forest fires.
There is a gunshow in Denver sometime in August which also sports a great collection of knife dealers.
That's my 2 cents worth, hope it helps.
Will be glad to try and answer any questions that you might have.