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 = '54' and b.Exp_Date >= '2023-02-04' and (b.admin_appr = 'T' or b.submit_date > '2023-02-01')
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 = '54' and (b.admin_appr = 'T' or b.submit_date > '2023-02-01') 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).
Wendy Massa, Realtor (R) eXp Realty of CA For over 20+ years, I specialize in helping sellers & buyers of equestrian & estate properties, unimproved land, residential & investment real estate in the Foothills, Sacramento & surrounding areas. DRE:01233420 Wendy Massa 530-680-6848 Browns Valley, CA 95918 Bus. ID: 9512 Send E-mail
Erika Westhoff Real Estate Equestrian Real Estate Specialist -Guiding your journey to serve your real estate needs for your equestrian lifestyle home or property. No horse? No Problem! Moving up or downsizing, I can help you live your best life! Erika Westhoff 510-3310327 127 Spring St. #230 Pleaasanton, CA 94506 Bus. ID: 9509 Send E-mailView Map
Teresa Dietrich, Realtor, GoldCountryRanches.com Specializing in Horse property, ag property, ranches, and every aspect of real estate. I am a member of several Horse clubs, and a horse owner. Call or e-mail me for information, Automatic notifications, help with mortgage mods, short sales, buying or selling, resources. Teresa Dietrich 530-432-3333 Fax: 466-2908 Cell Phone: 362-6806 944 McCourtney Rd. Ste D Grass Valley, CA 95949 Bus. ID: 5019 Send E-mailView Map
Wendy Massa, Realtor (R) eXp Realty of CA For over 20+ years, I specialize in helping sellers & buyers of equestrian & estate properties, unimproved land, residential & investment real estate in the Foothills, Sacramento & surrounding areas. DRE:01233420 Wendy Massa 530-680-6848 Browns Valley, CA 95918 Bus. ID: 9512 Send E-mailView Map
Premier Equestrian Properties Lisa Thomas 707-579-LISA Fax: 527-0617 Cell Phone: 217-2683 600 Bicentennial Way Santa Rosa, CA 95403 Bus. ID: 5842 Send E-mail
A Home for you and your Horse! Lisa's a lifelong equestrian with 25 years of real estate experience. Lisa moved back home to Nevada, a GREAT place to live! Located at the base of the Sierras, minutes to world class skiing, mild climate, no state income taxes! Areas served include Genoa, Gardnerville, Minden and Carson City. Lisa Manuele 775-781-5953 1362 U.S. Highway 395, Suite 112B Gardnerville, NV 89410 Bus. ID: 4558 Send E-mailView Map
A+ Country Realtor Growing up watching her Grandmother sell residential real estate and broker land deals including vineyards and country estates Sonya naturally speaks the language and has been involved in real estate in some way, shape or form all her life. Sonya Hollander 415-827-4096 25 East Napa Street Sonoma, CA 94576 Bus. ID: 9260 Send E-mailView Map
Abreu, Lori Delta Ranches and Homes As a real estate broker/owner and the leader in East Contra Costa County Horse Properties, I have over 15 years experience with land listings and purchase. A supporter to many community services, centrally located in Downtown Brentwood. 5 Star Rated, The Leader in Selling Equine Estates. Lori Abreu 925-216-6317 Fax: 866-837-3770 Cell Phone: 925-216-6317 761 Second St. Brentwood, 94 94513 Bus. ID: 7509 Send E-mailView Map
Anna Boyd - Your Town & Country Specialist Selling country and horse properties for 17 years in El Dorado, Placer, Amador and surrounding areas and loving it! I can help you find that great country property at a great price. Anna Boyd-RE/MAX Gold 916-813-3534 Fax: 916-939-2014 El Dorado - Placer Amador - Foothills El Dorado Hills, CA 95762 Bus. ID: 720 Send E-mailView Map
Brandy Godoy - CalDre #02082376 Coldwell Banker Select RE Horsewoman-Realtor living and serving the Equestrian community. Choose a Realtor who actually understands what you are looking for! I have the experience needed for Rural horse & ranch properties. Brandy Godoy 530-979-6718 430 Third Street Woodland, ca 95695 Bus. ID: 9518 Send E-mail
Catherine Myers, Real Estate Broker @ www.DiabloValley.net Specializing in horse property, farm and ranch properties in addition to homes, luxury estates and more. Serving Contra Costa including Clayton, Brentwood, Martinez, Walnut Creek, Lafayette, Orinda, Concord, Danville, Alamo. Free home search. Proudly serving the equestrian community of the Bay Area. Catherine Myers 925-683-2125 Cell Phone: 925-683-2125 PO Box 334 Clayton, Ca 94517 Bus. ID: 8080 Send E-mailView Map
Diana Plank - David Cline, Coldwell Banker Offering premier real estate services for Land, Ranches, Horse Properties and residential homes in the San Mateo County Coastal, South Coast and Skyline areas. Diana Plank 650-728-8080 Fax: 650-728-1573 Cell Phone: 650-619-3370 1415 Main Street Box 371297 Montara, CA 94037 Bus. ID: 4448 Send E-mail
Diane Higuet / Lyon Real Estate Realtor specializing in horse properties. Have been involved with horse rescue, 4H, and as of this year High School Rodeo. Working hard to help you and your horses find a happy home. Diane Higuet 916-939-2577 Fax: 939-5333 Cell Phone: 952-4043 3900 Park Drive #100 El Dorado Hills, CA 95762 Bus. ID: 821 Send E-mail
Erika Westhoff Real Estate Equestrian Real Estate Specialist -Guiding your journey to serve your real estate needs for your equestrian lifestyle home or property. No horse? No Problem! Moving up or downsizing, I can help you live your best life! Erika Westhoff 510-3310327 127 Spring St. #230 Pleaasanton, CA 94506 Bus. ID: 9509 Send E-mailView Map
Forth Hoyt - The Hoyt Group Simple, Straightforward Real Estate. Realtor since 2001. Works throughout Sacramento, El Dorado, Placer, Yolo and Nevada Counties. Farm & Ranch Division of Keller Williams, Listing Specialist. Hoyt Forth 916-248-7777 2295 Iron Point Rd., #160 Folsom, CA 95630 Bus. ID: 8937 Send E-mail
Foxy Rider Farm Private Trainer with extensive 40+ years riding,training,showing ,background,H/J "A" Circuit,w/John French. English and Western. Specializing in flat work, ground manners,jumping, dressage, trail and obstacle training,behavior modification. Insured.Many references available. Lisa Frazier 650-868-0900 Cell Phone: 868-0900 2720 Alpine Rd Portola Valley , Ca 94028 Bus. ID: 9456 Send E-mail
George Betz Farm Real Estate Serving agricultural properties for 40 years. George Betz 831-724-5959 Watsonville, CA Bus. ID: 1133 Send E-mail
Lisa Manuele, Realtor Lisa is a lifelong equestrian who specializes in horse and country properties. Lisa is a second generation Realtor and has over 20 years of real estate & appraisal experience. Serving Silicon Valley: Wodside, Los Altos, Portola Valley, Saratoga, Los Gatos, San Jose, San Martin, Morgan Hill, Gilroy. Lisa Manuele 408-504-9743 175 E. Main Avenue Suite 130 Morgan Hill, CA 95037 Bus. ID: 2248 Send E-mailView Map
Lyon Real Estate in Auburn Prices are still in your best interest! Strike it rich in Gold Country - Selling El Dorado, Placer & Sacramento Counties, home to the Tevis Trails! Barbara Mancia (Lic: 01501498) Fax: 530-745-8995 Cell Phone: 530-613-2491 1900 Grass Valley Hwy. Suite 100 Auburn, CA 95603 Bus. ID: 3761 Send E-mailView Map
Lyon Real Estate, Elk Grove Specializing in country properties. I own and have shown horses all my life. I can assist you in selling or buying that perfect country property. Sally Rodriguez 916-683-6901 Fax: 683-6644 Cell Phone: 591-0263 Wilton, CA 95693 Bus. ID: 2043 Send E-mail
Murphy Real Estate Team Horse & ranch real estate expert representing everything from heirloom properties to working ranches to raw land in Santa Cruz on the Monterey Bay! Frank Murphy 831-457-5550 Fax: 831-401-2425 Santa Cruz, CA 95060 Bus. ID: 5478 Send E-mail
New Vision Realty Group Brokered by eXp Realty of Calif. PlacerHorseandHomes - providing personalized service for Buyers and Sellers of Equestrian, Rural, and Recreational Properties. Cheryl Hansen 916-202-7851 951 Reserve #140 Roseville, CA 95678 Bus. ID: 9516 Send E-mailView Map
Nona Green, Broker Associate DR #00692351 34+ years experience. "Horse people helping horse people". Serving West Los Angeles and East Ventura counties. Agoura, Agoura Hills, Calabasas, Bell Canyon, Hidden Hills, Monte Nido, Malibu Canyon Nona Green 818-426-2292 Agoura Hills, CA 91301 Bus. ID: 7410 Send E-mailView Map
Patti Babish Ranch and Rural Property Specialist RE/MAX GOLD Specializing in Ranch Properties. Selling or Buying I can help you! Having been a horsewoman my whole life I know horse properties and respect every aspect of the horse business. DRE 01864683 Patti Babish 951-640-9921 3025 Sacramento St Placerville, California 95667 Bus. ID: 9345 Send E-mailView Map
PlacerHorseAndHomes Equestrian, Rural, and Country Property Specialist Cheryl Hansen 916-202-7851 951 Reserve #140 Roseville, CA 95648 Bus. ID: 9393 Send E-mailView Map
Poco Rio Rancho South Almaden Valley. 6 acres of prime horse property. Great location close to San Jose border. Top ranked school area. The Alamitos Creek runs through a large, flat pasture. $1,650,000 Lorraine Combs 408-309-9117 Fax: 997-2171 Cell Phone: 408-309-9117 22503 San Vicente Avenue San Jose, CA 95120 Bus. ID: 2672 Send E-mail
Real Estate Mariah -- Equestrian & Residential Real Estate Specialist When it comes to representing Equestrian properties, experience and connections are crucial. Mariah created & managed the well known 160-stall Leap of Faith Farms in Walnut Creek. Her knowledge of the industry positions her uniquely to advise and promote all horse properties, whether 2 horses or 200 Mariah Bradford 925-787-2490 Abio Properties 950 Hough Ave #A Lafayette, CA 94549 Bus. ID: 8763 Send E-mailView Map
Realty World ~ At Home Serving the Bay Area and specializing in Ranch, Residential and Commercial property. www.RickDianeWright.com Rick & Diane Wright 800-524-5711 Fax: 510-886-5738 22097 Redwood Road Castro Valley, CA 94546 Bus. ID: 236 Send E-mailView Map
Teresa Dietrich, Realtor, GoldCountryRanches.com Specializing in Horse property, ag property, ranches, and every aspect of real estate. I am a member of several Horse clubs, and a horse owner. Call or e-mail me for information, Automatic notifications, help with mortgage mods, short sales, buying or selling, resources. Teresa Dietrich 530-432-3333 Fax: 466-2908 Cell Phone: 362-6806 944 McCourtney Rd. Ste D Grass Valley, CA 95949 Bus. ID: 5019 Send E-mailView Map
The Real Estate Center We offer experienced Real Estate service for buyers and sellers in Jackson, Josephine, Klamath, Douglas, Coos, and Curry counties. Donna Jones 541-821-5493 Fax: 541-779-4805 Cell Phone: 541-821-5493 409 E. Barnett Rd. Medford, OR 97501 Bus. ID: 4978 Send E-mail
United Country Real Estate - California Properties 30+ years as a realtor. From land to training centers. Laura knows horses and horse property. Extensive knowledge of soils, irrigation, facility design The "go to" realtor for ranch property in the Sierra Foothills www.facebook.com/CountryPropertyRealtor/ Laura Berman 530-273-3900 Cell Phone: 530-913-8789 226 Mill Street Grass Valley, CA 95945 Bus. ID: 2347 Send E-mailView Map
Wendy Massa, Realtor (R) eXp Realty of CA For over 20+ years, I specialize in helping sellers & buyers of equestrian & estate properties, unimproved land, residential & investment real estate in the Foothills, Sacramento & surrounding areas. DRE:01233420 Wendy Massa 530-680-6848 Browns Valley, CA 95918 Bus. ID: 9512 Send E-mailView Map
All American Real Estate Group Ron Hurst 916-364-7120 ext 207 Fax: 916-363-7400 Cell Phone: 916-416-5191 Sacramento, CA 95827 Bus. ID: 3937 Send E-mail
Cherie Cross Intero Real Estate Services Cherie Cross Cell Phone: 530-680-7518 4364 Town Center Blvd suite 120 El Dorado Hills, CA 95762 Bus. ID: 9402 Send E-mail
Cheryl Calhoun ~ Nino Real Estate Cheryl Calhoun 831-801-5441 Fax: 866-351-1637 Cell Phone: 801-5441 829 San Benito Street, Suite 100 Hollister, CA 95023 Bus. ID: 2731 Send E-mailView Map
Cheryle Dykstra Century 21 Ditton Cheryle Dykstra 559-642-3303 Fax: 559-683-2257 Cell Phone: 760-0845 39541 Westview Dr. Oakhurst, CA 93644 Bus. ID: 1644 Send E-mailView Map
Christina Hunter - RE/MAX Gold Coast Christina Hunter 805-917-4106 Fax: 818-879-4605 Cell Phone: 805-559-2318 280 E Thousand Oaks Blvd Thousand Oaks, CA 91360 Bus. ID: 2233 Send E-mail
Christina Maldonado-Home & Ranch Realtors Christina Maldonado 805-434-9700 ext. 208 Fax: 434-9740 Cell Phone: 550-7045 412 N. Main Street Templeton, CA 93465 Bus. ID: 962 Send E-mail
Christopher Smith, Realtor Christopher Smith 707-953-2810 Fax: 579-4753 831 Fourth Street Santa Rosa, CA 95404 Bus. ID: 4563 Send E-mail
Coast Capital Mortgage Scott Sayles 650-856-4800 x161 Fax: 650-856-4880 Cell Phone: 650-669-0596 824 San Antonio Road Palo Alto, CA 94040 Bus. ID: 1483 Send E-mail
Cody Maltzman ~ Premier Realty Associates Cody Maltzman 707-703-2263 Cell Phone: 707-703-2263 PO Box 695 Healdsburg, CA 95448 Bus. ID: 2246 Send E-mail
Coldwell Banker Teresa Black 800-829-3209 Fax: 831-637-4968 Cell Phone: 831-801-2036 200 Tres Pinos Rd. Hollister, CA 95023 Bus. ID: 1694 Send E-mail
Coldwell Banker Phyllis Swallow 831-634-4657 Fax: 831-637-4968 200 Tres Pinos Rd Hollister, CA 95023 Bus. ID: 2053 Send E-mail
Coldwell Banker Deann DaSilva 415-898-1255 Cell Phone: 250-6117 1737 Grant Avenue Novato, CA 94945 Bus. ID: 3215 Send E-mail
Coldwell Banker Premier Darla Stephenson 805-610-4399 704 Spring St Paso Robles, ca 93446 Bus. ID: 5659 Send E-mail
Davis & Davis Associates, Ltd. Candace Taylor 916-747-4426 Fax: 991-4426 Cell Phone: 747-4426 1637 I Street Rio Linda, CA 95673 Bus. ID: 4771 Send E-mail
Fall River Real Estate Leo Estes 530-336-7047 Fax: 336-6304 Cell Phone: 383-4715 44240 walnut st. main st. mcarthur, CA 96056 Bus. ID: 2374 Send E-mail
Hills & Homes Property Management Wendy Geary 707-588-5851 Fax: 707-584-7661 Cell Phone: 799-7331 5550 State Farm Dr. Rohnert Park, CA 94928 Bus. ID: 1527 Send E-mail
Home Buyers Realty KATIE DUKE 209-914-3573 632 W 11th St Ste 215 Tracy, CA 95376 Bus. ID: 9362 Send E-mail
Horse Property for Sale Katcha Burnett 408-802-6222 Morgan Hill, CA 95037 Bus. ID: 7766 Send E-mail
Jamie Lee Moore Real Estate Jamie Lee Moore, Broker/Attorney 415-272-2772 Fax: 415-634-1544 Cell Phone: 272-2772 700 Larkspur Landing Circle Larkspur, CA 94901 Bus. ID: 4884 Send E-mail
Mandi Thompson Realtor BRE 01848034 Mandi Thompson 916-916-616-2224 18850 Forest Home Rd Plymouth, CA 95669 Bus. ID: 9546 Send E-mail
Marin Horse Properties Jamie Lee Moore, Broker 415-272-2772 Larkspur, CA 94939 Bus. ID: 5477 Send E-mail
Martinez Ranch Management and Real Estate Tyler Rickey 530-5305296603 Fax: 5305296605 Cell Phone: 5309452445 95 Sale Lane Red Bluff, CA 96080 Bus. ID: 1638 Send E-mail
McCombs Properties Ellen McCombs 831-251-4544 Scotts Valley, CA Bus. ID: 2010 Send E-mail
Melody Shahid Real Estate Melody Shahid 925-270.9580 Cell Phone: (925) 270-9580 Walnut Creek, CA 94598 Bus. ID: 8757 Send E-mail
Pombo Real Estate Natalie Pombo-McCarty Cell Phone: 321.5353 Tracy, CA Bus. ID: 1613 Send E-mail
Premier Equestrian Properties Lisa Thomas 707-579-LISA Fax: 527-0617 Cell Phone: 217-2683 600 Bicentennial Way Santa Rosa, CA 95403 Bus. ID: 5842 Send E-mail
Premier Realty Allison Rinauro 916-257-9080 Fax: 9169897774 Shingle Springs, CA 95682 Bus. ID: 6846 Send E-mail
Premiere Equestrian Properties Lisa Thomas 707-535-8830 Fax: 527-0617 Cell Phone: 217-2683 Santa Rosa, CA 95403 Bus. ID: 3201 Send E-mail
Ralph Sessa Ranch Properties Ralph Sessa 925-648-5300 Cell Phone: 925-858-5233 4125 Blackhawk Plaza Circle Suite 201 Danville, CA 94506 Bus. ID: 1667 Send E-mail
Ranch Real Estate Online Paul Backovich -760-366-4866 Cell Phone: 760-401-7333 56925 Yucca Trail #313 pmb Yucca Valley, CA 92284 Bus. ID: 3904 Send E-mail
Realty World / Keller-D'Agostini John Garrow 800-622-1323 Fax: 530/622-1214 5909 Mt Aukum Road Somerset, CA 95667 Bus. ID: 2705 Send E-mail
Realty World Pacific Homes Stu Carson 408-209-0849 Fax: 408-762-2070 Cell Phone: 408-209-0849 610 Powder Horn Ct San Martin, CA 95046 Bus. ID: 4020 Send E-mail
San Diego Real Estate Homes for Sale Adriana Meeks 619-4217268 Cell Phone: 619 7545457 4617 Ruffner Street San Diego, CA 92111 Bus. ID: 3341 Send E-mail
Sandy Geary Sonoma County Realtor Sandy Geary 707-588-5888 Fax: 584-7661 Cell Phone: 484-6579 5550 state farm dr rohnert park, CA 94928 Bus. ID: 1408 Send E-mail
Sandy Geary-Sonoma County Real Estate Agent wendy geary 707-588-5851 Fax: 707-584-7661 Cell Phone: 707-799-7331 5550 state farm dr rohnert park, CA 94928 Bus. ID: 1820 Send E-mail
SF HomeLife, Inc Frank Vella 650-464-8062 Fax: 650-292-2205 1005 Terra Nova Blvd Suite A Pacifica, CA 94044 Bus. ID: 7713 Send E-mail
Silicon Valley Equestrian Karlene DiNapoli, Realtor/Broker Associate 408-612-7090 Fax: 408-762-2512 Intero Real Estate 175 East Main Avenue #130 Morgan Hill, CA 95037 Bus. ID: 7800 Send E-mail
Sparry & Company John Sparry 408-448-7419 Fax: 448-7419 San Jose, CA 95118 Bus. ID: 4623 Send E-mail
Stephanie Raymann - RE/MAX Gold Solano Stephanie Raymann 707-422-8616 Cell Phone: 707-803-2330 4820 Business Center Drive #160 Green Valley, CA 94534 Bus. ID: 3739 Send E-mail
Sturgis Realty Group Christine Sturgis 916-223-9452 Roseville, Ca 95661 Bus. ID: 8597 Send E-mail
The Bay Area Team Jim Walberg 925-260-8800 Danville, CA 94506 Bus. ID: 8419 Send E-mail
The Cheryll White Team Diane Higuet 916-939-2577 Fax: 916-939-5333 Cell Phone: 916-952-4043 5030 Marshall Road PO Box 431 Garden Valley, CA 95633 Bus. ID: 3361 Send E-mail
The Super Agent Extraordinaire Isaac Rodrigues 925-362-0407 Fax: 925-362-9377 Cell Phone: 899-5778 313 Sycamore Valley Road Danville, CA 94526 Bus. ID: 1480 Send E-mail
www.SonomaCountyHorseProperty.com Carrie Belle Riggs, Realtor 707-303 4234 Fax: 544 3605 Cell Phone: 326 1527 456 So. E St. Santa Rosa, CA 95405 Bus. ID: 1267 Send E-mail
Zip Realty Inc. Carol Sumner Realtor® 831-688-8367 Fax: 877-273-3632 Cell Phone: 831-227-5696 Serving all of Santa Cruz County, CA 95060 Bus. ID: 3794 Send E-mail