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>='1555113600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 4/9/2019
ID: 10977
Name: Brutus
Type: Dog
Color: Black and White
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Baby
Lost 4/9/19 East 42nd st. And Douglas
Pleasant Hill
Lost: 4/9/2019
ID: 10973
Name: Ruby
Type: Dog
Color: white and gold
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
By four mile elementary Could be near runnels also.
Des Moines - East
Lost: 4/9/2019
ID: 10972
Name: Kujo
Type: Dog
Color: Black and white
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
Last since when we let him out to go to the bathroom and he got out the back Gate and hasn’t came back home
Ames
Lost: 4/9/2019
ID: 10971
Name: Alice
Type: Cat
Color: White and Black
Breed: Mix
Gender: Female
Fixed: Not Applicable
Age: Adult
Around 1107 Delaware ave in ames iowa. Has feline leukemia
Des Moines - East
Lost: 4/9/2019
ID: 10970
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Her name is Sammie, she is lost with a yellow lab named Buzz. They are probably together
Des Moines - East
Lost: 4/9/2019
ID: 10969
Name:
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
His name is Buzz he is lost with a black lab named Sammie
West Des Moines
Lost: 4/9/2019
ID: 10968
Name: Mojo
Type: Cat
Color: Grey with stripes
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Probably scared. Has never been out before.
West Des Moines
Lost: 4/9/2019
ID: 10967
Name: Mojo
Type: Cat
Color: Grey with stripes
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Probably scared. Is 8 and has never gotten out before.
West Des Moines
Lost: 4/8/2019
ID: 11014
Name: Dove
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Not Applicable
Age: Young
Near maple grove villas in west Des Moines.
Des Moines - South
Lost: 4/8/2019
ID: 11006
Name: Miley
Type: Cat
Color: Dark grey
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
She was last seen at SW 12th Pl. and Thornton Ave. If someone brought her inside please contact me!
Indianola
Lost: 4/8/2019
ID: 11001
Name: Thor
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen April 8th. He is friendly. He has all his claws.
Des Moines - South
Lost: 4/8/2019
ID: 10992
Name: Miley
Type: Cat
Color: Dark Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
She was last seen at the cross streets of SW 12th Pl and Thornton Ave. She is all dark grey with green eyes and might be scared of you because she’s never been gone from home this long.
Remsen
Lost: 4/8/2019
ID: 10983
Name: Smuckers
Type: Dog
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Monday afternoon, please call Kim 712-501-2169.
Remsen
Lost: 4/8/2019
ID: 10982
Name: Ebony
Type: Dog
Color: Black/Tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Baby
Monday afternoon...please call Kim 712-501-2169.
Remsen
Lost: 4/8/2019
ID: 10981
Name: Smuckers
Type: Dog
Color: Black
Breed: Schnauzer
Gender: Male
Fixed: Neutered
Age: Young
Monday afternoon
Dubuque
Lost: 4/8/2019
ID: 10976
Name: Frankie
Type: Dog
Color: White/Brown
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Young
Last seen in our side fenced in yard on 1200 block of Lincoln, Dubuque Iowa. Neighbors thought they saw a black Tahoe stop in the street around the time he was last seen and thought a Mexican guy with glasses and short dark hair got out and was looking in breezeways for dogs to steal. It was a newer black Tahoe with a bunch of kids in the car. Unknown if this is what happened for sure though. Any information would be appreciated and 500 dollar reward for safe return.
Madrid
Lost: 4/8/2019
ID: 10965
Name: Belle
Type: Cat
Color: Black/brown
Breed: Pekingese
Gender: Female
Fixed: Unknown
Age: Young
Madrid
Lost: 4/8/2019
ID: 10964
Name: Belle (Kitty)
Type: Cat
Color: Black, brown tint on belly
Breed: Pekingese
Gender: Unknown
Fixed: Unknown
Age: Young
Johnston
Lost: 4/8/2019
ID: 10959
Name:
Type: Dog
Color:
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - West
Lost: 4/8/2019
ID: 10958
Name: Billy
Type: Dog
Color: White and Gray
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Young
613 E 26th st des moines IA 50317
Des Moines - North
Lost: 4/8/2019
ID: 10954
Name: Bindi Boy
Type: Dog
Color: Fawn
Breed: Pug
Gender: Unknown
Fixed: Unknown
Age: Young
New to us and he got out of his harness. No collar and skittish. Contact Amanda Pitts @ (515)771-8014.
Hartford
Lost: 4/7/2019
ID: 11024
Name: Royal
Type: Dog
Color: Brown/Black
Breed: Dachshund
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a weiner dog/German Shepard/pitbull mix, he’s long & short I let him outside to play out back & he got out & didn’t come home. Didn’t have his collar because his sister had been tearing at it. He’s a very sweet dog.
Des Moines - East
Lost: 4/7/2019
ID: 10975
Name: Jasper
Type: Cat
Color:
Breed: Dachshund
Gender: Male
Fixed: Not Neutered
Age: Young
He got out as I was letting my dog out the Morning of 4-7-19. He usually comes to his name. He is not declawed either.
Des Moines - East
Lost: 4/7/2019
ID: 10974
Name: Jasper
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
He got out as I was letting my dog out the Morning of 4-7-19. He usually comes to his name. He is not declawed either.
Urbandale
Lost: 4/7/2019
ID: 10960
Name: Chicago
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He is missing part of his right ear. Very friendly, comes to his name and microchipped. If you have seen him please contact us.