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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 4/11/2019
ID: 10993
Name: Ernie
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Went missing somewhere between Wednesday night and Thursday morning. Has a distinctive bobbed tail
Des Moines - East
Lost: 4/10/2019
ID: 11011
Name: Daisy
Type: Cat
Color: Black and Gray
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Unsure of how she got out but cannot find her anywhere in the house. No collar very friendly
West Des Moines
Lost: 4/10/2019
ID: 11007
Name:
Type: Cat
Color: Grey striped
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
He comes and mews. Looks inside. Eats dry food
Des Moines - East
Lost: 4/10/2019
ID: 10999
Name: Smokie
Type: Dog
Color: BLK,white,grey
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
I let him out to potty at 3am wed. Nite/early Thursday morning. He took off and haven't seen since. He's 8 yrs. Old but could be mistaken for a puppy. Had on blue T-shirt says BRC and neon yellow collar w/ tags. We miss him terribly. He came missing from fairground/DM/PL.hill area. Call 515)447-1722 please help get him home
Dubuque
Lost: 4/10/2019
ID: 10984
Name: Pico
Type: Cat
Color: Light Orange and white stripes
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 4/9/2019
ID: 11008
Name: Pennoyer
Type: Cat
Color: Tortoise shell
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
I live in Newton but think she might have ridden under my car to the drake neighborhood when I went to school the other morning. Pennoyer is very vocal and curious but is scared of children. Such a cuddly little thing. Please call me if you see her, she comes to “P-baby” 6412751935
Ankeny
Lost: 4/9/2019
ID: 10991
Name: Pearl
Type: Cat
Color: Light siamese - light gray with darker gray strips
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Pearl is very soft and loves treats. She is about 10-11 lbs. She lives off of Oralabor Rd. on Snyder Blvd. We believe she got out of the house on 4/9/19 or possibly the morning of 4/10/19. She is not very skiddish. I have had her since she was 4 weeks old and she will be 3 next month. She is updated on all vaccines and does not bite or scratch. If you see her, PLEASE contact me at 515-720-5523. My name is Ema. We all miss her very much.
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