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>='1585785600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 8/11/2018
ID: 9360
Name: Izzy
Type: Dog
Color: Brown
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Adult
Escaped from the back yard. Skittish. Scared of men.
Des Moines - Central
Lost: 8/10/2018
ID: 9355
Name: Zoltar
Type: Dog
Color: Black & White
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
He was last seen by the BP on SW 9th just south of the Cityville Apartments. He is very friendly but can be skiddish. He slipped out of his collar so he will not have one on him.
Altoona
Lost: 8/10/2018
ID: 9354
Name: Cooper
Type: Dog
Color: Brown
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Senior
Altoona
Lost: 8/10/2018
ID: 9353
Name: Cooper
Type: Dog
Color: Brown
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Senior
Ankeny
Lost: 8/10/2018
ID: 9351
Name:
Type: Dog
Color: White / yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
At our home off of sw 41st ct 50023
Johnston
Lost: 8/10/2018
ID: 9347
Name:
Type: Dog
Color: Black, tan
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
Beaver ave and 54th
Des Moines - East
Lost: 8/9/2018
ID: 9397
Name: Shadow
Type: Cat
Color: Grey tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
14th and Dean. He is a very loving cat. He has some very distinct features. He is a polydactyl on 3 paws also has a half tail.
Des Moines - East
Lost: 8/9/2018
ID: 9348
Name: King
Type: Dog
Color: Brown and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
If anyone finds him please don’t let him outside by himself and call 515-313-5977
Des Moines - South
Lost: 8/9/2018
ID: 9344
Name: Kiwi
Type: Bird
Color: Green
Breed: Parrot
Gender: Unknown
Fixed: Unknown
Age: Baby
She was last seen by skate south she is very friendly and does answer to my kiwi there is a $100 reward
Des Moines - South
Lost: 8/9/2018
ID: 9340
Name: skip
Type: Dog
Color: Black
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Senior
Heading east on Summit Vista (east side of SW 31st) He's very friendly, chipped and has two tags on. (Owners live on Summit Vista) Cathy: 867.6688 mobile 244.4779 home
Ames
Lost: 8/8/2018
ID: 9419
Name: Trudy Lou
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen 56934 245th Street, SE of Ames. Green eyes, scared of strangers, very quiet meow.
Jewell Junction
Lost: 8/8/2018
ID: 9359
Name: Dora
Type: Cat
Color: Black and white Tuxedo
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen sleeping on our porch about the morning of the 8th
Des Moines - South
Lost: 8/8/2018
ID: 9352
Name: Chloe
Type: Dog
Color: white with tan spots
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Park Avenue and SW 9th area
Des Moines - South
Lost: 8/8/2018
ID: 9339
Name: Jax
Type: Dog
Color: Black/brown
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Young
Put outside chained up around 9 pm 937 gone
Des Moines - Central
Lost: 8/7/2018
ID: 9346
Name: Persephone/ Percy
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is freshly spayed so her belly is shaved. Last in the Sherman Hill neighborhood
Des Moines - Central
Lost: 8/7/2018
ID: 9334
Name:
Type: Dog
Color: Black
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Adult
19th and Keo
Paton
Lost: 8/6/2018
ID: 9441
Name: Casey
Type: Dog
Color: White/Grey/Brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - North
Lost: 8/6/2018
ID: 9336
Name: Layla
Type: Dog
Color: White
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Adult
We believe she was taken. Please help if anyone knows of her whereabouts.
Des Moines - North
Lost: 8/6/2018
ID: 9335
Name: Layla
Type: Dog
Color: White
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
Let her out to go potty and we believe she was taken. Please anyone tht has seen her, please help return our baby!!!
Altoona
Lost: 8/6/2018
ID: 9326
Name: Yogi
Type: Dog
Color: Brown and white
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
LOST IN SW side of Altoona. He hoppped our fence.
Ankeny
Lost: 8/5/2018
ID: 9457
Name: Marcel
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 8/5/2018
ID: 9323
Name: Lily
Type: Dog
Color: White and brindle
Breed: American Bulldog
Gender: Unknown
Fixed: Neutered
Age: Baby
Last seen in the vicinity of East 23rd and Guthrie in Des Moines
Des Moines - East
Lost: 8/5/2018
ID: 9318
Name: Dallas and sky
Type: Dog
Color: One black one tan
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
Two dogs black one dallas tan one blue collar named sky
Des Moines - Central
Lost: 8/5/2018
ID: 9311
Name:
Type: Dog
Color: Black
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Found dragging a long metal chain
Des Moines - West
Lost: 8/4/2018
ID: 9338
Name: Alex
Type: Dog
Color: Black and white
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Unknown
Age: Young
Last seen at approximately 715 PM. Around 24th and Rollins Ave