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
West Des Moines
Found: 9/7/2017
ID: 6721
Name: Riggs
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Going into creek behind 46th ST in West Des Moines, loves people and other dogs. Friendly.
West Des Moines
Found: 9/7/2017
ID: 6720
Name: Riggs
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Going into creek behind 46th ST in West Des Moines, loves people and other dogs. Friendly.
Des Moines - Central
Found: 9/6/2017
ID: 6707
Name:
Type: Dog
Color: Black and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Adult
Found on 56th street in des moines
Ames
Found: 9/2/2017
ID: 6682
Name:
Type: Cat
Color: grey and white
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Found in University Village
Urbandale
Found: 9/2/2017
ID: 6681
Name:
Type: Cat
Color: Grey with some cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly boy. Surely someone must be missing this cutie pie. Hoping to help him find his way back home...
Kensett
Found: 9/2/2017
ID: 6677
Name:
Type: Dog
Color: Tan/brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Senior
North side of Kensett
Kensett
Found: 9/2/2017
ID: 6676
Name:
Type: Dog
Color: Tan
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Baby
Very sweet girl but is getting annoyed by our young dog. Cant have that going on.
Kensett
Found: 9/2/2017
ID: 6675
Name:
Type: Dog
Color: Tan
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Senior
Granger
Found: 9/1/2017
ID: 6958
Name: Finola
Type: Cat
Color: Tuxedo
Breed: Tuxedo
Gender: Female
Fixed: Unknown
Age: Baby
Found. Sweet adult female. Took to Vet to evaluate for pregnancy. She is spayed, microchipped and negative for FIV. She is in foster care with me while we try and locate her owner through microchip. So far no response. Hoping to get her reunited!
Urbandale
Found: 9/1/2017
ID: 6680
Name:
Type: Cat
Color: Grey with some cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly boy. Surely someone must be missing this cutie pie. Hoping to help him find his way back home...
Des Moines - Central
Found: 9/1/2017
ID: 6668
Name: Unknown
Type: Dog
Color: Tan,black and white
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Senior
Waukee
Found: 9/1/2017
ID: 6662
Name: unknown
Type: Dog
Color: black and white
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
contact Waukee dispatch for current whereabouts
Cedar Rapids
Found: 8/31/2017
ID: 6654
Name:
Type: Dog
Color: black body,greyish black belly,golden brown feet,face black with brown outlining his eyes and mouth,under tail is brown the under side of his tail is brown and the top is black
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
was running in the middle of edgewood rd. and f ave. at 12:30am. friendly well taken care of . sorry don,t have phone to take a picture.don't know for sure but he looks like he could be a rottweiler and is just a puppy not sure how old maybe 6 months
Urbandale
Found: 8/29/2017
ID: 6679
Name:
Type: Cat
Color: Grey with some cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly boy. Surely someone must be missing this cutie pie. Hoping to help him find his way back home...
Des Moines - Central
Found: 8/29/2017
ID: 6652
Name: Unknown
Type: Cat
Color: Black and grey
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Baby
Was seen on Sunday out downtown and taken in on tuesday night.
Des Moines - Central
Found: 8/29/2017
ID: 6651
Name: Unknown
Type: Cat
Color: Black and grey
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
Was seen on Sunday out downtown and taken in on tuesday night.
Johnston
Found: 8/27/2017
ID: 6607
Name: Tank
Type: Dog
Color: Black white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Waukee
Found: 8/26/2017
ID: 6606
Name:
Type: Dog
Color: Blond
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Young
He's safe in my backyard.
Johnston
Found: 8/26/2017
ID: 6605
Name: Tank
Type: Dog
Color: Black white
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Adult
66th Ave
Cedar Rapids
Found: 8/25/2017
ID: 7192
Name: Don’t know, I just call him Blondie
Type: Cat
Color: Blone with blonde and white striped tail
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
He is still hanging around my back deck like he lives here! He has chased away my outside cat so now my cat lives inside and out front. Probably because I made the mistake of feeding him but I did not want him to go hungry.
Ankeny
Found: 8/25/2017
ID: 6601
Name: Ellie
Type: Dog
Color: Brown/tan
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on NW 6th Drive, Ankeny, IA going towards Sailorville. $200 REWARD IF FOUND!!!!
Ankeny
Found: 8/25/2017
ID: 6600
Name: Ellie
Type: Dog
Color: Brown/tan
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on NW 6th Drive, Ankeny, IA going towards Sailorville. $200 REWARD IF FOUND!!!!
Ankeny
Found: 8/25/2017
ID: 6596
Name: Ellie
Type: Dog
Color: Tan/brown
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Was lost at Praire Trail neighborhood in Ankeny. She is very small and skiddish
Des Moines - South
Found: 8/25/2017
ID: 6592
Name: unknown
Type: Cat
Color: white
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
She walked in to car dealership at 4611 SW 9th st Des Moines
Ankeny
Found: 8/24/2017
ID: 6612
Name:
Type: Cat
Color: Grey/black/tan tiger striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Came onto our deck in NW Ankeny. Very Friendly. Vet said he is neutered.