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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Ames
Found: 5/29/2019
ID: 11462
Name: Unknown
Type: Cat
Color: Tan/gray and white tabby
Breed:
Gender: Male
Fixed: Not Neutered
Age: Young
Found in North Ames. Will be adopted on 6/5 if no one comes forward with proof-of-ownership.
Des Moines - East
Found: 5/29/2019
ID: 11458
Name: Tucker
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
He’s been found!
Des Moines - East
Found: 5/29/2019
ID: 11456
Name: Tucker
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on 14th and university
Urbandale
Found: 5/29/2019
ID: 11452
Name: Jesse
Type: Cat
Color: Buff tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
Found in the 6500 block of Urbandale.
Urbandale
Found: 5/28/2019
ID: 11467
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Very sweet loving little boy showed up at 147th and Meredith after terrible storms. Used to being inside with lots of attention
Ames
Found: 5/28/2019
ID: 11449
Name:
Type: Cat
Color: Black and White
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
8:00 pm 05/28/19 Believed to be a female, but could be a neutered male. Maybe one year old. No collar. Tame, but cautious, won't be petted, but will stay close to eat. Seems underfed, not aggressive.
Ames
Found: 5/28/2019
ID: 11448
Name:
Type: Cat
Color: Black and White
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
8:00 pm 05/28/19 Believed to be a female. Maybe one year old. No collar. Tame, but cautious, won't be petted, but will stay close to eat.
West Des Moines
Found: 5/28/2019
ID: 11447
Name:
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on 8000 block of Mill Civic Pkwy
West Des Moines
Found: 5/28/2019
ID: 11446
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found on 1200 block of 64th St.
West Des Moines
Found: 5/26/2019
ID: 11432
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - South
Found: 5/26/2019
ID: 11427
Name: unknown
Type: Dog
Color: Black, brown and tan
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
Found dragging stake and leash down SW 16th St.
Urbandale
Found: 5/25/2019
ID: 11422
Name: Unknown
Type: Dog
Color: Brown and White
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Urbandale area
Des Moines - Central
Found: 5/24/2019
ID: 11418
Name: Unknown
Type: Dog
Color: Black and white
Breed: Spaniel American Cocker
Gender: Female
Fixed: Unknown
Age: Senior
She was found around 39th and Douglas and is now at 48th and Urbandale. She is very sweet and in good care until we find her owner(s)!
Des Moines - North
Found: 5/24/2019
ID: 11417
Name:
Type: Dog
Color:
Breed: Boxer
Gender: Unknown
Fixed: Unknown
Age: Baby
West Des Moines
Found: 5/24/2019
ID: 11412
Name:
Type: Cat
Color: gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
300 block of 34th Street
Pleasant Hill
Found: 5/24/2019
ID: 11411
Name:
Type: Dog
Color: Black
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Senior
Altoona
Found: 5/23/2019
ID: 11404
Name: Pinky
Type: Cat
Color: White and caramel
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in the back yard. He would be in the neighborhood by Sam Wise sports complex. He is afraid of strangers.
Clive
Found: 5/23/2019
ID: 11403
Name:
Type: Cat
Color: Gray tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found at McAllisters Deli
West Des Moines
Found: 5/21/2019
ID: 11392
Name:
Type: Rabbit
Color: Brown and Tan
Breed: Himalayan
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines area.
Des Moines - South
Found: 5/20/2019
ID: 11390
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 5/20/2019
ID: 11383
Name:
Type: Dog
Color: Brown/black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - West
Found: 5/19/2019
ID: 11373
Name: Myrtle
Type: Cat
Color: Gray
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Young
Des Moines - South
Found: 5/19/2019
ID: 11370
Name: Bo
Type: Dog
Color: Brown, Black, Lots of Gray spots esp. face
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Senior
Around 11:30 am 5-19-2019. Live around Racoon River spillway - possibly lost around river bank. Grandma watching him and neglected to letch him up. Usually pretty good and just running for awhile and coming back. He is a lovable country dog - needed to run. Tags are not on him at the moment but are current. Has a microchipe.
Waukee
Found: 5/18/2019
ID: 11371
Name: Unknown
Type: Dog
Color: Mostly black with brown on legs and white on chest.
Breed: Papillon
Gender: Female
Fixed: Unknown
Age: Adult
Found around 7pm on 5/18 in Waukee near Ashworth Dr. and 2nd St.
Des Moines - South
Found: 5/18/2019
ID: 11362
Name: Lady
Type: Dog
Color: Faun
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Unknown
Age: Adult
McKinley Ave and SW 16th