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 = '55' and b.Exp_Date >= '2019-01-22' and a.subcat_id='83' and (b.admin_appr = 'T' or b.submit_date > '2019-01-19')
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 = '55' and a.subcat_id='83' and (b.admin_appr = 'T' or b.submit_date > '2019-01-19') 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).
Chaparral Ranch at Wunderlich Park Chaparral Ranch now offers guided trail rides at Wunderlich Park in Woodside. Come enjoy 17 miles of beautiful, shady, all-weather, dog-less, bike-less trails on well-trained horses. 408-726-8453 Woodside, CA 95135 Bus. ID: 8852 Send E-mail
Moss Beach Ranch We are a full service boarding and training facility located on the beautiful Coastside just 20 miles south of San Francisco. We offer horse care, full lesson and training programs, combined with access to 4,200 acres of breathtaking riding trails Rich Allen 650-728-0700 Fax: 728-7740 Cell Phone: 728-0700 PO Box 24 Moss Beach, CA 94038 Bus. ID: 2394 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
Canham Farm Horse Rescue Inc. Julia Hyde 831-8315885198 Cell Phone: 8315885198 333 Canham Road Scotts Valley, CA 95066 Bus. ID: 9194 Send E-mail
Ride Bay Area Ride Bay Area Riding, Training 408-726-8453 Cell Phone: 408 726-8453 several locations throughout the bay area milpitas, woodside, CA Bus. ID: 5095
Rosemont Stables Brittany Gaal 504-292.1223 Half Moon Bay, CA 94002 Bus. ID: 7019 Send E-mail
BUSINESS DIRECTORY
Search the Directory for: