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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Altoona
Lost: 5/16/2018
ID: 8597
Name: Monkey
Type: Cat
Color: Grey and black striped tiger
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Money is a small 9 month old grey and black tiger striped cat. She is very friendly and loves to sneak out if our home.
Ankeny
Lost: 5/16/2018
ID: 8590
Name: Charlie
Type: Cat
Color: Yellow
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Indoor cat escaped through door left ajar. Front declawed. Somersby neighborhood
Des Moines - East
Lost: 5/16/2018
ID: 8583
Name: Buddy Boty
Type: Dog
Color: Black & Tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Baby
at home around noon, must have got out when got mail.Very friendly, licks everyone. No Collar but micro chipped. 7 months old about 4 lbs. Tongue hangs out to side of mouth.
Des Moines - West
Lost: 5/15/2018
ID: 8616
Name: Puddin Pop
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Puddin got out Tuesday evening and hasn’t been spotted since. He’s gotten out before but always returns. Very friendly but also very feisty.
Des Moines - East
Lost: 5/15/2018
ID: 8601
Name: Pearl
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She was purposefully let out by a spiteful EX the day we were supposed to pick her up. She is pretty friendly but very very scared. If you try to feed her put the food down and back away. She wont take it from your hand.
Altoona
Lost: 5/15/2018
ID: 8595
Name:
Type: Cat
Color: Ginger and some ehite
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
White paws, front declaw, and orange heart shaped spot on right paw. Indooor only cat.
Des Moines - North
Lost: 5/15/2018
ID: 8582
Name: Snickers
Type: Dog
Color: Brown and black with some gray hair
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
He was last seen in our backyard going to potty. He is a small yorkie terrier.
Des Moines - East
Lost: 5/15/2018
ID: 8581
Name: Snickers
Type: Dog
Color: Black and Tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
He was last seen in our front yard, he’s very friendly. We’d like for Snickers to come back home to us :(
Des Moines - Central
Lost: 5/15/2018
ID: 8575
Name: Blue
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Adult
37th and University
Davenport
Lost: 5/14/2018
ID: 8672
Name: Garflied
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
We saw him the day before he went missing he's never been missing before he's big, fluffy and lovable that loves milk and lasinga*
Des Moines - East
Lost: 5/14/2018
ID: 8585
Name: Casper
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - East
Lost: 5/14/2018
ID: 8584
Name: Casper
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 5/14/2018
ID: 8572
Name: ash
Type: Cat
Color: gray with black strips
Breed: Maltese
Gender: Male
Fixed: Unknown
Age: Baby
by capital avenue 24 street
Des Moines - North
Lost: 5/14/2018
ID: 8567
Name: Sophie
Type: Dog
Color:
Breed: Unknown
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Cambridge St. Between Hull Ave and Sheridan . She is very friendly bit I'm sure scared. She has never gotten out of the yard before.
Des Moines - West
Lost: 5/14/2018
ID: 8566
Name:
Type: Dog
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Lost: 5/14/2018
ID: 8564
Name: Snickers
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Senior
Des Moines - West
Lost: 5/14/2018
ID: 8563
Name: Unknown
Type: Dog
Color: Brown
Breed: Bichon Frise
Gender: Male
Fixed: Unknown
Age: Young
Found wandering at 42nd & Kingman Blvd.
Des Moines - Central
Lost: 5/14/2018
ID: 8562
Name: Rammus
Type: Cat
Color: Orange and white
Breed: Bichon Frise
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 5/14/2018
ID: 8561
Name: Cloud
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 5/14/2018
ID: 8557
Name: Bob
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen in my yard around 1:00 p.m. He has a neurological condition that causes his head to bob around, hence his name.
Des Moines - Central
Lost: 5/14/2018
ID: 8556
Name: Coco
Type: Dog
Color: white
Breed: Cockapoo
Gender: Female
Fixed: Neutered
Age: Adult
3721 Lincoln Place Drive, south of Grand Ave.
Des Moines - South
Lost: 5/13/2018
ID: 8587
Name: Nene
Type: Dog
Color: Gray-brown-black-white
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 5/13/2018
ID: 8568
Name: Mufasa
Type: Cat
Color: Orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly. Has gooey eyes from allergies.
Windsor Heights
Lost: 5/13/2018
ID: 8552
Name: Riley
Type: Dog
Color: Black/brown
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Adult
Mini doberman
Des Moines - East
Lost: 5/13/2018
ID: 8549
Name: Annie
Type: Dog
Color: red
Breed: Setter
Gender: Female
Fixed: Not Neutered
Age: Young
last seen around the fair around 8pm