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
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.
Des Moines - North
Lost: 5/21/2018
ID: 8638
Name: Cuddles
Type: Dog
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
S.e. 14th and Broadway. She is a therapy dog she is very friendly and loving.
Des Moines - South
Lost: 5/21/2018
ID: 8637
Name: Ashley
Type: Dog
Color: White
Breed: Golden Retriever
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 5/21/2018
ID: 8636
Name: Ashley
Type: Dog
Color: Cream
Breed: Golden Retriever
Gender: Unknown
Fixed: Unknown
Age: Young
Cascade
Lost: 5/20/2018
ID: 8725
Name: Bones
Type: Dog
Color: All black w/white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
912 5th ave se Cascade, ia 52033
Des Moines - South
Lost: 5/20/2018
ID: 8647
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.
Indianola
Lost: 5/20/2018
ID: 8627
Name: Spitfire
Type: Cat
Color: Black and white tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
My mom was watching the house for us this weekend so not exactly sure how long he has been missing. He is a nice cat but a little shy and timid and hates being picked up. Contact Sami at 515-619-3737 or Jess at 515-639-5183
Indianola
Lost: 5/20/2018
ID: 8626
Name: Spitfire
Type: Cat
Color: Black and white tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
My mom was watching be house for us this weekend so we're not exactly sure how long he has been missing... He is a nice cat but he is shy and a little timid and hates being picked up and carried.
Des Moines - Central
Lost: 5/20/2018
ID: 8625
Name: Charlie Brown
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen on 14th ok and enos
Des Moines - South
Lost: 5/20/2018
ID: 6262
Name: Sunkist
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
On 4300 indianola ave he has a red cat dog guard collar on