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 = '61' 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 = '61' 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).
Arbalette Castle Ranch - Gold Country Retirement for Horses 320 acre historic ranch specializing in horse retirement. We are experienced horse professionals offering Paddocks, Mare Motels or Pastures with Creeks and Meadows. Horses checked daily, special feed programs available. Trainer or Barn references for your horse are required. Special Events Venue. Karan Eriksson 530-802-1281 6597 Smartsville Rd Smartsville, CA 95977 Bus. ID: 8059 Send E-mailView Map
Rancho De Los Amigos Home of Five Mile Equestrian Center. Boarding, Training, Clinics, Lessons. XC Course. Indoor Arena w/mirrors. Full-size Dressage Arena. 500 acres of groomed riding trails. All disciplines welcome. Leslie Hardy 510-538-8932 Cell Phone: 510-909-5770 12350 Cull Canyon Road Castro Valley, CA 94552 Bus. ID: 2237 Send E-mailView Map
Spring Down Equestrian Center A full service boarding facility offering jumping, dressage & equitation lessons; training, horseshows, clinics, drill teams, camps & parties. Summer Camp enroll NOW: June 12th - August 18th Carol Goodstein 650-851-1114 725 Portola Road Portola Valley, CA 94028 Bus. ID: 1248 Send E-mailView Map
Arbalette Castle Ranch - Gold Country Retirement for Horses 320 acre historic ranch specializing in horse retirement. We are experienced horse professionals offering Paddocks, Mare Motels or Pastures with Creeks and Meadows. Horses checked daily, special feed programs available. Trainer or Barn references for your horse are required. Special Events Venue. Karan Eriksson 530-802-1281 6597 Smartsville Rd Smartsville, CA 95977 Bus. ID: 8059 Send E-mailView Map
Branscomb Farms LLC Breeding and sales of pure German-Verband approved Holsteiner and Oldenburg jumpers and dressage horses: foals to mature show champions offered for sale as well as young horse training and equine reproduction services offered in Half Moon Bay, CA Standing stallions Chicardo, Acclaim, and Contiano B 650-560-9650 Fax: 650-284-2525 780 Frenchmans Creek Rd Half Moon Bay, CA 94019 Bus. ID: 4112 Send E-mailView Map
Buffington Performance Horses, LLC Kelli is now the Western trainer at the Woodland Stallion Station where they host a wide range of Events throughout the year. We welcome all horse lovers, riders and handlers to come visit our beautiful facilities, experience our friendly atmosphere and ride in our fun & educational events! Matt Buffington 916-753-4836 Cell Phone: 916-753-4836 Pleasant Grove, CA 95668 Bus. ID: 6600 Send E-mailView Map
California Horse Park 530-226-6237 Fax: 530-226-6210 PO Box 992380 Redding, CA Bus. ID: 2939 Send E-mail
Christiane Noelting Dressage Center The Dressage Center is a 40stall,40ac. facility with 3outdoor+ 2indoor arenas,irrigated pastures offering boarding,training,lessons,sell+breed horses,hosting clinics+3 three star Dressage Shows Christiane Noelting 707-454-0565 Fax: 707-454-0566 6954 Lewis Rd Vacaville, CA 95687 Bus. ID: 1290 Send E-mailView Map
Cottonwood Creek Equestrian Northern California's Equestrian Gathering Place. Numerous Clinics and Events throughout the year. Also boarding, lessons, overnight stays. We follow Natural Horsemanship methods. Gail Bloxham 530-347-0212 Fax: 530-347-0212 18550 Evergreen Rd Cottonwood, CA 96022 Bus. ID: 5029 Send E-mailView Map
Cow Palace Geneva Ave. & Santos St. PO Box 34206 San Francisco, CA 94134-0206 Bus. ID: 1997 Send E-mail
Eden Ranch Eden is a premier family-owned equestrian facility located in Fresno County. We offer lessons, training, and sport horse sales as well as clinics and other equestrian events. Eden's facilities include a covered full dressage court, a 400' jump arena and a few xcountry jumps and fitness track. Ananda Aspen 559-399-8455 Cell Phone: 559 779-1112 2176 N. Bethel Ave. Sanger, CA 93657 Bus. ID: 8679 Send E-mailView Map
Emergency-1 Response, Inc. On-site medical services for the staff, guests and participants of equestrian events across California. Fully licensed and Insured. Member of the Better Business Bureau. Maren Steiner 866-840-0911 Fax: 866-840-0912 11260 Wilbur Ave. #102 Northridge, CA 91326 Bus. ID: 2319 Send E-mailView Map
Graceland Equestrian Center Gated entry, 2 covered arenas 1 huge outdoor arena. XC course with water jump miles of groomed trails.Top trainers Diane Yeager,James Alliston and Kat Drake. Fox Chase Pony Club. Beginners through advanced riders welcome Pristine barns,3 lrg pastures 5 xtra lrg turnouts,breeding barn,on site vet
Peggy Moore 510-538-5555 Fax: 510-538-5444 Cell Phone: 925-286-1954 10970 Crow Canyon Rd Castro Valley, CA 94552 Bus. ID: 5110 Send E-mailView Map
Iron Horse Unlimited Coming Soon, Outdoor event center, perfect for you outdoor wedding with world class views of Mt. Shasta, also available for corporate retreats, parties, horse shows, clinics, gymkhana, or other horse events, full event center available for rent -slated to be done mid to late summer, call for details Ruth Van Sweden-Altes 530-925-2608 VSEquine LLC PO Box 1048 Mount Shasta, CA 96067 Bus. ID: 8416 Send E-mailView Map
Mark West Stables Located in the hills between the Sonoma and Napa Valleys, this offers boarding, English lessons and training and summer camps. We also beautiful facility host clinics and horse shows. Virginie Richard 707-538-2000 Fax: 707 538-1916 5241 St Helena Rd Santa Rosa, CA 95404 Bus. ID: 360 Send E-mailView Map
Marsh Creek Stables Are you looking for a friendly & active boarding facility that is well maintained & cares about your horse? Then we think you will like it here! Large indoor & outdoor arenas, trail course, boarder lounge, wash racks, matted stalls, training, lessons & events. In Brentwood...MarshCreekStables.com Marvin Remmich 925-837-0199 24670 Marsh Creek Road Brentwood, CA 94513 Bus. ID: 6587 Send E-mailView Map
Rancho De Los Amigos Home of Five Mile Equestrian Center. Boarding, Training, Clinics, Lessons. XC Course. Indoor Arena w/mirrors. Full-size Dressage Arena. 500 acres of groomed riding trails. All disciplines welcome. Leslie Hardy 510-538-8932 Cell Phone: 510-909-5770 12350 Cull Canyon Road Castro Valley, CA 94552 Bus. ID: 2237 Send E-mailView Map
Rancho Gavilan - Boarding & Instruction Private barn offering a safe, tranquil setting for both rider & horse. Train with national and internationally qualified trainers, or bring in your own. Clinics, horse shows, pony club. Covered arena with lights and mirrors, jumping arena, outdoor dressage court and more. Alicia Becerra 650-387-2138 Gilroy, CA 95020 Bus. ID: 7939 Send E-mailView Map
RDLA Equestrian Cross Country Schooling Open 7 days a week. Please call for times and availability or view our web site www.rdlatoride.com. New Trainers welcome with students. Trainers on site for lessons if needed. Call for more info 510-538-8932. Leslie Hardy 510-538-8932 Cell Phone: 510-909-5770 12350 Cull Canyon Road Castro Valley, CA 94552 Bus. ID: 6056 Send E-mailView Map
Spring Down Equestrian Center A full service boarding facility offering jumping, dressage & equitation lessons; training, horseshows, clinics, drill teams, camps & parties. Summer Camp enroll NOW: June 12th - August 18th Carol Goodstein 650-851-1114 725 Portola Road Portola Valley, CA 94028 Bus. ID: 1248 Send E-mailView Map
49er Stables Jennifer Kallam 925-216-2276 Grass Valley, CA 95945 Bus. ID: 4668 Send E-mail
Aranaway Farm Mary Anne Morrison 541-476 9297 Grants Pass, CA 97527 Bus. ID: 5780 Send E-mail
Cozzolino Park Terry Tenzing 650-303-4281 Highway 92 Half Moon Bay, CA Bus. ID: 4903 Send E-mail
Diablo Ranch Events KIM BRUMLEVE 925-837-2290 Fax: 925-837-2290 1453 Northgate Rd. Walnut Creek, CA 94598 Bus. ID: 3480 Send E-mail
Diablo Ranch Events and Gatherings Kim Brumleve 945-925-837-2290 Cell Phone: 925-497-5454 1453 N gate Road Walnut Creek, Ca 94598 Bus. ID: 6111 Send E-mail
Search the Directory for:
