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>='1560384000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 5/15/2018
ID: 8575
Name: Blue
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Adult
37th and University
Davenport
Lost: 5/14/2018
ID: 8672
Name: Garflied
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
We saw him the day before he went missing he's never been missing before he's big, fluffy and lovable that loves milk and lasinga*
Des Moines - East
Lost: 5/14/2018
ID: 8585
Name: Casper
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - East
Lost: 5/14/2018
ID: 8584
Name: Casper
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 5/14/2018
ID: 8572
Name: ash
Type: Cat
Color: gray with black strips
Breed: Maltese
Gender: Male
Fixed: Unknown
Age: Baby
by capital avenue 24 street
Des Moines - North
Lost: 5/14/2018
ID: 8567
Name: Sophie
Type: Dog
Color:
Breed: Unknown
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Cambridge St. Between Hull Ave and Sheridan . She is very friendly bit I'm sure scared. She has never gotten out of the yard before.
Des Moines - West
Lost: 5/14/2018
ID: 8566
Name:
Type: Dog
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Lost: 5/14/2018
ID: 8564
Name: Snickers
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Senior
Des Moines - West
Lost: 5/14/2018
ID: 8563
Name: Unknown
Type: Dog
Color: Brown
Breed: Bichon Frise
Gender: Male
Fixed: Unknown
Age: Young
Found wandering at 42nd & Kingman Blvd.
Des Moines - Central
Lost: 5/14/2018
ID: 8562
Name: Rammus
Type: Cat
Color: Orange and white
Breed: Bichon Frise
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 5/14/2018
ID: 8561
Name: Cloud
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 5/14/2018
ID: 8557
Name: Bob
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen in my yard around 1:00 p.m. He has a neurological condition that causes his head to bob around, hence his name.
Des Moines - Central
Lost: 5/14/2018
ID: 8556
Name: Coco
Type: Dog
Color: white
Breed: Cockapoo
Gender: Female
Fixed: Neutered
Age: Adult
3721 Lincoln Place Drive, south of Grand Ave.
Des Moines - South
Lost: 5/13/2018
ID: 8587
Name: Nene
Type: Dog
Color: Gray-brown-black-white
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 5/13/2018
ID: 8568
Name: Mufasa
Type: Cat
Color: Orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly. Has gooey eyes from allergies.
Windsor Heights
Lost: 5/13/2018
ID: 8552
Name: Riley
Type: Dog
Color: Black/brown
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Adult
Mini doberman
Des Moines - East
Lost: 5/13/2018
ID: 8549
Name: Annie
Type: Dog
Color: red
Breed: Setter
Gender: Female
Fixed: Not Neutered
Age: Young
last seen around the fair around 8pm
Des Moines - East
Lost: 5/13/2018
ID: 8548
Name: Dixie
Type: Dog
Color: brown and white
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Baby
Got loose around the fair around 8pm
Des Moines - East
Lost: 5/13/2018
ID:
Name: Viper
Type: Dog
Color: White and black
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
He was out on our yard playing at around 7pm and soon before we knew it he was gone. We live on dean avenue, he could have wandered and not found his way back or someone took him. He is small and very affectionate, so we would not be surprised if he went with someone. It won’t let me upload a picture, but he is freshly groomed, is white with black spots all over his body, his ears are black, and the fur around one of his eyes is black as well. If anyone sees him please contact me. This is my baby
Ankeny
Lost: 5/13/2018
ID: 8543
Name: Goose
Type: Dog
Color: Black, brown and white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
Jumps a lot. Afraid of lawnmowers. One white spot on neck.
Des Moines - North
Lost: 5/12/2018
ID: 8578
Name:
Type: Dog
Color: White
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 5/12/2018
ID: 8577
Name:
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 5/12/2018
ID: 8535
Name: Sophie
Type: Dog
Color: Gray
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 5/12/2018
ID: 8529
Name: Annie
Type: Dog
Color: red
Breed: Setter
Gender: Female
Fixed: Not Neutered
Age: Young
last seen by the fair
Des Moines - East
Lost: 5/12/2018
ID: 8528
Name: Dixie
Type: Dog
Color: white with brown
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
last seen bybthe fairgrounds