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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Stanhope
Lost: 8/30/2017
ID: 6761
Name: Frank
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
5 month old puppy. Last seen on his porch at home in the country between Stanhope and Stratford.
Windsor Heights
Lost: 8/30/2017
ID:
Name: Julius
Type: Cat
Color: White with some grey
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
I can not load picture. He is just recently adopted about 2 months ago. He's an indoor cat so never has been outside. He's got blue/grey eyes and super bushy great tail. He got out at Colby Ave and 63rd. He's scared of people so I'm worry he's hiding and won't find his way home. He is chipped but does not wear collar.
Des Moines - East
Lost: 8/30/2017
ID: 6658
Name: Cash goes by Cash Cash
Type: Bird
Color: Green, red, yellow
Breed: Conure
Gender: Unknown
Fixed: Unknown
Age: Baby
He loves apples and he's a parrot so he is looking for a human to help him. Can be caught by throwing a towel on him if he doesn't come to you.
Ankeny
Lost: 8/30/2017
ID: 6644
Name: Ace
Type: Dog
Color: White and orange
Breed: Conure
Gender: Male
Fixed: Neutered
Age: Young
North side of Ankeny on high trestle trail.
Milo
Lost: 8/29/2017
ID: 6670
Name: Chewy
Type: Dog
Color: Tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Granger
Lost: 8/29/2017
ID: 6655
Name: Stark
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He's timid, especially around kids. If you see him please keep an eye on him and call.
Des Moines - Central
Lost: 8/29/2017
ID: 6648
Name:
Type: Cat
Color: Grey longhair
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
Found downtown around court avenue district
Des Moines - Central
Lost: 8/29/2017
ID: 6647
Name:
Type: Cat
Color: Grey longhair
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
Found downtown around court a venue
Altoona
Lost: 8/29/2017
ID: 6643
Name: Charlie
Type: Dog
Color: red/orangish brown with white patch on the top between the shoulders
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Senior
Has a sore on back of neck and right ear. Is 17 years old and friendly. will come to you if you call his name.
Urbandale
Lost: 8/29/2017
ID: 6642
Name: Milkshake
Type: Dog
Color: Grey/white
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Missing from 67th and Praire she is people friendly but does not like other dogs.
Des Moines - North
Lost: 8/29/2017
ID: 6637
Name: Bear
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 8/29/2017
ID: 6636
Name: Bear
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 8/29/2017
ID: 6635
Name: Bear
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Lost: 8/29/2017
ID: 6631
Name: Company
Type: Dog
Color: White
Breed: Samoyed
Gender: Male
Fixed: Neutered
Age: Young
Deer creek trail
Anamosa
Lost: 8/28/2017
ID: 6744
Name: Dale
Type: Dog
Color: Brown and white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Lost sometime before 4pm. Got out of his fenced in kennel.
Anamosa
Lost: 8/28/2017
ID: 6661
Name: Dale
Type: Dog
Color: Brown/white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen in his kennel. He found a weak spot in the fence. Dale also had a shock collar on.
Clive
Lost: 8/28/2017
ID: 6626
Name: Newt
Type: Cat
Color: cream
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
on Drake St near 73rd ave.
West Des Moines
Lost: 8/27/2017
ID: 6609
Name: Hank
Type: Dog
Color: Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Hank is a Mastador. He looks imposing but is a teddy bear. His owner, my housemate, is out of town. My name is Lacey, my pdone is 515-865-5812. Hank's current address is 121 28th Court, West Des Moines, 50265. He has all his shots, and he does not bite. He loves food, so that is a good way to lure him. He loves people, even ones he does not know.
Des Moines - South
Lost: 8/26/2017
ID: 6610
Name: D’Artagnan
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
By fluer Dr. He has no claws in front or back.
Carpenter
Lost: 8/25/2017
ID: 6618
Name: Herbie
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen with our other chihuahua on our farm
Urbandale
Lost: 8/24/2017
ID: 6586
Name: Buddy
Type: Dog
Color: Brown
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Adult
83rd and Prairie in Urbandale.
Des Moines - East
Lost: 8/24/2017
ID: 6580
Name: Gus
Type: Dog
Color: Chocolate
Breed: Weimaraner
Gender: Male
Fixed: Not Neutered
Age: Young
E 21st Street & Guthrie Ave
Des Moines - East
Lost: 8/24/2017
ID: 6579
Name: Gus
Type: Dog
Color: Chocolate
Breed: Weimaraner
Gender: Male
Fixed: Not Neutered
Age: Young
E 21st Street & Guthrie Ave
Jewell Junction
Lost: 8/24/2017
ID: 6578
Name: Leo
Type: Cat
Color: White w/ black mask & saddle
Breed: Weimaraner
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly ... no claws ... indoor cat
Waukee
Lost: 8/23/2017
ID: 6615
Name: Tails
Type: Cat
Color: grey/dark
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
At home fox creek estates