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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - South
Lost: 7/28/2019
ID: 11979
Name: Fat Fat
Type: Dog
Color: Brown & White brindle
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Posting for a friend. Lives, and took off near SW 9th & unknown street, in Des Moines.
Bondurant
Lost: 7/27/2019
ID: 12096
Name: Ashes
Type: Cat
Color: Grey brown
Breed: Unknown
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
Bondurant
Lost: 7/27/2019
ID: 12095
Name: Ashes
Type: Cat
Color: Grey brown
Breed: Tabby
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.
Orange City
Lost: 7/27/2019
ID: 11990
Name: Frank
Type: Dog
Color: Red-brown and white
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
1-2 miles west and north of Orange city.
Des Moines - South
Lost: 7/27/2019
ID: 11988
Name: Rasco
Type: Cat
Color: Black and white
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen at 4200 park ave area
Ames
Lost: 7/27/2019
ID: 11976
Name: Kya
Type: Cat
Color: Brown/Grey
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Kya was last seen roaming our backyard. She always returns especially by meal times. She is typically a friendly non shy cat. She has orange striping on her front and face. She weighs 7.5-8 lbs.
Marion
Lost: 7/27/2019
ID: 11971
Name: Chance
Type: Dog
Color: White with black black ears and a black spot on his back
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Adult
Winslow road Marion
Des Moines - Central
Lost: 7/26/2019
ID: 12049
Name: Lucy
Type: Dog
Color: Black & White
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Very friendly but do not chase! She has an underbite and her face is all black.
Ankeny
Lost: 7/26/2019
ID: 12004
Name: Ghostface Killah
Type: Cat
Color: Orange / apricot
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 7/26/2019
ID: 11991
Name: Sam
Type: Cat
Color: Brownish black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in the Ewing Trace Trailer Park. Never misses breakfast in the morning, but haven't seen him for 2 mornings. He is 13 years old, most of the time he is friendly, unless you provoke him. STILL HAS ALL CLAWS
Des Moines - East
Lost: 7/26/2019
ID: 11980
Name: Teddy
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Knows his name. Is skinny due to kidney disease and sneezes.
Monroe
Lost: 7/26/2019
ID: 11969
Name: Buddy
Type: Dog
Color: White
Breed: American Eskimo Dog
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in the town of Monroe. Very skittish. Don’t chase. Get low and approach slowly
Des Moines - East
Lost: 7/26/2019
ID: 11968
Name: Kiwi
Type: Dog
Color: Black (black spotted tongue)
Breed: Shiba Inu
Gender: Male
Fixed: Not Neutered
Age: Young
6:30 pm. On 32nd court
Bondurant
Lost: 7/25/2019
ID: 11965
Name: Kittie
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Cedar Falls
Lost: 7/25/2019
ID: 11962
Name: Tiny
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen on the evening of 7/25 he is very comfortable outside as he used to be a farm cat, and is okay around people might be a little hazy of new people. Responds to Tiny if found call (319) 859-5387
Des Moines - South
Lost: 7/25/2019
ID: 11959
Name: Nala
Type: Dog
Color: Brown and black
Breed: Rottweiler
Gender: Female
Fixed: Not Neutered
Age: Young
Behind 2011 King Ave in the woods chasing my cat. She is not trained will bark or chase you. Nala is my pet too. She is a Rottweiler and wolf mix.
Des Moines - East
Lost: 7/25/2019
ID: 11958
Name: Gus
Type: Dog
Color: White
Breed: Rottweiler
Gender: Male
Fixed: Neutered
Age: Young
By Grandview park. Street Don Lee Court
Des Moines - North
Lost: 7/25/2019
ID: 11957
Name: Jack
Type: Dog
Color: Black
Breed: Chiweenie
Gender: Male
Fixed: Neutered
Age: Adult
42 and Madison
West Des Moines
Lost: 7/24/2019
ID: 11954
Name: Appa
Type: Cat
Color: White with brown spots
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at home, 60th and Vista Drive. Does not like to be chased, if you see him call his name and walk up to him nice and slow, he does spooked easily if you’re too aggressive. He’s very independent so I’m hoping he comes home on his own, if anyone has an already picked him up.