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 >= '2020-09-24' and b.serv_region = 'North Central' and (b.admin_appr = 'T' or b.submit_date > '2020-09-21')
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 > '2020-09-21') 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
Coleal Arabian Horse Farm Located in beautiful rolling grasslands 25 miles southeast of Sacramento. Indoor/outdoor arenas, round pen, hot walker, large stalls, fly spray system, pipe runs, paddocks, pasture, automatic waterers. Quality hay and grain, daily cleaning, 24 hour supervision. Come visit us! Rhoda Coleal 209-483-5791, Rhonda Coleal 209-479-3033 www.colealfarms.com Herald, CA 95638 Bus. ID: 8921 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
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:
