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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 5/19/2018
ID: 8839
Name: Pepper
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
He is VERY friendly. He's front declawed, very fluffy. All black, maybe a touch of grey around his ears.
West Des Moines
Lost: 5/19/2018
ID: 8623
Name: Carmelo
Type: Dog
Color: Brindle
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
828 12th St West Des Moines 50265
West Des Moines
Lost: 5/19/2018
ID: 8622
Name: Ali Porter
Type: Dog
Color: Black
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
May 19th. Black and Brown Rott. Very Curly Tail
Des Moines - Central
Lost: 5/19/2018
ID: 8614
Name: Levi
Type: Dog
Color: Silver
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Escaped the backyard in the early morning hours from 33rd St & Sheridan in Beaverdale. Please call if found!
Des Moines - South
Lost: 5/18/2018
ID: 8609
Name: Puma
Type: Dog
Color: brown
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Lost near 14th street and McKinley
Des Moines - East
Lost: 5/18/2018
ID: 8608
Name: Rocky
Type: Dog
Color: Brown, black with white on chest
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
Last seen on E Ovid in Des Moines Iowa. Near brubaker school. Rocky has fatty tumors on right side.
Adel
Lost: 5/18/2018
ID: 8604
Name:
Type: Cat
Color:
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 5/18/2018
ID: 8600
Name: Miller
Type: Dog
Color: White and liver
Breed: Brittany Spaniel
Gender: Female
Fixed: Not Neutered
Age: Young
Friendly but shy will bark
Des Moines - East
Lost: 5/17/2018
ID: 8684
Name: Lexi
Type: Dog
Color: White/Cream
Breed: Maltese
Gender: Female
Fixed: Neutered
Age: Senior
Please Help My little girl went missing Thursday, May 17th from around E 38th St & Indianapolis. We have searched everywhere we can think of and haven't found her. We believe it's possible that she was stollen from the reports we've had from people in the neighborhood. She is super friendly and especially loves kids. She is a pomeranian/ maltese mix and her name is Lexi. We really need her to come home. She is love and missed terribly as well as a therapy dog. She is about 10 1/2 years old. She had a pink collar with tags on when we saw her last.
Mitchellville
Lost: 5/17/2018
ID: 8589
Name:
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Mitchellville 112th and 23rd Ave
Willey
Lost: 5/16/2018
ID: 9214
Name: Chunk
Type: Cat
Color: Orange & white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Saw him around 7:30 pm, I left for about an hour. Never saw him again.
Des Moines - East
Lost: 5/16/2018
ID: 8660
Name: Gizmo
Type: Cat
Color: Grey/Brown Tabby
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Gizmo was last seen in the Union Park area off of Shawnee Ave. and E7th. She is mostly an outdoor cat but comes home every night. She is chipped and spayed since I got her at the ARL a few years ago as a rescued stray. She has half, crooked tail and both main canine teeth pulled. Message me or call 5154919311 with any details. Thanks!
Altoona
Lost: 5/16/2018
ID: 8598
Name: Trouble
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
Seen at the Adventureland Campground late Wed night when he snuck out and took off. He's only 3 months old. Very friendly with lots of attitude.
Altoona
Lost: 5/16/2018
ID: 8597
Name: Monkey
Type: Cat
Color: Grey and black striped tiger
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Money is a small 9 month old grey and black tiger striped cat. She is very friendly and loves to sneak out if our home.
Ankeny
Lost: 5/16/2018
ID: 8590
Name: Charlie
Type: Cat
Color: Yellow
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Indoor cat escaped through door left ajar. Front declawed. Somersby neighborhood
Des Moines - East
Lost: 5/16/2018
ID: 8583
Name: Buddy Boty
Type: Dog
Color: Black & Tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Baby
at home around noon, must have got out when got mail.Very friendly, licks everyone. No Collar but micro chipped. 7 months old about 4 lbs. Tongue hangs out to side of mouth.
Des Moines - West
Lost: 5/15/2018
ID: 8616
Name: Puddin Pop
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Puddin got out Tuesday evening and hasn’t been spotted since. He’s gotten out before but always returns. Very friendly but also very feisty.
Des Moines - East
Lost: 5/15/2018
ID: 8601
Name: Pearl
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She was purposefully let out by a spiteful EX the day we were supposed to pick her up. She is pretty friendly but very very scared. If you try to feed her put the food down and back away. She wont take it from your hand.
Altoona
Lost: 5/15/2018
ID: 8595
Name:
Type: Cat
Color: Ginger and some ehite
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
White paws, front declaw, and orange heart shaped spot on right paw. Indooor only cat.
Des Moines - North
Lost: 5/15/2018
ID: 8582
Name: Snickers
Type: Dog
Color: Brown and black with some gray hair
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
He was last seen in our backyard going to potty. He is a small yorkie terrier.
Des Moines - East
Lost: 5/15/2018
ID: 8581
Name: Snickers
Type: Dog
Color: Black and Tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
He was last seen in our front yard, he’s very friendly. We’d like for Snickers to come back home to us :(
Des Moines - Central
Lost: 5/15/2018
ID: 8575
Name: Blue
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Adult
37th and University
Davenport
Lost: 5/14/2018
ID: 8672
Name: Garflied
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
We saw him the day before he went missing he's never been missing before he's big, fluffy and lovable that loves milk and lasinga*
Des Moines - East
Lost: 5/14/2018
ID: 8585
Name: Casper
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - East
Lost: 5/14/2018
ID: 8584
Name: Casper
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Young