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>='1474588800')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 9/28/2016
ID: 3964
Name: Finn
Type: Cat
Color: Black
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
He's friendly, curious, loves his butt (on top by the base of his tail) patted. He was last seen at the Bennett Grand Woods apartments in WDSM.
Des Moines - East
Lost: 9/27/2016
ID: 3966
Name: Birdie
Type: Dog
Color:
Breed: Russian Blue
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen walnut and down town sculpture park 3801 grand area
Des Moines - North
Lost: 9/27/2016
ID: 3962
Name: Reggie
Type: Dog
Color: Orange and white
Breed: Brittany Spaniel
Gender: Male
Fixed: Neutered
Age: Young
4042 Oxford Street, Des Moines, Iowa has microchip, 38 to 40 pounds, small Brittany.
Des Moines - East
Lost: 9/27/2016
ID: 3958
Name: Trouble
Type: Dog
Color: Red
Breed: Dachshund-Miniature
Gender: Male
Fixed: Neutered
Age: Adult
25th & Logan
Cherokee
Lost: 9/26/2016
ID: 3971
Name: DeDe
Type: Cat
Color: Grey Tabby
Breed: Dachshund-Miniature
Gender: Female
Fixed: Neutered
Age: Adult
She is an indoor/outdoor cat and comes in every night; But she hasn't been home for three nights. She does prowl and explore quite a bit, so she may have strayed far away as the neighboring towns. She is a small cat with big ears, green eyes, her nose is mostly grey/black with a little bit of pink
Marion
Lost: 9/26/2016
ID: 3954
Name: Thunder
Type: Dog
Color: Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Adult
On Terrace St in mrion
Ankeny
Lost: 9/26/2016
ID: 3951
Name: Daisy
Type: Dog
Color: White/orange
Breed: Brittany Spaniel
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 9/25/2016
ID: 3955
Name: Lefty
Type: Dog
Color: Black white brown
Breed: Brittany Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - East
Lost: 9/25/2016
ID: 3950
Name: Lefty
Type: Dog
Color: Black white brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
Ankeny
Lost: 9/25/2016
ID: 3949
Name: Hank
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
In Ankeny on NW Hickory. He's very loving, but is declawed in the front. He is NOT an outside cat, broke the window screen out. Microchip is not registered to us either. Please help! His brother misses him!