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-08-20' and a.subcat_id='89' and (b.admin_appr = 'T' or b.submit_date > '2019-08-17')
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 a.subcat_id='89' and (b.admin_appr = 'T' or b.submit_date > '2019-08-17') 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).
A Robinsons Equestrian Services/Who Rescues Who Located in the beautiful east bay hills, R.E.S. Offers the best in Training-Riding Lessons-Rehabs-Sales-Summer Camps
We guarantee personal attention, we welcome horses & Riders at all stages no drama Lisa Braden-Robinson 510-760-8909 Cell Phone: 510-760-8909 6667 Johnston Road Pleasanton, Calif 94588 Bus. ID: 9124 Send E-mailView Map
California Riding Academy now in Pacifica! Lessons, Camp and Training. CRA's award winning team welcomes H/J and Equitation riders, offering top-notch service and amenities. Huge covered arena, second outdoor arena, round-pen, daily turnouts. Sales/Leases. Lessons for all ages/levels. USPC Certified. Come check out our new location! Jessica Harrell 650-740.2261 650 Cape Breton Drive Pacifica, CA 94044 Bus. ID: 5535 Send E-mailView Map
Thomas Ranch All welcome! Horses started, finished, or reschooled. Lessons, training, sales of REINING, CUTTING, REINED COW & DRESSAGE horses. Indoor/outdoor facilities, 10 minutes from Orinda. Over 30 years national and international experience. Patient, professional help for you and your horse. Eric Thomas 925-229-2299 Fax: 925-229-2292 Cell Phone: 925-528-9356 Briones, CA 94553 Bus. ID: 6133 Send E-mailView Map
A Robinsons Equestrian Services/Who Rescues Who Located in the beautiful east bay hills, R.E.S. Offers the best in Training-Riding Lessons-Rehabs-Sales-Summer Camps
We guarantee personal attention, we welcome horses & Riders at all stages no drama Lisa Braden-Robinson 510-760-8909 Cell Phone: 510-760-8909 6667 Johnston Road Pleasanton, Calif 94588 Bus. ID: 9124 Send E-mailView Map
All The Kings Horses USDF Certified Instructor offering Dressage training AND KIDS lesson program. Quality school horses! Custom training and lesson packages located at our own facility in Sonoma Co., east of Santa Rosa. Erin King Jackson 415-385-8354 Calistoga, CA 94515 Bus. ID: 4015 Send E-mailView Map
Ann Simon Horsemanship Lessons, training and sales located at Pleasants Valley Arena in Vacaville. Beautiful facility with a large covered arena,round pens and trails. All ages and abilities welcome. Specializing in all around horsemanship with a focus in reining/cowhorse, barrel racing/gymkhana. Lesson horses available! Ann Simon Cell Phone: 707-732-1347 7680 Pleasants Valley Rd Vacaville, 95688 Bus. ID: 8896 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
Breakwell Stables LTD Located at Menlo Circus Club, Atherton,CA. Accepting clients.Jumper Training, Sales, Investments. Peter Breakwell Cell Phone: 650 255 3710 1250 Sherman Ave Menlo Park, CA 94025 Bus. ID: 6160 Send E-mailView Map
California Riding Academy now in Pacifica! Lessons, Camp and Training. CRA's award winning team welcomes H/J and Equitation riders, offering top-notch service and amenities. Huge covered arena, second outdoor arena, round-pen, daily turnouts. Sales/Leases. Lessons for all ages/levels. USPC Certified. Come check out our new location! Jessica Harrell 650-740.2261 650 Cape Breton Drive Pacifica, CA 94044 Bus. ID: 5535 Send E-mailView Map
CANTER California Canter California assists in transitioning retired thoroughbred race horses into second careers and provides free sale listings for owners and trainers. Alison Dacher 408-313-1965 Los Gatos, CA Bus. ID: 5205 Send E-mailView Map
Coastal Andalusians Breed high quality Andalusians...bloodlines go back to Maluso, Agente and Leviton. Producing Black/Bays and Blacks. Your next Sport Horse. Deb Titone 650-728-9448 Cell Phone: 650-483-8719 Montara, CA Bus. ID: 4660 Send E-mailView Map
GaitedPleasureHorses.com For over 30 years Gaited Pleasure Horses ranch has specialized in providing gentle gaited trail horses best matched to your personal riding level. Our horses are fairly priced and comes with a limited purchase guarantee. Other services: transport, custom gaited horse saddles, and new & used tack. Terry Zygalinski Cell Phone: 831-818-5932 110 Paddon Road Royal Oaks, CA 95076 Bus. ID: 3012 Send E-mailView Map
Golden Oak Farm, LLC Breeders of premium hunter, jumper and dressage horses from top European bloodlines. Offering sales of champion offspring, breeding to top stallions, training and clinics. Dara Rip 650-868-0175 Fax: 650-249-3405 Woodside, CA 94062 Bus. ID: 5340 Send E-mailView Map
HJ Sporthorses, LLC. HJ Sporthorses, LLC. offers a direct line to top quality German horses at huge savings by going directly to their breeders. Horses available now! Contact us for more info. Heather Hurwitt 813-928-9140 22603 Rodeo Avenue Gerber, CA 96035 Bus. ID: 9165 Send E-mailView Map
Jaclyn Meinen Dressage Jaclyn Meinen Dressage provides knowledgeable, positive and enjoyable dressage training and sales by USDF Gold Medalist and current FEI competitor Jaclyn Meinen, as well as experienced dressage and eventing trainer Jennifer Meinen. Jaclyn Meinen 949-246-1850 Redwood City , CA 94062 Bus. ID: 8546 Send E-mailView Map
Peninsula Equestrian Academy CHA certified riding instruction in english and western, all ages. Training for you and your horse in your discipline of choice. Experienced with green/young horses. Lesson horses available. Horses for lease.
E-mail: ms.colleenrose@gmail.com Colleen Shjeflo 650-759-0737 3450 Deer Creek Road Palo Alto, CA 94034 Bus. ID: 7092 View Map
Shakespeare Farm Private Full Service Facility. Are you looking high quality personalized care and training with like-minded equestrians? Shakespeare Farm offers catered programs for every level of rider to assist Kimberly Ramirez 831-840-3335 Santa Cruz, CA 95065 Bus. ID: 1155 Send E-mailView Map
The Dressage Arena Located in picturesque Penngrove, USDF gold medalist and RVT Gail McGuffey offers the finest in Dressage Prospects and Finished Sport Horses for sale. We have openings for quality sporthorses that need to be marketed and sold. Gail McGuffey 707-481-5512 100 Lynch Road Petaluma, CA 94954 Bus. ID: 5992 View Map
Thomas Ranch All welcome! Horses started, finished, or reschooled. Lessons, training, sales of REINING, CUTTING, REINED COW & DRESSAGE horses. Indoor/outdoor facilities, 10 minutes from Orinda. Over 30 years national and international experience. Patient, professional help for you and your horse. Eric Thomas 925-229-2299 Fax: 925-229-2292 Cell Phone: 925-528-9356 Briones, CA 94553 Bus. ID: 6133 Send E-mailView Map
Tracey Hill Dressage Training Grand Prix rider Tracey Hill is available for: training of dressage horses and riders, clinics, sales and judging schooling shows. Come audit a lesson or training to get familiar with Tracey's style! Tracey Hill 707-481-2799 Martinez, CA 94518 Bus. ID: 6176 Send E-mail
Meadow Hill Farm Stephen Pellett 831-601-7936 P.O. Box 2054 Carmel Valley, Ca 93924 Bus. ID: 8071 Send E-mail
PAMELA LYNCH (Reining-Cowboy Dressage-All Around Western) Pamela Lynch Cell Phone: 650-465-4003 Woodside-Portola Valley Coastside-Montara to Pescadero La Honda, CA 94020 Bus. ID: 3744 Send E-mail
Search the Directory for:
