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 = '10' and b.Exp_Date >= '2018-06-25' and a.subcat_id='110' and (b.admin_appr = 'T' or b.submit_date > '2018-06-22') 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 = '10' and a.subcat_id='110' and (b.admin_appr = 'T' or b.submit_date > '2018-06-22') ORDER BY sortID DESC , member DESC, busi_name Bay Area Equestrian Network - Show business listings
  • Search the Directory for:
    Bus. Name:
    Bus. ID: Example: 492
    Keyword:
    (Use comma(,) to split the keywords, for example: horse,tack)
    Mileage Search:
    Category:
    Select multiple categories by holding down the Ctrl key and clicking on desired categories
    Area Code:
    County:
    Region:


    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).

    Visit our newest Members

    View all Members


  • Core Equestrian
    Internationally certified dressage and jumper training available at our prestigious facility in Portola Valley. Exceptional care and top quality training are just the start of the services we offer!
    FEI Jumpers & Dressage
    650-743-9654
    Portola Valley, CA 94028
    Bus. ID: 5832    Send E-mail     View Map

    Branscomb Farms LLC
    Breeding and sales of pure German-Verband approved Holsteiner and Oldenburg jumpers and dressage horses: foals to mature show champions offered for sale as well as young horse training and equine reproduction services offered in Half Moon Bay, CA Standing stallions Chicardo, Acclaim, and Contiano B
    650-560-9650
    Fax: 650-284-2525
    780 Frenchmans Creek Rd
    Half Moon Bay, CA 94019
    Bus. ID: 4112    Send E-mail     View Map

    Core Equestrian
    Internationally certified dressage and jumper training available at our prestigious facility in Portola Valley. Exceptional care and top quality training are just the start of the services we offer!
    FEI Jumpers & Dressage
    650-743-9654
    Portola Valley, CA 94028
    Bus. ID: 5832    Send E-mail     View Map
    Prestige Equestrians
    Julia Smith
    831-236-5935
    7324 Crow Canyon Road
    Castro Valley, CA 94552
    Bus. ID: 7367    Send E-mail


  •