SELECT distinct b.*, a.sortID
FROM `busi_in_cat_uf` a LEFT JOIN v_BusiUser b
on a.busi_id = b.busi_id
where a.cat_id = '44' and b.Exp_Date >= '2019-08-19' and (b.admin_appr = 'T' or b.submit_date > '2019-08-16')
union all
SELECT distinct b.*, a.sortID
FROM `busi_in_cat` a LEFT JOIN v_BusiUser b
on a.busi_id = b.busi_id
where a.cat_id = '44' and (b.admin_appr = 'T' or b.submit_date > '2019-08-16') ORDER BY sortID DESC , member DESC, busi_name
Bay Area Equestrian Network - Show business listings
Help update BAEN's Directory and earn FREE Photo Ads.
If you find a listing that needs flagging, let us know. Examples: wrong category, broken web links, duplicate, business no longer exists, etc.. Email bayequest@gmail.com and include the ID number of the listing along with your comments. We'll say thanks for your help with a FREE photo ad (maximum value $22).
Baughman's western wear, tack, boots, supplies, gifts, jewelry, hats 925-447-1540 2029 First Street Livermore, CA 94550 Bus. ID: 5495
Christesen's English and Western tack, apparel, boots, hats, jewelry, gifts 925-846-2169 633 Main Street Pleasanton, CA 94588 Bus. ID: 5494
Custom Horsehair Jewelry We make beautiful horsehair necklaces, bracelets and earrings! We can custom make one for you out of your own horse's tail or from our stock of horsehair. We are extremely reasonable in price ranging from $10-$75. Check us out on Facebook by searching Equine Tails Western Design! Ann Simon 707-732-1347 Petaluma, CA 94954 Bus. ID: 8986 Send E-mailView Map
Tap's Bit and Spur Shop Custom bits and spurs, western engraving, jewelry Mike Vatalaro 707-744-8443 501A St. Mary\\\'s Ave. Hopland, CA 95449 Bus. ID: 5894 Send E-mail
Beal's Cowboy Buckles Richard Beal 831-662.2325 Fax: 831.662.0934 2379 Newell Drive Aptos, CA 95003 Bus. ID: 502 Send E-mail
Bentien's Western Store Todd Renfrew 707-469-9950 Fax: 707-455-0550 Cell Phone: 707-365-5064 198 Dobbins St., Suite D Vacaville, CA 95688 Bus. ID: 3567 Send E-mail
Cerini-Ayers Jewelry and Design Lillian Ayers 707-795-5525 Cell Phone: 707 953-4384 Rohnert Park, CA 94928 Bus. ID: 2549 Send E-mail
Search the Directory for:
