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>='1575417600')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Lost: 3/30/2019
ID: 10880
Name: Bella
Type: Cat
Color: Calico
Breed:
Gender: Male
Fixed: Unknown
Age: Young
Bella is wearing a collar with a tag.
New Virginia
Lost: 3/30/2019
ID: 10879
Name: Buddy
Type: Dog
Color: Yellow/white
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
He is 11 years old & has health issues (heart, arthritis & seizures) plus large fatty deposits by his hind legs. He also has a skin tag above his right eye that bleeds if bumped; He has a microchip and is very friendly. He was last seen about 7:30 p.m. on Saturday evening.
Des Moines - East
Lost: 3/30/2019
ID: 10872
Name: June
Type: Cat
Color: Grey black and white
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Got out by pleasant hill/ williams and university area
Ankeny
Lost: 3/29/2019
ID: 10874
Name: Ferris Bueller Langner
Type: Cat
Color: See photo
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Door didn’t latch shut and he snuck out. Very loving and and needs lots of pets. Missed by many! Lost in Willow Run area-new development.
Des Moines - South
Lost: 3/29/2019
ID: 10871
Name: Maya
Type: Cat
Color: Black/white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Off Hart Ave and Southlawn Dr
Des Moines - South
Lost: 3/29/2019
ID: 10870
Name: Maya
Type: Cat
Color: Black/white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Off Hart Ave and Southlawn Drive
Des Moines - South
Lost: 3/29/2019
ID: 10864
Name: Simba
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Baby
SW 14th st
Des Moines - Central
Lost: 3/29/2019
ID: 10863
Name: Hershel
Type: Cat
Color: Orange Tabby
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Hershel went missing Wednesday morning, 3/20. He was last seen near Forest and 14th. A friend attempted to catch him last night,, but he did not cooperate and squeezed out of his collar. He is hiding in the area. Hershel very sweet, fluffy and orange, will be timid but does not bite or scratch. He was responding with meows to “tongue clicks” and his name. Reward for any information.
Ackworth
Lost: 3/29/2019
ID: 10554
Name: Sadie
Type: Dog
Color: Brown and white
Breed: Saint Bernard
Gender: Female
Fixed: Not Neutered
Age: Adult
last seen February 4th around 168th and McKinley St in Ackworth. Surrounding towns would be Indianola and Milo. She is very sweet but very bashful with strangers. She disappeared in the early morning the thick fog was rolling in. She is still missing! 515-689-3649
Dexter
Lost: 3/28/2019
ID: 11010
Name: Felix
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly. He likes to get into vehicles which is probably why he's gone
Des Moines - Central
Lost: 3/28/2019
ID: 10868
Name: Tinks
Type: Cat
Color: White with brown and gray stripes
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
We miss him badly. He is probably scared as he is an inside cat. He has a collar with name address and phone but it is a quick release. He was set up for nurturing on Monday.
Des Moines - South
Lost: 3/28/2019
ID: 10856
Name: KeKe
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
We live near Scandia Avenue and SE 5th. The cat is a rescue so she’s a little intimidated but always nice.
Des Moines - Central
Lost: 3/28/2019
ID: 10850
Name: Dave
Type: Cat
Color: White Grey Brown
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - West
Lost: 3/28/2019
ID: 10846
Name: Harley
Type: Dog
Color: Black white with Black and Tan spots
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Baby
Very timid just 12 weeks and not use to people but our family!
Des Moines - South
Lost: 3/27/2019
ID: 10859
Name: Cocoa
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen Thursday afternoon. She is very friendly. Is wearing a purple and gold University of Northern Iowa collar.
Corydon
Lost: 3/27/2019
ID: 10854
Name: Gizmo
Type: Dog
Color: Blonde and brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
Was in my parents yard and then gone. My mom older dog was left. I offering a reward for the safe return
Des Moines - Central
Lost: 3/27/2019
ID: 10851
Name: Bear
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
27th
Des Moines - South
Lost: 3/27/2019
ID: 10845
Name: Pete
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
My puppy got out last night and we can’t find find him. Golden retriever about 4 months old. South union by pleasant st. Please let me know if any one has him. His name is Pete. He has a black collar on with silver studs.
Bondurant
Lost: 3/27/2019
ID: 10842
Name: C3PO
Type: Dog
Color: Fawn
Breed: Greyhound
Gender: Male
Fixed: Neutered
Age: Young
C3PO is a greyhound who goes by the name C. He was last seen in the cornfields on the northwest side of Bondurant at around 6:00 PM. We had him in our sights for a long time but he slipped us and headed northwest. He is probably hiding somewhere as he is exhausted, mud coated and wet. C is EXTREMELY skittish of everything. Please DO NOT approach him. If you see him please call me (Natasha) at 515-720-6071 or Heartland Greyhound Adoption at 515-967-6564 -- anytime day or night!
Mount Pleasant
Lost: 3/27/2019
ID: 10840
Name: Ruby
Type: Dog
Color: Black and brown
Breed: Greyhound
Gender: Male
Fixed: Not Neutered
Age: Baby
Mount Pleasant
Lost: 3/27/2019
ID: 10839
Name: Ruby
Type: Dog
Color: Black and brown
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Baby
Perry
Lost: 3/26/2019
ID: 10940
Name: Jasmine
Type: Cat
Color: Tiger stripes with white and brown
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Young
Last seen in Perry fleeing her home. She got out thru the garage and fled after the car started and scared her.
West Des Moines
Lost: 3/26/2019
ID: 10878
Name: Nikka
Type: Cat
Color: Tan
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Senior
By woodland avenue by valley high school
Hamilton
Lost: 3/26/2019
ID: 10857
Name: Azra
Type: Cat
Color: Grey and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Baby
Des Moines - South
Lost: 3/26/2019
ID: 10834
Name: Hunter lee
Type: Dog
Color: Mostly black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around south union and park ave.