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 = '38' and b.Exp_Date >= '2019-02-18' and (b.admin_appr = 'T' or b.submit_date > '2019-02-15')
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 = '38' and (b.admin_appr = 'T' or b.submit_date > '2019-02-15') 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).
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
ClearVue Plus Professional Services Integral quality overnight care for companion animals-large or small + communication/healing touch.10+ years working in the horse/pet sitting field.New to the Bay area... Will travel. daisy wheeler 925-808-652-2469 Cell Phone: 808-652-2469 258 Rainbow Lane Pleasant Hill, CA Bus. ID: 2689 Send E-mail
Cypress Ridge Hunter/Jumper Now accepting new clients for full-training. Cypress Ridge is a competitive A-circuit Show Barn in Woodside,CA. We have horses available for jumping lessons and 1/2 leases for riders wanting to show. Nessa Cossentine 831-234-3325 Woodside, Ca 94062 Bus. ID: 8799 Send E-mailView Map
The Woof Pack Horse sitting with a guarantee. Love and attention for your horse and pets like they were our own. Licensed, bonded, insured. Will travel in East Bay. We also secure your home or ranch. Rick Delgado 510-797-9663 P.O. Box 2714 Fremont, CA 94536 Bus. ID: 3105 Send E-mailView Map
Spence Pet Sitting Kristen Spence 650-593-4538 Cell Phone: 766-9638 San Carlos, CA 94070 Bus. ID: 7446 Send E-mail
A Gentle Touch Horse Training Melanie McCarthy Cell Phone: 559-474-2569 AGThorsetraining@aol.com Colt Starting,training,lessons,sales Madera, CA 93637 Bus. ID: 2003 Send E-mail
A Lone Roan Equine & Pet Sitting Services Amber Macdonald 925-305-7499 Martinez,, CA Bus. ID: 4058 Send E-mail
A Lone Roan Equine & Pet Sitting Services and Training Amber Macdonald 925-305-7499 Cell Phone: 9253057499 Davis, CA 95618 Bus. ID: 6001 Send E-mail
BUSINESS DIRECTORY
Search the Directory for:
