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 >= '2018-12-10' and (b.admin_appr = 'T' or b.submit_date > '2018-12-07')
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 > '2018-12-07') 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
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
BUSINESS DIRECTORY
Search the Directory for:
