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>='1463788800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 5/26/2016
ID: 3004
Name: Zeak
Type: Dog
Color: Black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
He escaped out of a yard in des monies. Need to find him!! Family's are missing him!!
Johnston
Lost: 5/26/2016
ID: 3003
Name: Rowdy
Type: Dog
Color: Brown with white wiry hair
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
By Camp Dodge compound; and NW 70 and Merle Hay. just set paws in Iowa. friendly but skittish.
West Des Moines
Lost: 5/26/2016
ID: 2999
Name: Beau
Type: Cat
Color: White and gray/black tiger stripe
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 2901 Elm West Des Moines
Des Moines - East
Lost: 5/26/2016
ID: 2998
Name: Titan
Type: Dog
Color: Light Brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Last seen late yesterday evening. Has black collar and two dog license tags one dark pink. Will answer to his name if called.
Windsor Heights
Lost: 5/26/2016
ID: 2997
Name: Cheyenne
Type: Dog
Color: Black
Breed: Border Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
Off Euclid
Des Moines - East
Lost: 5/25/2016
ID: 3000
Name:
Type: Dog
Color:
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Baby
Last seen on East 30th at home in Douglas acres des moines
Muscatine
Lost: 5/25/2016
ID:
Name: Miju
Type: Cat
Color: Multicolor
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
This morning. She has krange eyes, she loves the chicken flavored temptations treats for cats, she is very talkative and friendly and has a "raccoon" tail with dark stripes.
Muscatine
Lost: 5/25/2016
ID: 2990
Name: Miju
Type: Cat
Color: Multicolor
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
This morning. She has krange eyes, she loves the chicken flavored temptations treats for cats, she is very talkative and friendly and has a "raccoon" tail with dark stripes.
Des Moines - West
Lost: 5/24/2016
ID: 2996
Name: Sammy
Type: Cat
Color: russian blue (gray)
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
seen at 112 45th St (home) Sammy is a sweet big house cat. Purrs 24-7. Did this a year ago and was found hiding in a neighbor's garage. $25 reward. Thanks for looking!
Des Moines - North
Lost: 5/24/2016
ID: 2987
Name: kitty
Type: Cat
Color: tiger stripped
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Adult
last seen at home on the northside by the house. She is very loving and can be shy at first. If you have a bag of food and shake it she will come a running.