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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Beacon
Lost: 9/15/2015
ID: 1432
Name: Sammy
Type: Dog
Color: White and brown
Breed: Cocker Spaniel
Gender: Male
Fixed: Neutered
Age: Adult
He is timid around strangers, he won't bite, get to his level and let him check you out
Des Moines - East
Lost: 9/14/2015
ID: 1417
Name: Snoopy
Type: Dog
Color: White and black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
E Grand And 16th
Des Moines - East
Lost: 9/13/2015
ID: 1535
Name: Canela
Type: Dog
Color: Black brown
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - East
Lost: 9/13/2015
ID: 1499
Name: Canela
Type: Dog
Color: Brown/black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 9/13/2015
ID: 1427
Name: Calli
Type: Dog
Color: blonde
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
Got out of the yard around SE 10th & Scott St. Des Moines
Des Moines - East
Lost: 9/13/2015
ID: 1426
Name: Calli
Type: Dog
Color: blonde
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
Got out of the yard around SE 10th & Scott St. Des Moines
Marion
Lost: 9/13/2015
ID: 1424
Name: Storm
Type: Bird
Color: Gray, white
Breed: Cockatiel
Gender: Male
Fixed: Not Applicable
Age: Adult
Last seen flying North/North-East from Marion. He should respond to his name(spoken softly) and three quick clicks of the tongue. He might not if he is scared. If you think you've seen him, please contact me!
Des Moines - South
Lost: 9/13/2015
ID: 1410
Name: kato
Type: Dog
Color: brindel ( light and dark brown striped)
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly , plays well with other dogs , me and my daughter really miss him please let us know
Hamilton
Lost: 9/13/2015
ID: 1405
Name: Odie
Type: Bird
Color: Bright green/orange yellow belly/grey head
Breed: African Senegal
Gender: Male
Fixed: Unknown
Age: Young
He is 9 months old. Knows how to say pretty bird/peekaboo and wolf whistle. Knows step up and likes to be on shoulder. He is micro chipped.
Des Moines - East
Lost: 9/13/2015
ID: 1399
Name: Canela
Type: Dog
Color: Brown,black with gray
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
Bondurant
Lost: 9/12/2015
ID: 1394
Name: Cajun
Type: Dog
Color: brown white and gray
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Adult
Urbandale
Lost: 9/11/2015
ID: 1400
Name:
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Baby
Urbandale
Lost: 9/11/2015
ID: 1390
Name: Noelle
Type: Cat
Color: Lynx-point siamese tan/gray/black striped with Blue eyes
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Senior
Morning of 09-11-15, She is a smaller structured Kitty who is 13 & has a medical condition and needs her medicine. Reward offered. Phone # 515-971-2727 or 515-210-5378. Lost in area of 154th & Meredith in Walnut Trace development. May have jumped into an open car window as does not like to be cold.
Grimes
Lost: 9/11/2015
ID: 1369
Name: baby girl
Type: Cat
Color: white
Breed: American Wirehair
Gender: Female
Fixed: Neutered
Age: Young
This morning by the trailer courts off of 141
Des Moines - South
Lost: 9/10/2015
ID: 1382
Name: Cheta
Type: Cat
Color: Black and brown spotted
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Adult
Adair
Lost: 9/9/2015
ID: 1375
Name: Tank
Type: Dog
Color: Red
Breed: Redbone Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Lost Wednesday night northwest of Fontanelle
Adair
Lost: 9/9/2015
ID: 1374
Name: Tank
Type: Dog
Color: Red
Breed: Redbone Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Lost Wednesday night northwest of Fontanelle
Columbus Junction
Lost: 9/9/2015
ID: 1373
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Unknown
Age: Young
Please help and keep sharing. $$200 REWARD. Contact Walt Shellabarger with any information 5632998339. Lost on Burlington road fruitland/ Grandview area... Elegedly last seen by otools/Christmas tree farm. Comes to her name Jane or a good whistle.
Letts
Lost: 9/9/2015
ID: 1372
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Lost near Burlington road, last elegedly seen by otools/Christmas tree farm
Grandview
Lost: 9/9/2015
ID: 1371
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Lost by Burlington road... Last elegedly seen by otools/Christmas tree farm
Fruitland
Lost: 9/9/2015
ID: 1370
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Lost by Burlington road, last elegedly seen near otools/Christmas tree farm.
Des Moines - North
Lost: 9/9/2015
ID: 1356
Name: Lucky
Type: Dog
Color: Brown black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
E 9th & Sheridan ave
Des Moines - North
Lost: 9/9/2015
ID: 1355
Name: Lucky
Type: Dog
Color: Brown black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
E 9th & Sheridan ave
Des Moines - East
Lost: 9/8/2015
ID: 1408
Name: Bently
Type: Dog
Color: Black/brown/tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Near fairgrounds in DSM bently wanders away and makes it long ways from home from time to time he was wearing both regular college and fle collar and has tags but the phone number on his tags and microchip isn't current if he is found please call 5154473327 anytime day or night
Des Moines - South
Lost: 9/8/2015
ID: 1361
Name: Movado aka Mo Mo
Type: Dog
Color: white with caramel spots
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen by Fort Des Moines by Army Post Rd. He is a very friendly and loving dog. He may act very shy and timid and full of energy. The sides of his face has caramel spots along wit caramel spots on his back. He is my best friend and need to find him. Any tips help.