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
Williamsburg
Lost: 8/28/2016
ID: 4014
Name: Trooper
Type: Dog
Color: brown & black
Breed: Mastiff
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in rural Williamsburg. He is a mastiff / rottweiler cross. Very friendly. He crossed over the invisible fencing with our doberman. But the doberman returned the next day alone (they never separate). Trooper would get in any ones car.
Williamsburg
Lost: 8/28/2016
ID: 4013
Name: Trooper
Type: Dog
Color: brown & black
Breed: Mastiff
Gender: Male
Fixed: Neutered
Age: Baby
Last seen in rural Williamsburg. He is a mastiff / rottweiler cross. Very friendly. He crossed over the invisible fencing with our doberman. But the doberman returned the next day alone (they never separate). Trooper would get in any ones car.
Glenwood
Lost: 8/28/2016
ID: 3969
Name: Callista
Type: Cat
Color: Brownish-grayish, white belly, white spots on back
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
She has food and topical medicine sensitivities. She is a very sweet cat and greatly missed!!!!!
Huxley
Lost: 8/28/2016
ID: 3776
Name: Petra
Type: Cat
Color: Grey and White
Breed: Domestic Medium Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen nursing her 4 kittens.Kittens are home with me,but no one in neighborhood has seen her either.
Harvey
Lost: 8/28/2016
ID: 3760
Name: Sir Remmington III
Type: Dog
Color: red
Breed: Bloodhound
Gender: Male
Fixed: Neutered
Age: Adult
Last reported sighting was in the park in Harvey IA.SUV. No other sightings, missing since August 28th.
Sioux City
Lost: 8/28/2016
ID: 3752
Name: Oakley
Type: Cat
Color: Gray and black tiger color
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
Ankeny
Lost: 8/26/2016
ID:
Name: Avery
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Last seen on NW 2nd pl Ankeny She's very loved and missed by her whole family but especially by my daughter. She is declawed in the front. Slipped out back door and escaped fenced in yard. Please let us know if u see her
Ankeny
Lost: 8/26/2016
ID: 3721
Name: Avery
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Last seen on NW 2nd pl Ankeny She's very loved and missed by her whole family but especially by my daughter. She is declawed in the front. Slipped out back door and escaped fenced in yard. Please let us know if u see her
Maxwell
Lost: 8/25/2016
ID: 4698
Name: Joey
Type: Cat
Color: Gray
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He snuck out of my sons room window....we miss him horribly..everyone says hes gone but a part of me is trying everything to find my sons baby hes very friendly will walk right up to you!
Maxwell
Lost: 8/25/2016
ID: 4697
Name: Joey
Type: Cat
Color: Gray
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He snuck out of my sons room window....we miss him horribly..everyone says hes gone but a part of me is trying everything to find my sons baby hes very friendly will walk right up to you!
Essex
Lost: 8/25/2016
ID: 3726
Name: Lucy
Type: Dog
Color: Black Tri colored
Breed: Bernese Mountain Dog
Gender: Female
Fixed: Not Neutered
Age: Young
Also German shepherd male 7 months old both are 7 months old.
Des Moines - North
Lost: 8/25/2016
ID: 3712
Name: Evee
Type: Dog
Color: Brown, White, Grey, Black
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen around the Harding Hills/MLK Jr Pkwy Hy-vee parking lot. Please contact me as she need eye drops daily! 515-729-9109
Bondurant
Lost: 8/25/2016
ID: 3709
Name: Emily
Type: Cat
Color: Grey
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
One of her eyes turn in to her nose.
Des Moines - East
Lost: 8/24/2016
ID: 3720
Name: Lucky
Type: Dog
Color: Black
Breed: Pinscher
Gender: Male
Fixed: Neutered
Age: Young
On Prospect Rd Des Moines, IA 50310
Des Moines - West
Lost: 8/24/2016
ID: 3719
Name: Lucky
Type: Dog
Color: Black
Breed: Pinscher
Gender: Male
Fixed: Neutered
Age: Young
On Prospect Rd Des Moines, IA. 50310
West Des Moines
Lost: 8/24/2016
ID: 2384
Name: Lady
Type: Dog
Color: All white except for some Cream and white mix on ears
Breed: Maltese
Gender: Female
Fixed: Unknown
Age: Adult
Reward $1000 cash for safe return *******HOW TO IDENTIFY LADY, LOOK AT RIGHT EYE****** I know all these dogs look a like. This is how you will know if it's Lady or not. Black eye rims except a little place on the lower right corner of eye. THIS PHOTO SHOWS JUST ONE OF THE MARKINGS. Maltese/Shihtzu still missing Name Lady Gender- Female Main Color- White Cream and mixed white on ears only age- Young adult weight -10 pounds Lady's nose is black. Tail curls up towards the back Lady could be any where as much time has past. Lady is on facebook******* PLEASE SHARE****** https://www.facebook.com/profile.php?id=100006846254924
Redfield
Lost: 8/23/2016
ID: 3755
Name: Lilly
Type: Cat
Color: Grey Tiger
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Young
Long and slender, looks like shes wearing black lipstick.
Des Moines - Central
Lost: 8/23/2016
ID: 3722
Name: Prince
Type: Cat
Color: Black&white
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at home on woodland and 27th street by Sherman hill. 50312
West Des Moines
Lost: 8/23/2016
ID: 3703
Name: Penny
Type: Bird
Color: Grey with Mauve tail
Breed: African Grey
Gender: Female
Fixed: Unknown
Age: Young
Penny flew from our house at 511 38th Street in West Des Moines and headed west around 6:00 p.m. Tuesday evening. The wind was blowing north west. She can talk and may come to someone who has a crinkly bag of ships, crackers, cereal, etc.... She says, Peek-a-boo,, I love you, mommy, can you hear me, etc....
La Porte City
Lost: 8/22/2016
ID: 4763
Name: sox
Type: Cat
Color: black and white
Breed: African Grey
Gender: Male
Fixed: Unknown
Age: Adult
lost around E. Tama Rd. La Porte City no claws
Persia
Lost: 8/22/2016
ID: 3711
Name: Marley Maybelle
Type: Cat
Color: tortoiseshell calico back legs orange shaved with lion cut
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
corner of 1st Ave & Framp/Vienna
Altoona
Lost: 8/22/2016
ID: 3705
Name: Josie
Type: Cat
Color: Black and tan striped with an orange patch on back
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Baby
Josie was last seen in the evening on Monday 8/22/16. She did not come inside for the night and was not back the next day. She is about 5 months old has not yet been spayed. She is black and tan striped (short hair) with a patch of orange hair on her back close to her tail. She is very sweet but likes to run when trying to be caught. She purrs ALOT and rarely meows. She still has claws on all four.
Des Moines - East
Lost: 8/22/2016
ID: 3698
Name: Olaf
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen around east 19th and Logan in Des moines Iowa, we are adding a $200.00 reward please help us find our baby
Stuart
Lost: 8/21/2016
ID: 3931
Name: Leo
Type: Cat
Color: Grey and tan with Black stripes on legs - black behind paws
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Young
Kum n' Go in Stuart. Please read pic description for details about him. REWARD!!!
Stuart
Lost: 8/21/2016
ID: 3926
Name: Leo
Type: Cat
Color: Grey with Black stripes on legs - black behind paws
Breed: Pixie-Bob
Gender: Male
Fixed: Neutered
Age: Young
Lost at the Kum and Go in Stuart Iowa - very sweet and friendly - I miss him very much. He has a micro - chip # 911001001386116 - please call 951-249-6799 if found. Thanks Geri