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 = '36' and b.Exp_Date >= '2021-08-05' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02')
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 = '36' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02') 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).
Tully Hole Saddlery Fine custom horse gear in the Californio tradition. Inspired by the classic gear of yesterday, built for the working cowboys of today. Bryan Kunic 831-524-5278 PO Box 301 Tres Pinos, CA 95075 Bus. ID: 6215 Send E-mailView Map
A Gifted Rose A Gifted rose 714-9782390 Murrieta, CA Bus. ID: 4864
Blue Horse Design Laurie Dearinger 510-459-5900 P.O. Box 458 Crockett, CA 94525 Bus. ID: 4106 Send E-mail
Brander Art Lynn Brander 530-827-2708 PO BOX 698 Doyle, CA 96109 Bus. ID: 3652 Send E-mail
Christine George Design Christine George 240-687-5692 Napa, CA 94558 Bus. ID: 8182 Send E-mail
Cowboy Brand Candles Jenni McMahon 805-877-2-COWBOY San Luis Obispo, CA 93401 Bus. ID: 1634 Send E-mail
Franga Equestrian and Pet Boutique Unicorn Browbands & Medieval Style Horse Barding/Caparisons & Blankets California City, CA Bus. ID: 2884 Send E-mail
Horse and Things.com 707-887-2287 Online at Horses and Things.com Forestville, CA 95436 Bus. ID: 6536 Send E-mail
Horse Scapes & War Scapes Mark Zolnoski 951-301-3619 Cell Phone: 586-996-5509 Menifee, CA 92584 Bus. ID: 4969 Send E-mail
Horse Staples S BISWAS 951-286-1268 Murrieta, CA 92562 Bus. ID: 8864 Send E-mail
Horsethings Nancy Hall 209-531-0767 Fax: 209-531-0767 Cell Phone: 209-5050550 3211 West Whitmore Ave. Modesto, CA 95358 Bus. ID: 2904 Send E-mail
Katherine Plumer Fine Art Katherine Plumer 916-687-7385 PO Box 703 Wilton, CA 95693 Bus. ID: 724 Send E-mail
Search the Directory for:
