SELECT distinct(ID), um.meta_value, um1.meta_value from wp_users as us INNER JOIN wp_usermeta as um on  us.id = um.user_id INNER JOIN wp_usermeta as um1 on  us.id = um1.user_id WHERE um.meta_key = 'role' AND um1.meta_key = 'last_name' AND  ( um.meta_value='s2member_level4' OR um.meta_value='s2member_level3' OR um.meta_value='s2member_level2' ) ORDER bY um.meta_value DESC, um1.meta_value ASC LIMIT 150, 50-247

Member Directory

Filters:
Assistants List
Rescue Photos
General Member

Sarah Corbin

New York, New York
Corbinart Available Services: Art, Black & White, Digital.
Sarah Corbin
General Member

Anne Corder

Martinez, California
Anne Corder
General Member

Diane Costello

Half Moon Bay, California
Fog Dog Studios
Diane Costello
General Member

Randall Crew

Lamoni, Iowa
Available Services: Portrait.
Randall Crew
General Member

Lisa Cueman

Dorset, Vermont
lisa cueman photography
Lisa Cueman
General Member

Deborah Cuming

Greeley, Colorado
Available Services: Digital, Event or Show, Farm.
Deborah Cuming
General Member

Beate Dalbec

Rochester, Massachusetts
Available Services: Art, Digital, Event or Show, Editorial, Farm, Portrait, Stock.
Beate Dalbec
General Member

Heather Dodson

Shady Point, Oklahoma
Heather Dodson
General Member

Tafra Donberger

Elizabeth, Colorado
Tafra Donberger
General Member

Tempest Donnelly

Mead, Colorado
Available Services: Art, Event or Show, Editorial, Farm, Merchandise, Portrait.
Tempest Donnelly
General Member

Andrea Duckworth

Tarrytown, New York
Pirouette Photography Available Services: Black & White, Digital, Event or Show, Farm.
Andrea Duckworth
General Member

Patricia Dukes

Swansea, South Carolina
Patricia Dukes
General Member

Debora Dumpert

Buckeye, Arizona
Debora Dumpert
General Member

Cynthia Fleishman

La Crosse, Wisconsin
Cynthia Fleishman, Photography & Design Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Farm, Graphic Design, Portrait.
Cynthia Fleishman
General Member

Harry Furey

Sorrento, Florida
Harry Furey
General Member

Kevan Garecki

Abbotsford, British Columbia
ManeFrame Imagery Available Services: Art, Black & White, Photography Clinic, Digital, Event or Show, Editorial, Farm, Portrait, Stock.
Kevan Garecki
General Member

Melinda Goblirsch

Englewood, Colorado
Melinda Goblirsch Equine Photography Available Services: Art, Event or Show, Portrait.
Melinda Goblirsch
General Member

Frank Goss

Fort Collins, Colorado
Compelling Images Photography Available Services: Event or Show, Portrait, Video.
Frank Goss
General Member

Delilah Gourley

Orford, New Hampshire
Available Services: Art, Black & White, Event or Show, Editorial, Farm, Portrait.
Delilah Gourley
General Member

Isabelle Green

Pittsfield, Vermont
Isabelle Green
General Member

Carlotta Grenier

Greenwich, Connecticut
Bielderbuch
Carlotta Grenier
General Member

Laura Hamilton

Roxbury, Vermont
Figure 8 Riding
Laura Hamilton
General Member

Sharon Hansen

lutz, Florida
Mounted Shooting Photography
Sharon Hansen
General Member

Joylynne Harris

Lubbock, Texas
Joylynne Harris Photography Available Services: Advertising & Commercial, Black & White, Digital, Event or Show, Farm, Portrait, Stock.
Joylynne Harris
General Member

Meg Hartman

, Georgia
Hooves & Hounds Photography Available Services: Art, Advertising & Commercial, Digital, Farm, Portrait, Stock.
Meg Hartman
General Member

Terry Hawthorne

Seminole, Florida
Soul Expression Photography Available Services: Art, Digital, Editorial, Farm, Graphic Design, Portrait.
Terry Hawthorne
General Member

Heather Johnson

Isle of Palms, South Carolina
Charleston Horse Photographer Available Services: Art, Advertising & Commercial, Black & White, Event or Show, Editorial, Farm, Merchandise, Portrait, Race, Stock.
Heather Johnson
General Member

Kathy Johnston

Fulshear, Texas
Kathy Johnston
General Member

Jennifer Judkins

Danby, Vermont
Resting Heart Farm
Jennifer Judkins
General Member

PJ Kaszas

Halifax, Massachusetts
PJ Kaszas Photography Available Services: Art, Graphic Design.
PJ Kaszas
General Member

Suzanne Kind

Moss Beach Ca, California
Kindworks
Suzanne Kind
General Member

Tracey King

Pocatello, Idaho
Tracey's Photography LLC
Tracey King
General Member

Gail Kirkland

Plano, Texas
Gail Kirkland Photography
Gail Kirkland
General Member

Janet Kluender

Crossville, Tennessee
Janet Kluender
General Member

Susan Kordish

Skull Valley, Arizona
AZ Cowgirl Photography, LLC
Susan Kordish
General Member

Alise Lamoreaux

Creswell, Oregon
Dashing Tails Photography Available Services: Art, Black & White, Photography Clinic, Event or Show, Farm, Portrait, Race, Stock.
Alise Lamoreaux
General Member

Ellen Leonard

Weatherford, Texas
Ellen Leonard
General Member

Marcie Lewis

santa rosa, California
Marcie Lewis
General Member

Marji Lexton

Mulberry, Florida
Marji Lexton Equine Photography (Retired) Available Services: Art, Black & White, Digital, Farm, Portrait.
Marji Lexton
General Member

Syrisse Longbottom

Magnolia, Texas
Syrisse Longbottom
General Member

Patricia (Pat) Lowe

St. Augustine, Florida
Pat Lowe Photography
Patricia (Pat) Lowe
General Member

Curt McAdams

Waynesville, Ohio
Livefire Photography
Curt McAdams
General Member

Ron McCarthy

Surrey, British Columbia
Ron McCarthy
General Member

Susan McClafferty

Boyce, Virginia
Mareish Media LLC Available Services: Art.
Susan McClafferty
General Member

Ford McClave

Golden, Colorado
FordArte
Ford McClave
General Member

Cat McKenna

Phoenix, Arizona
Cat McKenna Design Available Services: Art, Advertising & Commercial, Black & White, Digital, Graphic Design, Portrait, Stock.
Cat McKenna
General Member

Priscilla Miller

Bernardsville, New Jersey
P K Miller Photography Available Services: Digital, Editorial, Farm, Portrait, Race, Stock.
Priscilla Miller
General Member

Samantha Mirzaee

Ottawa, Ontario
Samantha Mirzaee Photography Available Services: Art, Advertising & Commercial, Digital, Event or Show, Editorial, Portrait, Race, Stock.
Samantha Mirzaee
General Member

Jane Mitchell

West Nyack, New York
Jane Mitchell Photography
Jane Mitchell
General Member

Nancy Mitchell

Bellevue, Washington
Nancy Mitchell Photography Available Services: Art, Black & White, Digital, Event or Show, Farm, Portrait, Race.
Nancy Mitchell
showing 151 - 200 of 247 members