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 = '51' and b.Exp_Date >= '2020-04-05' and (b.admin_appr = 'T' or b.submit_date > '2020-04-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 = '51' and (b.admin_appr = 'T' or b.submit_date > '2020-04-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).
Padma Video Bay Area video production company specializing in equestrian video. Affordable high definition videos for sales, stallions, web sites & more. Padma produces BAEN's Horse Lover's 2 Minute How To Videos Bay Area, CA 94510 Bus. ID: 6188 Send E-mailView Map
Asherah Photography Inspirational fine art photography by Karen Asherah. Karen's work focuses on the personality and spirit of her subjects. Her photographs of horses are in nature, without evidence of human intervention. Come visit her website. Karen loves feedback! Karen Asherah 831-331-3384 Felton, CA 95018 Bus. ID: 7373 Send E-mail
Jaden Art Jaden Art provides custom oil painting and oil portrait services. Cherryl Salas 530-903-7731 Cameron Park, CA 95682 Bus. ID: 2625 Send E-mail
MG Pet Photography I am a professional photographer specializing in equestrian and pet fine art portraiture. I am located in Lafayette but I am willing to travel. Horse and Rider Sessions are very popular, as are Black Background Portraits-Our pets deserve to be cherished with beautiful wall art! Missy Goldwyn 925-878-3839 2750 Rohrer Drive Lafayette, CA 94549 Bus. ID: 9364 Send E-mailView Map
Myhorsedogcatphoto Have a great horse cell phone photo? Use it to create full color, professional-looking photo products. Photo isn't perfect? We offer free photo editing. Great inexpensive gift for an impossible to buy for friend. Bonnie Marshall 510-431-2537 375 Bellevue Avenue #205 Oakland, CA 94610 Bus. ID: 9169 Send E-mail
Padma Video Bay Area video production company specializing in equestrian video. Affordable high definition videos for sales, stallions, web sites & more. Padma produces BAEN's Horse Lover's 2 Minute How To Videos Bay Area, CA 94510 Bus. ID: 6188 Send E-mailView Map
Photography by Ellen Einkauf Featuring your horse at its very best. Shows, events, farm calls, portraits Ellen Einkauf Clovis, CA 93619 Bus. ID: 2656 Send E-mail
South Valley Mobile Television Onsite single and multi-camera digital video services for distribution DVD, Web, and Cable TV. Cynthia Stagner 408-230-5694 P.O. Box 263 San Martin, CA 95046 Bus. ID: 2801 Send E-mailView Map
O'Brien Family Pet Care Aimee OBrien 925-8997354 Concord, Ca 94518 Bus. ID: 5887 Send E-mail
Off The Beaten Path Event Photography Darlene & Tom Pinter 209-533-2925 Cell Phone: 408-859-3874 21030 Old Phoenix Lake rd Sonora, CA 95370 Bus. ID: 748 Send E-mail
Search the Directory for:
