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>='1533772800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 10/31/4916
ID: 9263
Name: Capo
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
very friendly and his family misses him please call 5153054916
Des Moines - North
Lost: 8/14/2018
ID: 9388
Name: Oreo
Type: Dog
Color: Black white, little brown on face
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
By park fair mall.
Ankeny
Lost: 8/13/2018
ID: 9385
Name: Butters
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She is completely declawed.
Clive
Lost: 8/13/2018
ID: 9382
Name: Unknown
Type: Cat
Color: Charcoal Gray with White Socks
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
At Boston Parkway and NW 164th Street, Clive.
Ankeny
Lost: 8/13/2018
ID: 9370
Name: Max
Type: Dog
Color: Tan and Black
Breed: Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
In Ankeny near Georgetown Blvd and Ankeny Blvd. He is friendly and has the energy of a 6 month old pup.
Ankeny
Lost: 8/12/2018
ID: 9373
Name: Storm
Type: Cat
Color: Multi
Breed: Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen last night around bricktown apartments. He is super friendly and also responds to bubbas.
Des Moines - North
Lost: 8/12/2018
ID: 9372
Name: Chloe
Type: Dog
Color: Black
Breed: Norwegian Elkhound
Gender: Female
Fixed: Neutered
Age: Young
Nw 2nd ave and 54th last seen
Pleasant Hill
Lost: 8/12/2018
ID: 9369
Name: Lily
Type: Cat
Color: Brown Black tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Applicable
Age: Adult
She broke her rear left leg a few years ago and has a plate in it so she walks and sits funny. She is very small. Less than 7 lbs. $100 reward for her safe return.
Adel
Lost: 8/12/2018
ID: 9368
Name: Grace
Type: Dog
Color: Tan/white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Young
Friendly but, may not come up to you. May come for food.
Des Moines - South
Lost: 8/11/2018
ID: 9384
Name: Teddy
Type: Dog
Color: White, black, and some brown
Breed: Lhasa Apso
Gender: Male
Fixed: Not Neutered
Age: Adult
Got lose on Elder Lane and is a companion pet.