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 = '66' and b.Exp_Date >= '2019-08-19' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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 = '66' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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).
Martin Ranch Supply Since 1974, Martin Ranch Supply has been the leading manufacturer of equine and ranch equipment, corrals, gates, shelters, barns and kennels and offers a full line of fencing. Exiss & Sooner trailers, supplies, tack and over 10,000 products in stock. Custom work and special orders welcome. 707-585-1313 Rohnert Park, CA 94928 Bus. ID: 3182 Send E-mailView Map
101 Trailer Sales We sell Logan Coach & Platinum Mfg. Brad Nelson 831-726-3220 Fax: 831-726-2877 4400 Hwy 101 Aromas, CA 95004 Bus. ID: 2250 Send E-mailView Map
L Bar D Ranch Mobile Repair Serving Sonoma, Marin & Napa County in all phases of automobile, horse trailers, trucks and recreational vehicles repairs. Dealer and installer of superchips and Ford Powerstroke Exhaust brakes.
Larry Strain 707-795-5283 Cell Phone: 753-1848 775 Palm Avenue Penngrove, CA 94951 Bus. ID: 190 Send E-mailView Map
Martin Ranch Supply Since 1974, Martin Ranch Supply has been the leading manufacturer of equine and ranch equipment, corrals, gates, shelters, barns and kennels and offers a full line of fencing. Exiss & Sooner trailers, supplies, tack and over 10,000 products in stock. Custom work and special orders welcome. 707-585-1313 Rohnert Park, CA 94928 Bus. ID: 3182 Send E-mailView Map
RT Motors We specialize in pre-owned trucks. No haggle low upfront prices on late model low mileage trucks. We have your next work or two vehicle in stock! Family owned and operated in Tracey, CA. Ron Toor 209-535-6209 3602 Mars Way STE 107 Tracy, California 95377 Bus. ID: 9192 Send E-mailView Map
Sundowner of California Whether you are looking for a bumper pull or gooseneck horse trailer, slant load or straight load horse trailer, aluminum or steel horse trailer or a cargo trailer or utility trailer, contact Sundowner of California! Sales, service, trade-ins, financing available. 530-887-9502 505 Hilltop Drive Auburn, CA 95603 Bus. ID: 6567 Send E-mailView Map
American Horse Trailer Rental Inc. Gregg Miron 559-3815357 Fax: 5597359529 Cell Phone: 5593815357 1020 Hansen Way Redwood City, CA 94068 Bus. ID: 7705 Send E-mail
Search the Directory for:
