While these places aren't in the Fremont, I fully agree with ddd228 about MSS bar and trip7. I've also enjoyed the Chicago brewing company; good view of the casino floor, relatively quiet, great micros and decent snacks. Maybe a tad more expensive that MSS. I'm not inclined to find a place to get dog faced, slobber lipped wasted, so I can't comment on the full service bars and nightspots. However, I do enjoy a good brew and tasty treat in these places