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 = '42' 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 = '42' 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).
Cheval Insurance Services, Inc. Specializing in Equestrian, Sports & Recreational insurance. We understand the particular needs of the horse-sporting enthusiast through our direct involvement, both in the care, training & competing of horses. Holly Lopes PO Box 2933 Fullerton, CA 92833 Bus. ID: 7429 Send E-mailView Map
Morningstar Insurance Brokers, Inc. Agents and Brokers serving the needs of today's Horse Industry. Member, United Valley Insurance Services. Kathy Crooymans 626-294-2323 ext 228 Fax: 626-294-2324 138 E. Huntington Dr Arcadia, CA 91006 Bus. ID: 627 Send E-mailView Map
Sypolt Insurance Services, Inc. We are agricultural and equine insurance specialists who provide insurance programs for farm packages, equine mortality, equine liability, personal and commercial insurance risks. Mary Blincoe-Sypolt 800-995-4770 Fax: 916-669-1363 Cell Phone: 916-202-8455 11344 Coloma Road, Suite #635 Gold River, CA 95670 Bus. ID: 4268 Send E-mailView Map
All-Equine Insurance Agents and Brokers serving the needs of today's Horse, Farm and Ranch Industry. All Equine is a division of Morningstar Insurance Brokers. Kathy Crooymans 626-294-2323 ext. 228 Fax: 626-294-2324 138 E. Huntington Dr. Arcadia, CA 91006 Bus. ID: 1115 Send E-mailView Map
Cheval Insurance Services, Inc. Specializing in Equestrian, Sports & Recreational insurance. We understand the particular needs of the horse-sporting enthusiast through our direct involvement, both in the care, training & competing of horses. Holly Lopes PO Box 2933 Fullerton, CA 92833 Bus. ID: 7429 Send E-mailView Map
Morningstar Insurance Brokers, Inc. Agents and Brokers serving the needs of today's Horse Industry. Member, United Valley Insurance Services. Kathy Crooymans 626-294-2323 ext 228 Fax: 626-294-2324 138 E. Huntington Dr Arcadia, CA 91006 Bus. ID: 627 Send E-mailView Map
Sypolt Insurance Services, Inc. We are agricultural and equine insurance specialists who provide insurance programs for farm packages, equine mortality, equine liability, personal and commercial insurance risks. Mary Blincoe-Sypolt 800-995-4770 Fax: 916-669-1363 Cell Phone: 916-202-8455 11344 Coloma Road, Suite #635 Gold River, CA 95670 Bus. ID: 4268 Send E-mailView Map
AFLAC Piper Howden-White 307-699-4136 5820 Stoneridge Mall Rd. Suite 209 pleasanton, CA 94588 Bus. ID: 5514 Send E-mail
Brave Accounting Sarah Judson 425-286-4251 San Luis Obispo, CA 93449 Bus. ID: 8883 Send E-mail
Brown & Brown Insurance N. CA francine schuler 707-481-8043 Fax: 707 795-3845 600 Pepper Rd Petaluma, CA 94952 Bus. ID: 1733 Send E-mail
Leighton Insurance Associates, Inc. Nancy Leighton 916-408-5735 Fax: 916-880-5263 Cell Phone: 916-390-1144 805 Twelve Bridges Dr. Ste 20 Lincoln, CA 95648 Bus. ID: 5964 Send E-mail
Search the Directory for:
