The closest local show that I know of is the one in Lodi and Tracy. And those are still new shows that are still growing. Then San Jose and Sacramento are larger and more established.
There are quite a few reptile keepers in Stanislaus though.
Freedom Breeder in Turlock comes to mind as one of the 'big names'. But they don't generally sell animals at expos. They only tend to promote their racks.
If there was a show that was at least the same size as San Jose's show, I would be willing to go to a Stanislaus one. Though I don't really see it getting huge like Sacs or the ones in SoCal.