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>='1596240000')) ORDER BY pm1.meta_value DESC, post_date DESC
Earlham
Lost: 8/5/2019
ID: 12089
Name: Nadia
Type: Cat
Color: Grey with white chest and paws
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
I-80 Exit 104 W/B on ramp. Nadia ran into weeds/brush on north side of ramp @ 9:00 PM At time she escaped she had pink collar w/name & tag with phone #. Ear is notched. Well fed. She is E-X-T-R-E-M-E-L-Y MISSED!! REWARD FOR HER SAFE RECOVERY
Madrid
Lost: 8/5/2019
ID: 12067
Name: Major
Type: Dog
Color: Black tri
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
East of Madrid between Madrid and shedahl
Des Moines - South
Lost: 8/5/2019
ID: 12063
Name: Kiko
Type: Dog
Color: Golden brown
Breed: Shiba Inu
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Indianola road and SE 8th street. Across from Howe Elementary South DSM. Very friendly and loves our kids. Very food driven. Name is pronounced Key-Co. Please help us find him! Please call 515-779-8656
Ames
Lost: 8/4/2019
ID: 12091
Name: Grumpy
Type: Dog
Color: Red tick
Breed: English Coonhound
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen just south of Ames Iowa.
Pella
Lost: 8/4/2019
ID: 12061
Name: Peanut
Type: Cat
Color: Black
Breed: Manx
Gender: Unknown
Fixed: Neutered
Age: Young
She ran into the cornfield right next to Madison Middle School, in Pella Iowa. It was the cornfield behind the apartments when she broke out of her carrier. She is extremely nervous and is probably terrified. Shes a sweetheart. She’s an inside cat. She has on a pink breakaway collar and might be still wearing purple sparkle claw caps. She has dullish green-yellow eyes. She loves wet food so may be lured that way.
Des Moines - North
Lost: 8/4/2019
ID: 12057
Name: Nema
Type: Dog
Color: Fawn
Breed: Doberman Pinscher
Gender: Female
Fixed: Not Applicable
Age: Adult
On the corner of Beaver Ave and Hickman Rd.
La Motte
Lost: 8/4/2019
ID: 12055
Name: Zolon
Type: Dog
Color: Reddish brown
Breed: Australian Cattle Dog
Gender: Male
Fixed: Neutered
Age: Young
Aka “Zo”
La Motte
Lost: 8/4/2019
ID: 12054
Name: Rory
Type: Dog
Color: Brown/chocolate
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Young
Likes to play “ball” and can get very timid with loud noises
Ankeny
Lost: 8/4/2019
ID: 12051
Name: Lilly
Type: Dog
Color: White and brindle
Breed: American Bulldog
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 8/3/2019
ID: 12066
Name: Can’te
Type: Cat
Color: Grey/Tan some stripes
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
He went missing on NE 3rd street Two houses from Cornell Elementary School. He's a grouchy Lil guy and hes very fat.
Des Moines - East
Lost: 8/3/2019
ID: 12042
Name: Duke
Type: Dog
Color: White
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 8/3/2019
ID: 12041
Name: Duke
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Lost: 8/3/2019
ID: 12028
Name: Tankers
Type: Dog
Color: Light brown white chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
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: 13324
Name: Storm
Type: Dog
Color: Tan
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the Mason City area but has since been given to someone in the Des Moines area. She needs to be reunited with her rightful owner and family!
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