Easily the longest for me was the trip to TN (~1200 miles round trip!) but I generally try and keep things within an eight hour round trip.  Of course, I'm willing to travel farther for the nicer things, or just regular things in larger quantities.  I certainly wouldn't drive more than say 50 miles for something like a single SE or an LC.