Filter By
     
SELECT * FROM ipa_wp_posts LEFT JOIN ipa_wp_postmeta AS pm ON( ipa_wp_posts.ID = pm.post_id AND pm.meta_key = 'pet_listings_listing_type' ) LEFT JOIN ipa_wp_postmeta AS pm1 ON( ipa_wp_posts.ID = pm1.post_id AND pm1.meta_key = 'pet_listings_date_lost_found' ) LEFT JOIN ipa_wp_postmeta AS pm2 ON( ipa_wp_posts.ID = pm2.post_id AND pm2.meta_key = 'pet_listings_listing_status' ) LEFT JOIN ipa_wp_postmeta AS pm3 ON( ipa_wp_posts.ID = pm3.post_id AND pm3.meta_key = 'pet_listings_shelterid' ) WHERE ipa_wp_posts.post_status = 'publish' AND ipa_wp_posts.post_type = 'pet_listings' AND pm.meta_value = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
Grimes
Found: 11/13/2018
ID: 9998
Name: Gilbert
Type: Dog
Color: Golden brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Found
Des Moines - South
Found: 11/11/2018
ID: 10053
Name: Unknown
Type: Cat
Color: Tabby colors, gray, black and brown
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Was found in the woods east of SE 19th. Had been living outside for awhile.
Ankeny
Found: 11/11/2018
ID: 9983
Name: Rajah
Type: Cat
Color: Black/brown
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Found: 11/11/2018
ID: 9982
Name: unknown
Type: Dog
Color: Black
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
We found the dog running with another white dog, it was following the white dog who ran into traffic almost or maybe got hit, uncertain but it seemed well enough because it kept running. The black one seems older because it got tired of running and we were able to catch it. Unfortunately the white dog kept running and we lost where it went. Had a color but no tags. IT IS NOW WITH THE ARL !
Clive
Found: 11/10/2018
ID: 10000
Name: unknown
Type: Cat
Color: medium gray, no markings (lighter color in person than in the photo)
Breed: Russian Blue
Gender: Male
Fixed: Not Neutered
Age: Adult
Found in western Clive in Country Club Glen subdivision (near intersection of Boston Pkwy and 161st St). Took to Furry Friends Refuge.
West Des Moines
Found: 11/9/2018
ID: 9972
Name:
Type: Dog
Color:
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Found at the intersection of 22nd street and Pleasant
Pleasantville
Found: 11/8/2018
ID: 9966
Name:
Type: Dog
Color: Brown, white and black
Breed: Treeing Walker Coonhound
Gender: Male
Fixed: Neutered
Age: Young
Wont leave our house
Algona
Found: 11/7/2018
ID: 9949
Name: ???
Type: Cat
Color: tourtoise shell or calico-gold, black, white mixed
Breed: Tortoiseshell
Gender: Unknown
Fixed: Unknown
Age: Young
found in Algona, outside old OB Lang middle school
Algona
Found: 11/7/2018
ID: 9948
Name: ???
Type: Cat
Color: Multi gold black
Breed: Tortoiseshell
Gender: Unknown
Fixed: Unknown
Age: Baby
Very friendly We’re allergic :(
Grimes
Found: 11/6/2018
ID: 9943
Name:
Type: Dog
Color: White and Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Found on Glenstone Drive in Grimes, IA.
Ankeny
Found: 11/3/2018
ID: 9944
Name: Shadow
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He is not an outdoor cat and has never snuck out before. He is not declawed. His body is long for his head. And minky-soft. he has a long tail. We miss him! I will post a picture when I find one. He looks like the Bombay cats or a miniature panther. Very sweet disposition but does not care to be held.
Des Moines - West
Found: 11/3/2018
ID: 9930
Name:
Type: Dog
Color: Black
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
56th Street and N Valley Dr.
Des Moines - South
Found: 11/3/2018
ID: 9926
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Young
Please text/ email a description of the dog and collar.
Des Moines - South
Found: 11/3/2018
ID: 9924
Name:
Type: Cat
Color:
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
West Burlington
Found: 11/1/2018
ID: 10144
Name: Free to good home
Type: Cat
Color: Dark grey and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
This afternoon, he is very friendly, walks right in. May have been abandoned. We have 3 cats, and they aren't happy about any strange cats. He'll come in, eat, has used a litter box, but leaves if the door is opened. Want to have him vet checked, will if he keeps coming around.
West Burlington
Found: 11/1/2018
ID: 10143
Name: Free to good home
Type: Cat
Color: Dark grey and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
This afternoon, he is very friendly, walks right in. May have been abandoned. We have 3 cats, and they aren't happy about any strange cats. He'll come in, eat, has used a litter box, but leaves if the door is opened. Want to have him vet checked, will if he keeps coming around.
Mingo
Found: 10/31/2018
ID: 9928
Name: Unknown
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
It showed up on our deck on Halloween begging for food. We fed him some dog food and he's been here since then. Very friendly, seems quite young, a few scrapes.
Des Moines - Central
Found: 10/31/2018
ID: 9922
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found young cat in our yard. Scanned for chip, none found, no tags, be prepared to provide detailed physical description of the cat as well as a description of her collar.
West Des Moines
Found: 10/31/2018
ID: 9900
Name: Unknown
Type: Cat
Color: Grey
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
Cat was comfortable but skittish. Hungry, healthy. Seemed lost. Ate and drank. Friendly but kept distance. Contact 515.577.5985
Des Moines - North
Found: 10/31/2018
ID: 9899
Name:
Type: Cat
Color: Black Tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Windsor Heights
Found: 10/31/2018
ID: 9898
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
This cute little guy was found in the street near my house and he came right up to me! He's got a broken bone in his foot so I am keeping him with me until he is claimed. I am also going to see what I can do about his foot.
Des Moines - North
Found: 10/31/2018
ID: 9897
Name: Rocko
Type: Dog
Color: White
Breed: Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
14th n university area
Ames
Found: 10/30/2018
ID: 9888
Name: ?
Type: Cat
Color: dark brown on top, some stripes, light color on belly
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
I saw this cat in the stairwell and it has no collar. It appears to be very friendly and well-fed. For some reason I cannot upload pictures...
Monroe
Found: 10/28/2018
ID: 9871
Name:
Type: Dog
Color: Black and tan
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
He was found wandering around the Dollar General in Monroe. He was trying to get in the store. He’s walking with a slight limp on his front left paw.
Waukee
Found: 10/27/2018
ID: 9870
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young