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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Bondurant
Lost: 6/23/2017
ID: 5964
Name: Harley
Type: Cat
Color: brown black and white on feet and chest
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
last seen around midnight this night when got home shes a friendly cat she is an emotional support cat.
Des Moines - East
Lost: 6/23/2017
ID: 5963
Name: Baby
Type: Dog
Color: Black and brown brindal, white legs
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
So last night around maybe midnight my boyfriend gets a call from his brother saying the dog got out, which in the six years i have been around has never happened not once even with the gate fully open. I think someone grabbed her from the yard if anyone sees or hears anything about this cute baby girl(her name) please let us know. She is a medium sized dog, brindal markings with a slightly dirty red collar and the sweetest thing you will ever meet. If you wouldn't mind sharing this so we have a little more chance of finding her that would be amazing ❤❤ She went missing late last night maybe a little before midnight around the fairgrounds/ A+E area. Also of you know of any other way i could get the word out to find her please let me know
Des Moines - South
Lost: 6/23/2017
ID: 5957
Name: Oreo
Type: Dog
Color: White w/Black Spots
Breed: Schnauzer Miniature
Gender: Male
Fixed: Not Neutered
Age: Adult
Toddler opened the door and he ran out - unknown which direction he went but usually he runs towards the Easter Lake area.
Des Moines - West
Lost: 6/23/2017
ID: 5956
Name: Lady
Type: Dog
Color: Black with Gray Face
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Lost from 40th and Hickman in Beaverdale
Story City
Lost: 6/22/2017
ID: 6075
Name: Topaz
Type: Dog
Color: Tri colored- Mostly black whit and brown face and legs
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the Story City green belt during a storm
Des Moines - South
Lost: 6/22/2017
ID: 5961
Name: Fay fay
Type: Cat
Color: White and orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Is my therapeutic cat and i dont know what i would do without him if you see him please contact me (641) 234 0859
Des Moines - South
Lost: 6/22/2017
ID: 5960
Name: Fayfay
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Willow park apartments. He ran out the apartment ran from me and haven't seen him since. Please if you have any info contact me it's my therapy cat.
Des Moines - South
Lost: 6/22/2017
ID: 5951
Name: Miracle
Type: Cat
Color: All black 3 legs
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Around 1110 davis ave
Granger
Lost: 6/21/2017
ID: 6044
Name: Cocolito
Type: Cat
Color: White and orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Last seen in Casey's Granger. We are desperate to found him, please if anyone finds me, call me!!!! We are offering a reward!
Granger
Lost: 6/21/2017
ID: 6014
Name: Cocolito
Type: Cat
Color: White and orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
He got lost in the Casey's Granger right next to the baseball park. He only has half of his tail and responds to Cocolito. We are desperate to find him!!!!!!
Pleasant Hill
Lost: 6/21/2017
ID: 5952
Name: Lily
Type: Dog
Color: White/gray
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
6560 SE Sundancer Swing Pleasant Hill, IA. Very friendly lovable dog. Loves people, especially children. Will run, if not on chain.
Granger
Lost: 6/21/2017
ID: 5950
Name: Cocolito
Type: Cat
Color: White and orange
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
Last seen in 1802 Sycamora St. in Casey's Granger. He only has half of his tail and responds to Cocolito.
Des Moines - North
Lost: 6/21/2017
ID: 5940
Name: Marvin
Type: Dog
Color: Black and Grey
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Adult
he has natural - uncut ears , and may be with a GSH pointer named Dotty
Des Moines - North
Lost: 6/21/2017
ID: 5939
Name: Dotty
Type: Dog
Color: Dark liver with white tick 1 big spot
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
may be with a schnauzer named Marvin
Des Moines - West
Lost: 6/20/2017
ID: 5935
Name: Buttercup
Type: Cat
Color: Gray with black strips
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Not Neutered
Age: Young
Just got lose at the days inn 1600nw114th st clive
Des Moines - West
Lost: 6/20/2017
ID: 5934
Name: Butter cup
Type: Cat
Color: Gray with black strips
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
She jumped out of my car at the days inn in Clive at 1600 nw 114th st. She is shy and can be scared of new ppl so don't move to fast. She usually responds to a higher pitch whistle.
Des Moines - South
Lost: 6/20/2017
ID: 5853
Name: Grey Boy
Type: Cat
Color: Grey (Looks brown in some spots in sunlight)
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Grey Boy was home for a few days and is now missing again. Based on where he was found and how long he was gone before turning up again I think someone has him in their house. If you have him or see him around SW 28th and Park Avenue please give me a call. Thank you.
Ames
Lost: 6/19/2017
ID: 5916
Name: Nico
Type: Dog
Color: Black and White
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
Very kind and healthy, last seen at 10:00am.
West Des Moines
Lost: 6/18/2017
ID: 5947
Name: Ray
Type: Bird
Color: yellow & grey
Breed: Cockatiel
Gender: Male
Fixed: Not Applicable
Age: Baby
Last seen/heard on Western Hills Drive. As of Wednesday, June 21st, we could not hear him. We have been walking around all day every day calling for him. He is very tame, so I am hoping he flew to a stranger because I'm sure he is very hungry and thirsty. If found, feel free to gently grab him as his bites do not hurt. He eats cooked pasta and rice, toast, and crackers (and water). He makes distressed, high-pitched squawks and also wolf whistles and makes kissing noises. He is my emotional support animal, so I am very depressed and distressed.I am offering a reward to anyone who can give me information about his whereabouts or return him to me.
Des Moines - North
Lost: 6/18/2017
ID: 5914
Name: Jerry
Type: Cat
Color: Ginger/orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Jerry slipped out through a screen in an open window overnight. He loves trying to dart outside and explore, but is an indoor cat. Lost near 52nd and Franklin.
Des Moines - Central
Lost: 6/18/2017
ID: 5913
Name: Dreamy
Type: Cat
Color: Orange tabby
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 6/17/2017
ID: 5941
Name: Pepè la Pew
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Comes to the name Pepè or Pepper
Windsor Heights
Lost: 6/17/2017
ID:
Name: Roxie
Type: Dog
Color: Black and brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Young
Windsor Heights
Lost: 6/17/2017
ID: 5905
Name: Roxie
Type: Dog
Color: Black and brown
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Young
She has a bald head and stomach. She is very sweet. only weighs about 3.5 and is very small.
Ankeny
Lost: 6/17/2017
ID: 5899
Name: Dudley
Type: Bird
Color: Grey/yellow head/ orange cheeks
Breed: Cockatiel
Gender: Male
Fixed: Unknown
Age: Adult
Around 5:00 pm. He whistles if your happy and you know it clap your hands, pretty boy, and jingle bells. Sometimes he just squawks repeatedly.