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 >= '2019-04-23' and b.serv_region = 'North Central' and (b.admin_appr = 'T' or b.submit_date > '2019-04-20')
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 > '2019-04-20') 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
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
Coleal Arabian Horse Farm Arabian Horse Breeding and Sales since 1964. Home of National Top Ten Stallion and Sire of Halter, Performance, and Sport Horse Champions Bill, Rhoda & Rhonda Coleal Rhonda's cell 209-479-3033 Rhoda's cell 209-483-5791 Herald, CA Bus. ID: 838 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
Los Lagos Equestrian, Inc. Hunter/Jumper Training and Showing. Accepting new clients of all ages and levels. Training, Sales, Lessons (school horses available), Leases. Visit Web site at www.llhorses.com 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
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
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:
