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>='1440892800')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 9/3/2015
ID: 1324
Name: Izzy
Type: Cat
Color: white, orange, and gray tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
last seen on the back screened in porch and back yard. She is a family pet, and is on a special diet.
Des Moines - East
Lost: 9/3/2015
ID: 1317
Name: Lucky
Type: Cat
Color: White with black tip ears, face, paws, ears
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
3900 block of e 32nd St & e Madison ave
Pleasant Hill
Lost: 9/2/2015
ID: 1323
Name: Bear
Type: Cat
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Evans Blvd location Big Completely brown male cat with white tip on tail and just a bit on white on chest. Long hair Hair getting curly on stomach. Big boy last seen 9-2-15 am in pleasant hill along hwy 65 just east of Doanns park 515*-299-4709 or 515-710-9808
Pleasant Hill
Lost: 9/2/2015
ID: 1319
Name: Lilly
Type: Cat
Color: Grey tiger
Breed: Unknown
Gender: Unknown
Fixed: Not Applicable
Age: Adult
We are moving into Pleasant Hill from Clive. She was very scared and got out accidentally. Her front claws are removed.
Pella
Lost: 9/2/2015
ID: 1318
Name: n/a
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Found abandoned/lost by Red Rock Marina
Hartford
Lost: 9/1/2015
ID: 1322
Name: Ivy
Type: Dog
Color: Black and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Small white with black spots one blue eye and one brown eye.
Des Moines - West
Lost: 9/1/2015
ID: 1308
Name: Abi
Type: Dog
Color: Copper Red/Brindle and White
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Neutered
Age: Young
Abi does not have her tags on, but she is up to date on all shots. She loves people, dogs and children. She was last seen in the morning in our house near the Masonic Cemetery/Waveland Golf Course. We believe she let herself out the back storm door. She may jump up on you and lick you, but is not malicious.
Des Moines - Central
Lost: 8/30/2015
ID: 1309
Name: Otis Tass
Type: Dog
Color: brown/tan
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Baby
SHARE SHARE SHARE $700 Lost Dog Reward!!! Loved dog His name is Otis Tass and he was lost/taken from my truck parked on 3rd and Court street Saturday night (8/30) DT Des Moines. Bring Otis to 8219 Dakota drive in West Des Moines or call Cory Tass 5154234498.
Clive
Lost: 8/30/2015
ID: 1300
Name: Charlie
Type: Cat
Color: Black & white
Breed: Pomeranian
Gender: Female
Fixed: Neutered
Age: Senior
5 pm Saturday, declawed front and back, glaucoma in right eye,grumpy deminor, beloved pet
Des Moines - Central
Lost: 8/30/2015
ID: 1299
Name: Otis
Type: Dog
Color: Brown
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Young
$700 doller finders fee. Bring Otis to the animal rescue league on 14th street in SE Des Moines. No questions asked. Otis was in a truck for a short amount of time on 3rd and court down town Des Moines. He was let out of truck/taken around 1:15 am. Or you can call or txt if found 515 423 4498