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 >= '2023-02-04' and (b.admin_appr = 'T' or b.submit_date > '2023-02-01')
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 > '2023-02-01') 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).
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
Horse ReCourse Mendocino County non-profit horse rescue organization. We rehabilitate and place needy horses, and offer education and assistance to support local horses. Robyn McCallister 707-272-2127 Fort Bragg , CA 95437 Bus. ID: 9553 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
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