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 = '1' and b.Exp_Date >= '2020-09-28' and (b.admin_appr = 'T' or b.submit_date > '2020-09-25')
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 = '1' and (b.admin_appr = 'T' or b.submit_date > '2020-09-25') 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).
Bay Area Equestrian Network Effective Advertising for the Equestrian Market, Internet Marketing, Mobile App Development, Social Media Debbie Smith 800-943-8883 Pleasanton, CA 94588 Bus. ID: 492 Send E-mail
CANTER California Canter California assists in transitioning retired thoroughbred race horses into second careers and provides free sale listings for owners and trainers. Alison Dacher 408-313-1965 Los Gatos, CA Bus. ID: 5205 Send E-mailView Map
Friends of the San Jose Mounted Unit Dedicated to protecting the existence of our Ambassadors of Goodwill PO Box 6511 San Jose, CA 95150-6511 Bus. ID: 3467
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
Monterey Horse Park Preserving land for public recreation and equestrian competition, training and education.
Monterey, CA Bus. ID: 1328 Send E-mail
WHOA! Woodside-area Horse Owners Association WHOA advocates awareness and appreciation of horses in the Woodside area, and organizes annual public events to raise funds for trails, riding programs for underserved communities, large animal rescue equipment and other projects related to horses in the area. Faye Brophy 2995 Woodside Road, Suit 400-466 Woodside, CA 94062 Bus. ID: 4461 Send E-mailView Map
Colonial Spanish Horse Foundation D Wolfe 408-504-4438 San Mateo, CA 94030 Bus. ID: 7501 Send E-mail
Double J Ranch Joe Sarasua 650-650-451-6424 1208 Alamo Street Montara, CA 94037 Bus. ID: 8658 Send E-mail
Equestrian Trails, Inc. ETI 818-362-6819 Sylmar, CA 91342 Bus. ID: 5380 Send E-mail
Search the Directory for:
