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 = '59' and b.Exp_Date >= '2023-02-04' and b.serv_region = 'North Central' 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 = '59' and b.serv_region = 'North Central' 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).
Alioto Arabians & Half Arabians Quality Arabians and Half Arabian horses for sale. Visit our web site www.extendinc.com/aliotoarabians. Georgann Alioto 530-269-3001 Grass Valley, CA 95602 Bus. ID: 1015 Send E-mail
Four Star Farm Certified Level III ICP Eventing Instructor, USDF L-graduate dressage judge and USDF Silver medalist. Lessons and training for eventing, dressage,and jumpers. Sale horses, camps and clinics. Natalie Rooney Cell Phone: 707-312-1119 30486 Equus Lane Winters, CA 95694 Bus. ID: 2433 Send E-mailView Map
Gateway Farm Sport Horses Full care facility offering boarding, training, lessons, sales, breeding, camps, and Pony Club. Stalls, individual pastures, and group pastures w/shelters. Covered arena, sand jump arena, round pen and cross country course. Special pastures for retirees and mares/foals. In business since 1989. Liz Jenner 209-759-9700 Cell Phone: (209) 327-6858 Acampo, CA 95220 Bus. ID: 7609 Send E-mail
Valley Horse Center Training, breeding & sales from foal to finish. Honesty & integrity- foundation for good business, honest sales & quality horse training. Showing/competing in halter, sporthorse, trail, extreme cowboy race, endurance. Jodi Tuft 707-374-2858 Cell Phone: 707-688-1741 Red Bluff, CA Bus. ID: 1215 Send E-mailView Map
A Rising Star Equestrian Center Claire Clark 209-744-9411 14111 Joy Dr. Galt, CA 95632 Bus. ID: 2032 Send E-mail
AG Welsh Ponies Allie Gualco 530-574-7362 Fax: 916-452-7259 Cell Phone: 916-870-7314 Woodland, CA 95776 Bus. ID: 5705 Send E-mail
Los Lagos Equestrian, Inc. Carrie Orcutt 916-652-0904 Cell Phone: 759-2153 P.O. Box 2116 6525 Boulder Rd Granite Bay, CA 95746 Bus. ID: 6682 Send E-mail
Pacific Equestrian Center Mari Naten 916-687-8035 Fax: 687-8041 Wilton, CA 95693 Bus. ID: 3082 Send E-mail
Protective Pet Solutions, LLC 844-487-7387 1420 E. Roseville Pkwy. Suite #140161 Roseville, CA 95662 Bus. ID: 8715 Send E-mail
Rise Over Run Ranch Jordan McNAbb 916-778-9759 Cell Phone: 916-778-9759 Loomis, CA 95650 Bus. ID: 4957 Send E-mail
S & S Tack Stephanie Bayers 209-1-800-940-6990 Fax: 209-556-0479 Cell Phone: 209-595-1413 6055 S. Central Ave Ceres, CA 95307 Bus. ID: 1983 Send E-mail
Search the Directory for:
