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 = 'lost' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1579046400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 8/2/2019
ID: 12044
Name: Nugget
Type: Cat
Color: Orange Tabby
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
north of Union Park. Has breakaway black collar. Front declawed. Friendly but might run at first. Likes to be scratched under the chin. Has freckles on his nose. Microchipped.
Ankeny
Lost: 8/2/2019
ID: 12023
Name: Tankers
Type: Dog
Color: Lights brown white chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Ankeny Four mile NE29th Ave He’s very friendly and he’s our baby please call 515 201-9042
Ankeny
Lost: 8/2/2019
ID: 12022
Name: Tankers
Type: Dog
Color: Light brown white chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Four mile NE 29th Ave He’s very friendly and gentle He’s our baby please call 515 201-9042
Des Moines - Central
Lost: 8/1/2019
ID: 12058
Name: Señor
Type: Cat
Color: Tabby brown striped
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
May have been in a fight with new cat in the neighborhood. I was on vacation.
Laurens
Lost: 8/1/2019
ID: 12035
Name: Jinxy
Type: Cat
Color: Orange/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He will be scared .not use to noises please call asap if found...very gentle cat but again will be scared
Waukee
Lost: 8/1/2019
ID: 12014
Name: Piper
Type: Dog
Color: Tri color
Breed: Beagle
Gender: Unknown
Fixed: Neutered
Age: Adult
Seen around fox creek park. Small boys chased but couldn’t catch her.
Des Moines - Central
Lost: 8/1/2019
ID: 12013
Name: Liberty
Type: Dog
Color: Tan white
Breed: Siberian Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
Ankeny
Lost: 8/1/2019
ID: 12012
Name: Ivy
Type: Cat
Color: Tortie
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Responds to Ivy and may run from strangers. Likes to hide in bushes. Does not get along with other cats.
Delhi
Lost: 7/31/2019
ID: 13270
Name: BlackJack
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Delhi
Lost: 7/31/2019
ID: 13269
Name: BlackJack
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Delhi
Lost: 7/31/2019
ID: 13268
Name: BlackJack
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Delhi
Lost: 7/31/2019
ID: 13267
Name: BlackJack
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Delhi
Lost: 7/31/2019
ID: 13266
Name: BlackJack
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Delhi
Lost: 7/31/2019
ID: 13265
Name: BlackJack
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Delhi
Lost: 7/31/2019
ID: 13264
Name: BlackJack
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Delhi
Lost: 7/31/2019
ID: 13263
Name: BlackJack
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
$$ I'M OFFERING A $500 REWARD FOR HIS RETURN $$ BlackJack was Last Seen July 31st 2019 At 10 Franklin St. Delhi,Iowa He is a short haired smaller male cat He is all black and sometimes walks with a limp from when he was younger and had a broken hip He has a Green BLue marking on his stomach from when he was nuetered He will be 3 Years old Next Month PLEASE,PLEASE,PLEASE CALL IF YOU HAVE SEEN HIM! 563 608-0324
Grand Mound
Lost: 7/31/2019
ID: 12025
Name: Max
Type: Dog
Color: Yellow
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
On 225 th street Grandmound very friendly also very timid around men
Grand Mound
Lost: 7/31/2019
ID: 12024
Name: Max
Type: Dog
Color: Yellow
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
On 225 th street Grandmound very friendly also very timid around men
Spencer
Lost: 7/30/2019
ID: 12113
Name: Cooper
Type: Dog
Color: Chestnut
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Very friendly 3-year old dog. His favorite thing to do is play fetch, literally is always bringing something to you to throw for him. Last seen north of Spencer, Iowa.
Grand Mound
Lost: 7/30/2019
ID: 12027
Name: Max
Type: Dog
Color: Yellow
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
With other dog ash who was found this afternoon. last seen on 225th. very loveable and friendly tends to be very timid around men
Des Moines - North
Lost: 7/30/2019
ID: 12008
Name: Skippy
Type: Cat
Color: Black, grey belly
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Black, long hair, fluffy tail, grey fur on belly
Des Moines - East
Lost: 7/30/2019
ID: 12005
Name: Levi
Type: Dog
Color: Brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Missing from the AE Dairy area. Very good with other Dogs and Cats, not good with younger children.
Ames
Lost: 7/30/2019
ID: 12003
Name: Iro
Type: Cat
Color: White and Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen out of SUV Complex in North Ames
Ames
Lost: 7/29/2019
ID: 12373
Name: Suerte
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Baby
Yellow eyes. Dark pigmentation on iris on left eye. Long canines. 3 white whiskers on right side, 1 on left side. Grayish hair on underside. castrated 10 year old male cat. bushy tail, loves flicking his tail. Name is Suerte really loves softcan food. He is microchipped. Suerte is very loved and missed! He doesn't like being held but appreciated being scratched under chin and behind ear.
Des Moines - West
Lost: 7/29/2019
ID: 12037
Name: Skittles
Type: Cat
Color: Tan multi
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior