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>='1555113600')) ORDER BY pm1.meta_value DESC, post_date DESC
Van Meter
Lost: 9/17/2015
ID: 1454
Name: Cy
Type: Dog
Color: black and white
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 9/17/2015
ID: 1445
Name: coco
Type: Dog
Color: brown with white on torso also some black
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
1511 York street. May be a little snippy at times. She also goes by mamas.
Polk City
Lost: 9/16/2015
ID: 1476
Name: Puppy
Type: Cat
Color: Brown & tan
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 9/15 pm hours. He is declawed & an indoor/outdoor cat. Approx 12 years old & it is NOT like him to stray from home! Persian with himalayan colors - big blue eyes. He disappeared here in Polk City on Tyler Street. He has been with me thru thick & thin. I know he is alive & I want him back home !! Please help !! Heartbroken...
Storm Lake
Lost: 9/16/2015
ID: 1467
Name: King
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
May be dragging leash. Very friendly and fast.
Des Moines - Central
Lost: 9/16/2015
ID: 1428
Name: Butters
Type: Dog
Color: brown and a little bit white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Baby
He has lots of hair. teddy bear mix. he crawled under the fence. Area around 6th and University.
Cresco
Lost: 9/15/2015
ID: 1459
Name: Diesel
Type: Cat
Color: A light gray-brown with darkish black stripes. He has black/brown paw pads and nose
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Missing since 9/15/15 Contact me through Facebook!! (Kaysey Lund) He's going on seven months old, very friendly and loves attention though a ltitle skiddish lIke his sister; Cleo. A man [in which I cannot announce name] dropped him off without any regards or permission by a horse farm in cresco right on the side of town. I was told later, three days after this happened that he dropped Diesel and four other cats of mine! I went looking for them but have seen nothing. I fear they are either wondering the town, dead or someone has taken them for themselves; which is not bad as long as they are safe but I must find them!! Please contact me if you have seen or found him!!
Cresco
Lost: 9/15/2015
ID: 1458
Name: Finn
Type: Cat
Color: Orange-is yellow with white under his chin and belly. He has white mittens, one of his back hind legs have more white on it than the others.
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
ssing since 9/15/15 Contact me through Facebook!! (Kaysey Lund) He's going on tow years old, very friendly and loves attention. A man by a man [in which I cannot announce a name] dropped him off without any regards or permission by a horse farm in cresco right on the side of town. I was told later, three days after this happened that he dropped finn and four other cats of mine! I went looking for them but have seen nothing. I fear they are either wondering the town, dead or someone has taken them for themselves; which is not bad as long as they are safe but I must find them!! Please contact me if you have seen or found heim!! He's my baby boy, I can't live without him.
Cresco
Lost: 9/15/2015
ID: 1441
Name: Parsley
Type: Cat
Color: Grey with light tan spots and a white lower belly
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Somewhere in town. Please please contact me if she or Ariah are found. Contact me through Facebook!! (Kaysey Lund)
Cresco
Lost: 9/15/2015
ID: 1440
Name: Ariah
Type: Cat
Color: Calico Long haired
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Seen in cresco by a farm, near the town. Recently seen on Fourth street in Cresco Iowa! Please catch her if seen! Contact me through Facebook!! (Kaysey Lund)
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