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>='1461888000')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 5/4/2016
ID: 2845
Name: Soffi
Type: Dog
Color: Black
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
She slipped out of collar while on tie out ... Nw side of ankeny
Ankeny
Lost: 5/3/2016
ID: 2844
Name: Oscar
Type: Cat
Color: tortoise shell calico (chocolate face)
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
ran out my door in ankeny. She has a pink collar. The bow tie has been chewed off.
West Des Moines
Lost: 5/3/2016
ID: 2843
Name: Tyke
Type: Cat
Color: Brown tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Bridgewood subdivision near Jordan creek, around 5pm may 3rd, hes friendly but skittish
Waukee
Lost: 5/3/2016
ID: 2842
Name: Camus
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Waukee, near NE Olivewood.
Maquoketa
Lost: 5/3/2016
ID: 2836
Name: Buddie
Type: Dog
Color: Black and tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Seen this morning let them or and they dug a hole and got out of the back yard they usually come back if no one picks them up Nashville between Baldwin and maquoketa they are very friendly
Maquoketa
Lost: 5/3/2016
ID: 2835
Name: Hauns
Type: Dog
Color: Black and grey
Breed: Schnauzer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen this morning let them out and they dug a hole and got out of the back yard they usually come home if they aren't picked up by someone they are pretty friendly won't bit
Des Moines - East
Lost: 5/3/2016
ID: 2830
Name: unknown
Type: Dog
Color: balck/tan
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Young
I have at my house with me
Long Grove
Lost: 5/3/2016
ID: 2828
Name: Penney
Type: Dog
Color: Black Brindle
Breed: Greyhound
Gender: Female
Fixed: Neutered
Age: Senior
She was at our house, 220th and 279th Long Grove, Iowa. She s small and very friendly. She has a kinked tail and her tags are on her collar.
Des Moines - South
Lost: 5/3/2016
ID: 2046
Name: Cocoa
Type: Dog
Color: Black
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Young
South Des Moines on Porter Ave and see 14th st.
Pleasant Hill
Lost: 5/2/2016
ID: 2832
Name: CC
Type: Cat
Color: Black/white
Breed: Pomeranian
Gender: Female
Fixed: Not Applicable
Age: Adult
Last seen on pine valley/burr oak...just moved to area and she wondered off. Has her claws, still. My little ones are missing her dearly.