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>='1618444800')) ORDER BY pm1.meta_value DESC, post_date DESC
Delhi
Lost: 7/31/2019
ID: 13267
Name: BlackJack
Type: Cat
Color: Black
Breed:
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:
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:
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:
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
Pleasant Hill
Lost: 7/29/2019
ID: 12032
Name: Buddy
Type: Dog
Color: Golden
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Wilton
Lost: 7/29/2019
ID: 12017
Name: Orion
Type: Cat
Color: White and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen around the rest stop he ran in the bushes near the fence area
Ankeny
Lost: 7/29/2019
ID: 12001
Name: Josie
Type: Cat
Color: White/black/gold. calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
Courtyards of Rock Creek Ankeny
Casey
Lost: 7/29/2019
ID: 11999
Name: Stanford
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He got out late in the afternoon. He is an indoor cat and doesn’t know his way around the neighborhood. Very friendly but he may be scared since he has never done this before.
Des Moines - West
Lost: 7/29/2019
ID: 9684
Name: Kiara
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Reposting this to see if anyone has seen this guy. Has been missing since 09/28/2018. Around Merle Hay and Holcomb. He is chipped. You can call or text me. Or email f.lynn@mchsi.com
North Liberty
Lost: 7/28/2019
ID: 11985
Name: Dahli
Type: Dog
Color: White w/ brown spots
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in west lake area of north liberty. SUPER friendly.
Ankeny
Lost: 7/28/2019
ID: 11983
Name: Jonah
Type: Dog
Color: Tan
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Jonah was found and returned to us. Thank you all for your sincere help with his safe return. THANKS SO MUCH
Des Moines - Central
Lost: 7/28/2019
ID: 11982
Name: Bonnie
Type: Dog
Color: Brown with some black on face and stuff
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on 13th and Laurel kinda by dmacc urban and cheatom park
Bondurant
Lost: 7/27/2019
ID: 12096
Name: Ashes
Type: Cat
Color: Grey brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Last seen in kadin trl bondurant got out when where moving trying shes a lil standoffish and comes off mean but shes has alot a family missing her
Story City
Lost: 7/27/2019
ID: 12031
Name:
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Lost near Doolittle Prairie south of Story City. House cat that escaped.
Story City
Lost: 7/27/2019
ID: 12030
Name:
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
House cat that found an open door. Was not wearing her collar. Lost south of Story City near Doolittle Prairie.