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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 4/4/2019
ID: 10918
Name: Sam
Type: Cat
Color: Tabby, white paws and chest
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Senior
Lost approximately at 8:15 am Never been outside. Has microchip. Claws in back only.
Des Moines - Central
Lost: 4/4/2019
ID: 10916
Name: Lucille
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Senior
In front yard
Ankeny
Lost: 4/4/2019
ID: 10914
Name: Sam
Type: Cat
Color: Tabby with white paws
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Senior
Last seen 8:00AM. Sam has never been outside. Back claws only
Corydon
Lost: 4/3/2019
ID: 11459
Name: Gizzy
Type: Dog
Color: Blond
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
3:30 am April 3, 2019
Melbourne
Lost: 4/3/2019
ID: 10998
Name: Manny
Type: Dog
Color: White with grey
Breed: Great Pyrenees
Gender: Male
Fixed: Neutered
Age: Baby
Melbourne
Lost: 4/3/2019
ID: 10997
Name: Manny
Type: Dog
Color: White with grey markings
Breed: Great Pyrenees
Gender: Male
Fixed: Neutered
Age: Young
Lovable...missing my big guy. Doesn't like riding in vehicles.
Martensdale
Lost: 4/3/2019
ID: 10934
Name: Darby
Type: Cat
Color: Grey and White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She's and outdoor farm cat who usually doesn't wonder off. She's missing the tip of her tail and had the cutest pink nose
Des Moines - Central
Lost: 4/3/2019
ID: 10928
Name: Pickles
Type: Cat
Color: Gray with black stripes
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Please anyone who lives in the area of University and mlk over toward drake if you see a cat similar to this can you let me know. my uncle was taking his cat pickles to pet startch hospital on 2222 university ave. Between 22nd and 23rd on university. The cat got out of his cage and got away from him running toward drake park. He is very skittish and timid of people. We could not find a picture of him but found this one that is similar. Please contact me if anyone happens to see him running around the neighborhood. He is also very skittish.
Des Moines - East
Lost: 4/3/2019
ID: 10915
Name: Hershey
Type: Cat
Color: Brown tan and white
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen last night.
Ankeny
Lost: 4/3/2019
ID: 10912
Name: COSMO
Type: Dog
Color: White with brown spots
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Baby
11:00 in North Side of Ankeny off of Ankeny Delaware Ave. He loves car rides and will jump in the car with someone. Super friendly pup who thinks that it is a fun game to run from people chasing him.
Johnston
Lost: 4/2/2019
ID: 10909
Name: Ollie
Type: Cat
Color: Grey with stripes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 8:30pm. Has been out all night
Johnston
Lost: 4/2/2019
ID: 10908
Name: Ollie
Type: Cat
Color: Grey with stripes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 8:30pm. Has been out all night
Des Moines - West
Lost: 4/2/2019
ID: 10904
Name: Iris
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Baby
Found! Thank you!
Urbandale
Lost: 4/1/2019
ID: 11057
Name: Chicago
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 4/1/2019
ID: 10911
Name: Leo (Lay-o)
Type: Cat
Color: Grey with darker grey stripes/spots. White underbelly.
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He slipped out through a door left open overnight. He was seen the evening of the first of April. He likes catnip and wet food, or else he may not come when he is called. He is friendly and likes to be pet (if he doesn't run away from you, he tends to do that outside). He doesnt like to be picked up, but will not be aggressive if you do. There will be a reward given if he is found and returned. We really want our kitty back!
Des Moines - Central
Lost: 4/1/2019
ID: 10900
Name: Jiles
Type: Cat
Color: Tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Very friendly but bites (gently)
Des Moines - South
Lost: 4/1/2019
ID: 10897
Name: Ginger
Type: Dog
Color: Brown/black
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Unknown
Age: Senior
Near 600 block of kenyon avenue
Urbandale
Lost: 4/1/2019
ID: 10895
Name: Gracie
Type: Dog
Color: Sliver, light tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Senior
Somehow got out of the house while at work. She is 12, skinny, and has some missing hair. She doesn't eat well because of her age and she battling a skin condition. She is microchiped with our information. She is shy, sweet, but friendly. She is loved, missed, and wanted home. She has some special needs, if anyone has her please return her home so we can get her what she needs.
Des Moines - North
Lost: 4/1/2019
ID: 10891
Name: Gage
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Friendly last seen corner of 38th Pl and Crestmoor Pl
Des Moines - North
Lost: 4/1/2019
ID: 10890
Name: Gage
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Friendly last seen corner of 38th Pl and Crestmoor Pl
Adel
Lost: 3/31/2019
ID: 10937
Name: Boots and Charlie
Type: Cat
Color: Black/white and Tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
They were just rehomed and wandered off.
Johnston
Lost: 3/31/2019
ID: 10892
Name: leo
Type: Cat
Color: tannish red, golden
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Collar has telephone of last owner. Leo has a noticeable limp. he is not injured. He has long hair. and some dark spots on the lips and a missing fang.
Des Moines - East
Lost: 3/31/2019
ID: 10886
Name: Abbi
Type: Dog
Color: beige and white
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Senior
e 27th and university . could be seen with small black dog who is half shaven named Zoey
Des Moines - East
Lost: 3/31/2019
ID: 10885
Name: Abbi
Type: Dog
Color: beige and white
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Senior
near 27th ct and university
Des Moines - East
Lost: 3/31/2019
ID: 10877
Name: Rosco
Type: Dog
Color: Black and brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Running out my door and up 33rd court