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 = '64' and b.Exp_Date >= '2017-04-23' and b.serv_region = 'South Central' and (b.admin_appr = 'T' or b.submit_date > '2017-04-20') 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 = '64' and b.serv_region = 'South Central' and (b.admin_appr = 'T' or b.submit_date > '2017-04-20') ORDER BY sortID DESC , member DESC, busi_name Bay Area Equestrian Network - Show business listings
Business Directory - Tack Shops & Supplies - South Central California
  • 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 directory@bayequest.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

  • Sierra Horse Connection
    Johanna Adams
    559-559-683-7667
    Fax: 559-641-2652
    49234 Golden Oak Dr.
    Suite #101
    Oakhurst, CA 93644
    Bus. ID: 1327    


  •