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>='1469232000')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 7/28/2016
ID: 3529
Name: Poodle
Type: Dog
Color: Black
Breed: Poodle Standard
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 2705 70th in Urbandale. He answers to Poodle. He is super friendly and loved very very much.
Grimes
Lost: 7/28/2016
ID: 3526
Name: Vertigo
Type: Cat
Color: Buff
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Went into corn field behind Parkview homes.
Ankeny
Lost: 7/27/2016
ID: 3517
Name: Mama Kitty
Type: Cat
Color: White tummy with black/grey stripe with tan.
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Senior
Late 7/26 early 7/27. She is 15 years old and I have had her since she was a baby. She mostly naps and has never ran away before. She is typically afraid of people but is harmless.
Newton
Lost: 7/26/2016
ID: 3528
Name:
Type: Cat
Color:
Breed: Snowshoe
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 7/26/2016
ID: 3527
Name:
Type: Cat
Color:
Breed: Snowshoe
Gender: Male
Fixed: Neutered
Age: Young
Neighbor reported to see him on a fence near my home on the 27th. The fact that he doesn't come when I call (which he does much like a dog) makes me think he got injured, lost or stolen. I do not believe he ran away.
Des Moines - West
Lost: 7/25/2016
ID: 3523
Name: Kitty
Type: Cat
Color: Gray
Breed: Snowshoe
Gender: Male
Fixed: Neutered
Age: Young
2901 Rutland Ave DM, Very friendly, but shy at first. Never been an outside cat. 9 months old, but big for his age.
Des Moines - West
Lost: 7/25/2016
ID: 3522
Name: Kitty
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
2901 Rutland Ave DM, Very friendly, but shy at first. Never been an outside cat. 9 months old, but big for his age.
North Liberty
Lost: 7/25/2016
ID: 3521
Name: Einstein
Type: Dog
Color: black with white chest, feet, and tip of his tail
Breed: Border Collie
Gender: Male
Fixed: Not Neutered
Age: Young
Einstein got loose near the Mehaffey Bridge area of North Liberty and has since been reported spotted at sugarbottom campground and also in the Fox Run neighborhood of North Liberty
Urbandale
Lost: 7/25/2016
ID: 3514
Name: Nixie
Type: Small or Furry
Color: Brown
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Young
Cedar Rapids
Lost: 7/25/2016
ID: 3513
Name: Bella
Type: Dog
Color: Chocolate brown
Breed: Shih Tzu
Gender: Female
Fixed: Not Applicable
Age: Young
She was last seen on mt.Vernon road next to highway 13. Please help us find our daughter's best friend