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 = '70' and b.Exp_Date >= '2019-04-19' and (b.admin_appr = 'T' or b.submit_date > '2019-04-16')
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 = '70' and (b.admin_appr = 'T' or b.submit_date > '2019-04-16') 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).
Pine Mountain Lake Stables Melissa Moore 209-962-8667 13309 Clifton Way Groveland, CA 95321 Bus. ID: 2750 Send E-mail
Bittmore Horses One stop source for all Horse Activities, including riding & trail lessons, horse training, Western & English riding, horse & rider therapy!, Horse Camps, Beginners a specialty. Call 1 888 HORSE 40 925-449-9605 Livermore, CA 94551 Bus. ID: 4523 Send E-mailView Map
Enchantment Equitreks Discover the cuisine, culture and landscapes of the southwest during one of our all inclusive horseback riding vacation packages in New Mexico. Join us for the Balloon Fiesta and EquiYoga. Justyn Vogel 575-430-7514 45 Eastridge Road Edgewood, NM 87015 Bus. ID: 8875 Send E-mail
Howard Creek Ranch Inn Sally and Sunny Grigg 707-964-6725 Fax: 707-964-1603 40501 North Highway One PO Box 121 Westport, CA 95488 Bus. ID: 4053
Iron Horse Unlimited Coming Soon, Outdoor event center, perfect for you outdoor wedding with world class views of Mt. Shasta, also available for corporate retreats, parties, horse shows, clinics, gymkhana, or other horse events, full event center available for rent -slated to be done mid to late summer, call for details Ruth Van Sweden-Altes 530-925-2608 VSEquine LLC PO Box 1048 Mount Shasta, CA 96067 Bus. ID: 8416 Send E-mailView Map
Marble Mountain Dude Ranch Vacations All inclusive dude ranch vacations are centered around a Western cowboy's trail riding theme. We combine our horseback trail riding program with thrilling guest ranch activities. 530-469-3322 Somes Bar, CA 95568 Bus. ID: 6626 Send E-mailView Map
Running Horse Ranch Extraordinary trail rides for experienced riders Daniela Keyes 661-724-2500 Cell Phone: 818-437-3546 25000 Pine Canyon Road Lake Hughes, CA 93532 Bus. ID: 8717 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
A Villa Montagne Equestrian B&B Connie DeJong 888-831-6361 Cell Phone: 307 413-1480 28495 Big Basin Way Boulder Creek, CA 95006 Bus. ID: 6799 Send E-mail
Teenys Trails Chris Pauly 530-620-3408 3020 Little Spur Rd Somerset, Ca 95684 Bus. ID: 7867 Send E-mail
TentOutdoors.com Linda Chavez 866-916-0827 Fax: 866-479-9310 Cell Phone: 909-282-7689 2622 Second Street La Verne, CA 91750 Bus. ID: 5332 Send E-mail
The Horseshoe Bend Waystation liz kinoshita 530-526-1167 Cell Phone: 408-893-7853 15682 Bend Johnson Rd. Red Bluff, CA 96080-9377 Bus. ID: 8945 Send E-mail
Search the Directory for:
