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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Iowa City
Lost: 6/26/2017
ID: 5995
Name: Sunday
Type: Cat
Color: Black w/orange and white
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Near Twain in Iowa City. Never been outside. We'll be scared and hard to catch. Call if you see her. 319-541-7392
Ankeny
Lost: 6/26/2017
ID: 5988
Name: Gary
Type: Dog
Color: Brown black white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Fletcher estates ne ankeny
Des Moines - South
Lost: 6/25/2017
ID: 6908
Name: Linc
Type: Cat
Color: Tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Less than a year old. White begins under his chin. Pink paws with a few black markings on bottom feet. Last seen on the 300 block of Hartford Ave.
Mitchellville
Lost: 6/25/2017
ID: 6136
Name: MoMA ki
Type: Cat
Color: Black and White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Thomas Mitchell Park, kids scared her , I miss her very much , I was not allowed to catch her where she was hiding
Mitchellville
Lost: 6/25/2017
ID: 6135
Name: MoMA ki
Type: Cat
Color: Black and White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
She is at Thomas Mitchell Park and was hiding at camp host , they did not allow me to catch her , said they would, then said she has moved on. But I think she is still hiding under their very low deck and happy but she has never had fleas or ticks and was not treated , she gets scared around kids
Redfield
Lost: 6/25/2017
ID: 6047
Name: Cheech
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 6/25/2017
ID: 5989
Name: Leo
Type: Cat
Color: white and grey
Breed: Ragdoll
Gender: Male
Fixed: Neutered
Age: Adult
Asbury
Lost: 6/25/2017
ID: 5984
Name: Beanz
Type: Dog
Color: Black/tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Willow Wood Drive has never ran away. We let him out to potty and he disappeared.
Des Moines - North
Lost: 6/25/2017
ID: 5978
Name: Molly
Type: Dog
Color: White with tan spots
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Madison and Cornel area. She is very timid and not used to the area. We were visiting from Minnesota.
Des Moines - North
Lost: 6/25/2017
ID: 5977
Name: Bella
Type: Dog
Color: Grey
Breed: Rat Terrier
Gender: Unknown
Fixed: Neutered
Age: Adult
At home. Got out gate.
Des Moines - Central
Lost: 6/24/2017
ID: 6119
Name: Brinks ??
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
**REWARD** I am looking for the lady that picked up a brindle Pit Bull on Saturday, June 24th in the Des Moines area. She drives a blue Chevy Silverado 1500. I have the license plate number but do not want to give it out unless needed. The dog was taken to the Animal Rescue League only to be turned away. From my understanding, the lady was bringing the dog to Ottumwa to Heartland Humane Society but never arrived. However, I am receiving conflicting stories from both agencies. This dog is my dog that someone stole from me three years ago. To find her after three years is unbelievable but to find her and lose her again in the same day is heartbreaking. She is microchipped and I have all the paperwork to prove that the dog is mine. I am offering a reward to anyone who provides information that leads to her safe return. I live in Kansas City so I am unfamiliar with the Des Moines area and have limited as to what resources may be available help so please share this with everyone you can! If you have any questions feel free to contact me anytime at 816-885-0848. Thank you in advance for your help.
Des Moines - East
Lost: 6/24/2017
ID: 5972
Name: Boogie
Type: Dog
Color: red/white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
East 14th and Cleveland ave area. he is very friendly and loves everyone. He is red with a white chest and white that is shaped like the letter J on the back of his neck. he has white on his paws.
Des Moines - East
Lost: 6/23/2017
ID: 5975
Name: Kinzie
Type: Dog
Color:
Breed: Alaskan Husky
Gender: Female
Fixed: Not Applicable
Age: Adult
East 42nd and Hubbell area with a Pomeranian
Des Moines - East
Lost: 6/23/2017
ID: 5974
Name: Teddy
Type: Dog
Color:
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Adult
Teddy is or was traveling with a Siberian Husky
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.