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>='1585180800')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 3/27/2018
ID: 8209
Name: Norman
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Has a distinctive broken fang and bright white collar. He’s friendly and loves attention. Please bring our beloved furry friend home!
West Des Moines
Lost: 3/27/2018
ID: 8203
Name: Tucker
Type: Dog
Color:
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Approx. 12:30 pm
Cedar Rapids
Lost: 3/25/2018
ID: 8247
Name: Fred
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Fruitland Blvd SW
Cedar Rapids
Lost: 3/25/2018
ID: 8246
Name: Fred
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on SW side of cedar rapids but we have reason to believe he may have been taken by neighbors a dropped off on a farm anywhere.
Ionia
Lost: 3/25/2018
ID: 8227
Name: Jade
Type: Dog
Color: Black and white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Last seen with her companion Kenzi, Jade is shy around strangers, she has a white muzzle, chest, white markings on her back paws and front left paw, a small white patch between her shoulder blades, left ear stands up, right ear flops over. Missed very much.
Des Moines - Central
Lost: 3/25/2018
ID:
Name: Rosie
Type: Cat
Color: Tortishell
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen Sunday at 7:30 pm kids accidentally let her out usually comes when called but hasent came hoping she's not hurt or been stolen
Des Moines - South
Lost: 3/24/2018
ID: 8240
Name: Pepper
Type: Cat
Color: Black short haired, green eyes, Hair growing in after neutering
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Pepper was a feral cat, adopted into home and inside last 6 weeks. His left ear is clipped. Last seen March 29. 2649 Moonlight Dr
Des Moines - Central
Lost: 3/24/2018
ID: 8186
Name:
Type: Dog
Color: White w light brown
Breed: Jack Russell Terrier (Parson Russell Terrier)
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Lost: 3/23/2018
ID: 8191
Name: Tink
Type: Cat
Color: Gray
Breed: Jack Russell Terrier (Parson Russell Terrier)
Gender: Female
Fixed: Not Applicable
Age: Adult
Des Moines - West
Lost: 3/23/2018
ID: 8189
Name: Gucci
Type: Dog
Color: black
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
13th and Laurel. A few blocks from Drake. He is gentle, will not hurt anyone. He got out of his collar while outside for potty time. He comes by his name. He has a fresh cut on his ear due to another dog attacking him when he was on his chain
Des Moines - South
Lost: 3/23/2018
ID: 8185
Name: Theodore
Type: Small or Furry
Color: Gray and white
Breed: Ferret
Gender: Male
Fixed: Neutered
Age: Young
Very friendly. Has a black nose. And knows his name
Des Moines - South
Lost: 3/23/2018
ID: 8184
Name: Theodore
Type: Small or Furry
Color: Gray white black nose
Breed: Ferret
Gender: Male
Fixed: Unknown
Age: Young
Very friendly. He has a black nose.
Urbandale
Lost: 3/23/2018
ID: 8183
Name: Onyx
Type: Dog
Color: Black with white chest and paws
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Outside in yard, onyx is very friendly and playful
Pleasant Hill
Lost: 3/23/2018
ID: 8180
Name: cali
Type: Dog
Color: black
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
sdsm softball field
Indianola
Lost: 3/22/2018
ID: 8252
Name: Piper
Type: Cat
Color: spotted sepia cinnamon bengal
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Young
Last seen on around March 20th. Her family lives in Lincoln Ridge area- one of the kids left the door open and she got out. She is a Bengal so may be hesitant to approach people.
Huxley
Lost: 3/22/2018
ID: 8206
Name: Hemry
Type: Cat
Color: black
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in my house when I left for work.
Cumming
Lost: 3/22/2018
ID: 8202
Name: Henry
Type: Dog
Color: white and red
Breed: Basset Hound
Gender: Male
Fixed: Neutered
Age: Senior
Very skinny due to health issues related to aging. Friendly guy.
Polk City
Lost: 3/22/2018
ID: 8200
Name: Zac
Type: Cat
Color: Orange/White
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Polk City
Lost: 3/22/2018
ID: 8196
Name: Zac
Type: Cat
Color: Orange/White
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Shenandoah
Lost: 3/22/2018
ID: 8179
Name: Gregory
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 3/22/2018
ID: 8178
Name: Django
Type: Dog
Color: Black Grey and White
Breed: Alaskan Husky
Gender: Male
Fixed: Neutered
Age: Young
West Des Moines
Lost: 3/22/2018
ID: 8172
Name: Frank
Type: Dog
Color: Black, white
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in our backyard but went under the fence.
Des Moines - South
Lost: 3/21/2018
ID: 8222
Name: Church
Type: Cat
Color: Grey
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Around the e Emma ave between se 3rd st and south union on the Southside of des moines. Please if any one has seen him. We are having to move and would really like to have him back before we do move. We will still be in des moines. Church is my youngest son's first pet and he is really upset about him being missing.
Clive
Lost: 3/21/2018
ID: 8199
Name: Freyia
Type: Cat
Color: Orange tabby
Breed: Tabby
Gender: Unknown
Fixed: Not Neutered
Age: Young
She is very small and about 1 years old. Her name is Freyia but doesn’t answer to her name because she’s a cat. She is very loved and missed. She’s is about 3 lbs. no collar.
Des Moines - West
Lost: 3/21/2018
ID: 8175
Name: Michelle
Type: Cat
Color: Gray Tabby
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
She cannot meow so might seem like she’s hissing. Very sweet cat! Has a bell on her collar.