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 = '95' and b.Exp_Date >= '2018-06-24' and (b.admin_appr = 'T' or b.submit_date > '2018-06-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 = '95' and (b.admin_appr = 'T' or b.submit_date > '2018-06-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).
Ferber Fitness Athletic training, fitness and nutrition services for riders of all abilities. Taught by a National Academy of Sports Medicine Certified Performance Enhancement Specialist, at your home or at his fully equipped indoor-outdoor facility in the hills above Lafayette, CA. Be fitter! Ride Better! Adam Ferber 510-508-2500 1180 Brown Ave. Lafayette, CA 94549 Bus. ID: 6876 Send E-mailView Map
Quest Equestrian We offer riding lessons in English Hunter Jumper and Western in the Oakland hills. Jerry Kuroda 510-918-7833 Oakland, CA 94602 Bus. ID: 9041 Send E-mailView Map
Tracey Hill Dressage Training at North Peak Equestrian Tracey is an FEI rider & trainer and relocated to Walnut Creek offering lessons, training, sales and top care. She teaches students just starting their dressage career to Grand Prix. Come for a visit! Tracey Hill 707-481-2799 Walnut Creek , CA Bus. ID: 9078 Send E-mail
Wild Horsemanship The Heart Centered approach to Training the Whole Horse and Rider so that true partnership is attained. We can develop your horse into the safe, confident, devoted companion you desire, or you may study our methods on one of our "teaching" horses. Our focus is on connection rather than competition. Midori Morgan Cell Phone: (707)479-8031 19440 Brindle Pony Drive Penn Valley, CA 95946 Bus. ID: 3743 Send E-mailView Map
BUSINESS DIRECTORY
Search the Directory for: