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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - South
Lost: 8/22/2017
ID: 6591
Name: Harley
Type: Cat
Color: Black and brown
Breed: Tortoiseshell
Gender: Male
Fixed: Unknown
Age: Baby
Last seen SW 13th and Park Avenue area. Please contact 515 867 3445 if you have seen her.
Bondurant
Lost: 8/22/2017
ID: 6560
Name:
Type: Cat
Color: Black and orange
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
Very sweet, doesn't like strange cats. Was very hungry when we found her. Seems to have had human contact before
Grimes
Lost: 8/22/2017
ID: 6553
Name: Wynter
Type: Dog
Color: Liver (brown) and White
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Senior
Dog has an ACL repair and a torn ACL.
Des Moines - Central
Lost: 8/22/2017
ID: 6552
Name: Bolt
Type: Cat
Color: Gray
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Young
Found at the Dowling track on 8/22.
Windsor Heights
Lost: 8/22/2017
ID: 6548
Name: Bolt
Type: Cat
Color: Gray
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Young
Found at the Dowling track on 8/22. Taking to ARL on E 14th St.
Ankeny
Lost: 8/21/2017
ID: 6598
Name: Pickles
Type: Dog
Color: White-Brown
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Baby
Wood Spring Suite's extended stay hotel..
Ankeny
Lost: 8/21/2017
ID: 6597
Name: Pickles
Type: Dog
Color: White-Brown
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Around the Wood Spring Suites extended stay
Johnston
Lost: 8/21/2017
ID: 6561
Name: Freddie
Type: Cat
Color: Black and white Tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Last seen at Adam Ridge Condos at 8:00PM on Monday, August 21, 2017. He was on our patio and jumped to the ground, probably to chase an animal. We combed the entire apartment complex and called for him, but he must have been too afraid or too far away to respond. Very friendly and playful and a very tall, handsome boy. He loves raw meat. Sometimes he bites out of love. Please call (319) 427-1582 if you have any information. He's our baby and we miss him :'(