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>='1560470400')) ORDER BY pm1.meta_value DESC, post_date DESC
Windsor Heights
Found: 9/13/2017
ID: 6789
Name:
Type: Dog
Color: Tan/blonde
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Young
Found around 66th and University in the street with no collar on
Des Moines - North
Found: 9/11/2017
ID: 6780
Name:
Type: Dog
Color: Brown
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Found: 9/10/2017
ID: 6756
Name:
Type: Dog
Color:
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
Windsor Heights
Found: 9/9/2017
ID: 6777
Name: Baby
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
His front right leg has a deformity from birth. It looks like he's hurt but he is not.
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!!!!