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-263

Member Directory

Filters:
Assistants List
Rescue Photos
Associate Pro Member

Alexandra Lauder

High River, Alberta
Available Services: Art, Black & White, Digital, Event or Show, Editorial, Farm, Portrait.
Alexandra Lauder
Associate Pro Member

Aubry Mcadams

Salinas, California
Available Services: Art, Digital, Event or Show, Portrait, Stock, Video.
Aubry Mcadams
Associate Pro Member

Mary Ellen Moore

Clinton Corners, New York
memoorephotography Available Services: Art, Black & White, Event or Show, Farm, Portrait.
Mary Ellen Moore
Associate Pro Member

Molly Morris

San Luis Obispo, California
Molly Virginia Morris Photography Available Services: Advertising & Commercial, Event or Show, Portrait.
Molly Morris
Associate Pro Member

Robin Ouellette

Madawaska, Maine
Truly North Photography Available Services: Advertising & Commercial, Black & White, Photography Clinic, Digital, Event or Show, Editorial, Farm, Portrait, Race.
Robin Ouellette
Associate Pro Member

Denise Sherman

Oceanport, New Jersey
Art Horse Productions Available Services: Art, Advertising & Commercial, Black & White, Digital, Farm, Portrait.
Denise Sherman
Associate Pro Member

Brian Stephenson

Alliance, Nebraska
Photography by Klarunz Available Services: Art, Black & White, Editorial, Portrait, Stock.
Brian Stephenson
Associate Pro Member

Annie Wu

Rockwall, Texas
Annie J Wu, LLC Available Services: Art, Digital, Farm, Portrait.
Annie Wu
General Member

Marian Adoranti

Hamilton, Ontario
Marian Adoranti Photography Available Services: Art, Portrait.
Marian Adoranti
General Member

Tonya Allmon

Woodford, Virginia
PURPLE ROSE PETS Available Services: Black & White, Digital, Event or Show, Farm, Portrait, Race, Stock.
Tonya Allmon
General Member

Karie L Anderson

Karie L Anderson
General Member

Heather Astley

Norfolk, Massachusetts
Heather Astley
General Member

Max Bailey

Richmond, Indiana
Max Bailey Photography Available Services: Event or Show, Portrait.
Max Bailey
General Member

Karen Bayerl

Pittsville, Wisconsin
Karen Bayerl
General Member

christy berry

clarkesville, Georgia
Berryvineimage Available Services: Art, Stock.
christy berry
General Member

Sheila Brauning

Allen, Texas
Sheila Brauning Photography Available Services: Portrait.
Sheila Brauning
General Member

Dorna brown

Simi Valley, California
Dorna brown
General Member

Sharon Buchanan

Simpson, Illinois
Sharon Buchanan
General Member

Janet Chanay

Dolores, Colorado
JEchanay photographs
Janet Chanay
General Member

Christine Charron

Mohnton, Pennsylvania
Christine Charron
General Member

Jillian Chilson

Richmond, Virginia
Jills FotoLuv
Jillian Chilson
General Member

Lyn Clark

Casper, Wyoming
Lyn Clark
General Member

Gretchen Clark

Phoenix, Arizona
Gretchen Clark
General Member

Lisa Cohen

Ridgefield, Connecticut
Silver Mountain Studio Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Farm, Portrait.
Lisa Cohen
General Member

Joanne Collins

Salem, Oregon
Joanne Collins Fine Art Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Graphic Design, Merchandise, Stock.
Joanne Collins
General Member

Kathy Colman

Truckee, California
Kathy Colman Photography
Kathy Colman
General Member

sarah Connaughton

East Aurora, New York
Available Services: Art, Black & White, Digital, Event or Show, Farm, Portrait, Race.
sarah Connaughton
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

Lisa Cueman

Dorset, Vermont
lisa cueman photography
Lisa Cueman
General Member

Erika Culmann

Erika Culmann
General Member

Deborah Cuming

Weedsport, New York
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
Pink Horse Media 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

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

Jeff Goldberg

Boulder, Colorado
Available Services: Editorial, Portrait.
Jeff Goldberg
General Member

Frank Goss

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

Bozena Hagen

Available Services: Art.
Bozena Hagen
General Member

Laura Hamilton

Roxbury, Vermont
Figure 8 Riding
Laura Hamilton
General Member

Sharon Hansen

lutz, Florida
Mounted Shooting Photography
Sharon Hansen
General Member

Terry Hawthorne

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

Zach Hewitt

Elizabeth, Colorado
Available Services: Event or Show, Farm.
Zach Hewitt
General Member

Alex Hover

Alex Hover
General Member

Heather Johnson

Isle of Palms, South Carolina
Heather Johnson Photo Available Services: Art, Advertising & Commercial, Black & White, Photography Clinic, Digital, Event or Show, Editorial, Farm, Merchandise, Portrait, Race, Stock.
Heather Johnson
showing 151 - 200 of 263 members