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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
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
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