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 = '132' and b.Exp_Date >= '2019-04-19' and (b.admin_appr = 'T' or b.submit_date > '2019-04-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 = '132' and (b.admin_appr = 'T' or b.submit_date > '2019-04-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).
Healing Arenas, Inc. Our mission it to Provide public and charitable opportunities to support emotional healing through equine interaction, and provide safe and restorative homes for retired racehorses Julie Baker 209-900-7917 Cell Phone: 988-7800 PO Box 312 Escalon, CA 95320 Bus. ID: 8750 Send E-mailView Map
Mearas Mearas provides an accelerated learning environment in partnership with horses to co-create a new way of being that emphasizes authenticity, collaboration and community. Our transformational workshops align mind, body and spirit to support one's personal and professional growth. Julie Bridge 415-2976848 Cell Phone: 4152976848 6391 Blank Road Sebastopol, CA 95472 Bus. ID: 7672 Send E-mailView Map
Medicine Horse Ranch/HorseDreamUSA We incorporate horses into human self development. Specializing in HorseDream® USA Certification, leadership development, team-building, personal and professional development. Private, group and custom designed programs available. Alyssa Aubrey 707-878-2440 Cell Phone: 707-766-4565 PO Box 224 1599 Cerini Rd. Tomales, CA 94971 Bus. ID: 3668 Send E-mailView Map
One Step Closer Therapeutic Riding One Step Closer is an adaptive riding program using equestrian activities to help people with physical, cognitive, and emotional challenges. One Step Closer is a Center Member of the Professional Association of Therapeutic Horsemanship (PATH) International and a 501(c)3 non-profit organization. Mark Keirstead 408-778-3567 Cell Phone: 408-391-2619 15770 Foothill Avenue Morgan Hill, CA 95037 Bus. ID: 7577 Send E-mailView Map
Cindy Martin Training & Behavior Coaching Cindy Martin Cell Phone: 809-3891 Carmel Valley, CA 93924 Bus. ID: 7720 Send E-mail
Epona Mobile Connection Elizabeth Loper 619-9925758 San Diego, Ca 92019 Bus. ID: 6598 Send E-mail
Search the Directory for:
