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 - Central
Lost: 5/26/2018
ID: 8681
Name:
Type: Bird
Color:
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Young
West Des Moines
Lost: 5/26/2018
ID: 8674
Name:
Type: Dog
Color: White
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Young
Robin Hill apartments
Clive
Lost: 5/25/2018
ID: 8673
Name: Lola/Roly
Type: Dog
Color: Orange
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Senior
At home. Gate was open. She has bad back legs and some dementia.
Waukee
Lost: 5/25/2018
ID: 8671
Name: Ollie
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
Last seen in a field south on Alice’s road In Waukee
Des Moines - North
Lost: 5/25/2018
ID: 8662
Name: Oliver
Type: Cat
Color: Gray/brown toger
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at my residence snuck out of the house, He has done this before but has always come back home on his own never gone overnight He is a very nice boy and friendly
Ankeny
Lost: 5/24/2018
ID: 8717
Name: Tigger
Type: Cat
Color: Gray, white & tan
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He has all his claws, loves cheese & liked his back & tail stroked, does not like him tummy touched
Des Moines - West
Lost: 5/24/2018
ID: 8702
Name: Oliver
Type: Cat
Color:
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Senior
Snuck out of the house in the 2800 block of 62nd street in between urbandale Avenue and Hickman road. He is still missing on May 29th and has not returned home as he has in the past. He is an indoor cat and very friendly, he weighs about 10 pounds and is 14 years old, We have always lived in the same place since he was 6 weeks old. I miss him Terribly. If you have seen him or found him please call (515) 360-9575
Des Moines - Central
Lost: 5/24/2018
ID: 8656
Name: Karma and faith
Type: Dog
Color: Brown white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Baby
1248 55th st
Des Moines - Central
Lost: 5/24/2018
ID: 8655
Name: Faith
Type: Dog
Color: Brown and white
Breed: Basset Hound
Gender: Unknown
Fixed: Unknown
Age: Adult
Ankeny
Lost: 5/23/2018
ID: 8834
Name: Thea
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Declawed on front paws.
Iowa City
Lost: 5/23/2018
ID: 8768
Name: Dexter
Type: Dog
Color: Liver - white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Dexter has two collars on one with our name and phone number, the other is a Petsmart electronic collar to keep him in our yard.
Des Moines - Central
Lost: 5/23/2018
ID: 8654
Name: Coco
Type: Dog
Color: Black, white, copper
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 5/23/2018
ID: 8652
Name: Unknown
Type: Dog
Color: Orange/black
Breed: Pomeranian
Gender: Unknown
Fixed: Unknown
Age: Young
She is very sweet and house trained. She also has a flea collar on too.
Des Moines - East
Lost: 5/23/2018
ID: 8649
Name: Bo
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
He's a pit lab mix. Absolute sweet heart got out by ripping our kitchen screen open.
Grimes
Lost: 5/22/2018
ID: 8698
Name: Milo
Type: Cat
Color: Grey/white
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Johnston
Lost: 5/22/2018
ID: 8692
Name: Sebastian is his name but he goes by Kiki
Type: Cat
Color: Browns and black
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
We live in Johnston clear past Merle hay Road down towards that dead end on 54th He goes by kee kee
Des Moines - North
Lost: 5/22/2018
ID: 8661
Name: Paco
Type: Cat
Color: Black/white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Paco. Male. Fixed. Friendly. And talkative! He’s an indoor and outdoor cat. Haven’t seen him in two days and getting worried. He lives near NE 39th and Douglas Ave. He is not chipped. He will most likely come if you have tuna or ice cream. Please let me know if you see him around!
Elkhart
Lost: 5/22/2018
ID: 8651
Name: Sophie and Phoebe
Type: Dog
Color: Sophie is white, Phoebe is blond
Breed: Poodle Standard
Gender: Female
Fixed: Not Neutered
Age: Young
Running north on NE 29th St toward the Elkhart Road. Will probably still be together as they have been since birth. Phoebe is shy, but Sophie is very friendly. Call me at 515 360 0654 Look like fluffy Poodles
Grimes
Lost: 5/22/2018
ID: 8646
Name: Milo
Type: Cat
Color: Grey and white
Breed: Poodle Standard
Gender: Male
Fixed: Neutered
Age: Adult
Altoona
Lost: 5/22/2018
ID: 8643
Name: Krull
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
2nd ave NW
Des Moines - East
Lost: 5/22/2018
ID: 8639
Name: Bandit
Type: Dog
Color:
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Adult
by fairgrounds
Des Moines - South
Lost: 5/21/2018
ID: 8707
Name: Billy
Type: Cat
Color: Orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen south side off of 9th st on Taylor st. Area Across from McRae park. We are new to area so he got lost when he went outside.
Cumming
Lost: 5/21/2018
ID: 8680
Name: Tinsel
Type: Cat
Color: Silver Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Very shy, small notch top of R. ear
Pella
Lost: 5/21/2018
ID: 8650
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 5/21/2018
ID: 8644
Name: Willow
Type: Cat
Color: gray
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Will sometimes come if called with a treat.