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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 11/9/2016
ID: 4286
Name: Daphane
Type: Dog
Color: Black
Breed: Pug
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen at 22nd street near the I-235 intersection. Very friendly. Answers to Daphane.
West Des Moines
Lost: 11/9/2016
ID: 4277
Name: Momo
Type: Dog
Color: Black/white
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Around west Des Moines knolls park area. He likes kids so he probably was found at the park
Des Moines - West
Lost: 11/8/2016
ID: 4360
Name:
Type: Cat
Color: BLACK
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is an outdoor/indoor cat. He is very friendly. Loves kids. He was last seen in West Des Moines/Waukee on 92nd st. If you have seen him or found him please call 515-4221695. His paired buddy is very depressed and misses him a lot. We are very heartbroken and hope he returns home safely. Thank you
Pleasant Hill
Lost: 11/8/2016
ID: 4296
Name: Jax
Type: Dog
Color: Grey/silver with a small white patch on his chest.
Breed: Weimaraner
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 6500 block of Vandalia rd and SE 26th place, Pleasant Hill, IA. Jax is a super friendly dog that loves people and car rides. He has never hunted a day in his life and really wants to be back at home with his pawrent!
Des Moines - Central
Lost: 11/7/2016
ID: 4257
Name: Rocko
Type: Dog
Color: White
Breed: Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly playful a lot of energy REWARD 500 lost 14th and university
Slater
Lost: 11/6/2016
ID: 4321
Name: Marty (Mar-Mar)
Type: Cat
Color: Browns and black
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Is wary of people and hates to be confined.
West Des Moines
Lost: 11/6/2016
ID: 4247
Name:
Type: Bird
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Baby
Marion
Lost: 11/6/2016
ID: 4246
Name: Mimi
Type: Cat
Color: Black and White
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
Very friendly, only has back claws
Des Moines - East
Lost: 11/5/2016
ID: 4389
Name: Toby
Type: Dog
Color: White
Breed: Yorkie Poo
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 11/5/2016
ID: 4242
Name: Piper
Type: Dog
Color: White/tan
Breed: Shar Pei
Gender: Female
Fixed: Neutered
Age: Adult
Se 28th st and scott ave/Mlk . Should be with yellow lab "max"
Des Moines - East
Lost: 11/5/2016
ID: 4241
Name: Max
Type: Dog
Color: Yellow/white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Senior
Se 28th st and scott ave/MLK. Needs meds.
Des Moines - South
Lost: 11/4/2016
ID: 4274
Name: Tom aka: Itchy
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Found him earlier today, he got into a neighbors garage and had been shut in since last Friday night/Saturday morning. Jim was out working in yard and kept hearing a meow and found it coming from the garage. He was pretty dirty and very hungry and thirsty but seems to be OK.
Des Moines - South
Lost: 11/4/2016
ID: 4272
Name: Tom aka: Itchy
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Neighbors had party night he went missing, not sure if he was picked up, got into the back of someones truck or was scared off. He avoids people he is not familiar with. Is not declawed. Comes to you if you clap. Reward
Des Moines - Central
Lost: 11/4/2016
ID: 4266
Name: Lottie
Type: Cat
Color: Calico with White V on Chest
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
2700 block of 61st street, in between New York and Sheridan. Near DSM First on Merle Hay. Lottie is declawed in the front and has a white tip on his tail.
Waukee
Lost: 11/3/2016
ID: 4252
Name: Stryker
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, indoor/outdoor cat, up to date on vaccines. Also, comes to Kiki. Lost around Corene Avenue in Waukee. Usually comes home every morning after venturing out. Hasn't come home since 11/3/16.
Des Moines - South
Lost: 11/3/2016
ID: 4245
Name: Boots (Boo)
Type: Cat
Color: Grey and White stripe
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
Snuck out window. All white feet. Recently fixed. Missing back left claw. Paying a reward for return!
Des Moines - South
Lost: 11/3/2016
ID: 4244
Name: Boots. (Boo)
Type: Cat
Color: Grey and White stripe
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
Has all white feet. Very loud howler. Extremely friendly. Recently fixed missing one claw back foot recent.
Bondurant
Lost: 11/3/2016
ID: 4235
Name: Mitzy
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Black with white paws, belly, and whiskers
Des Moines - South
Lost: 11/3/2016
ID: 4226
Name: Simba
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
By townhomes by earl may on south side
Des Moines - South
Lost: 11/2/2016
ID: 4217
Name: Daisy
Type: Dog
Color: Black,brown and white
Breed: Doberman Pinscher
Gender: Unknown
Fixed: Not Neutered
Age: Young
Backyard, she is a miniature Doberman Pinscher, greatly missed please contact with any information
Waukee
Lost: 11/1/2016
ID: 4232
Name: Bobcat
Type: Cat
Color: Black with white spot on chest
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Young
Bobcat has green eyes; one of his eyes looks a little blurry compared to the other. You can see the difference when you look at his face. He is VERY friendly. He was last seen at the Springs apartments in Waukee (behind the Hyvee on Hickman Road).
Waterloo
Lost: 11/1/2016
ID: 4215
Name: Chance an chance
Type: Dog
Color: Both tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Riehl still Waterloo Ia I miss him alot an I just want him then to come home now one had a tagtag on his collar with address an the number is wrong 3194043744 an he he's a scar above his eye
Ankeny
Lost: 11/1/2016
ID: 4203
Name: Frankie
Type: Dog
Color: Black and White
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Clover Ridge Dr, large scar on right leg from recent surgery
Ankeny
Lost: 10/31/2016
ID: 4204
Name: Maggie
Type: Dog
Color: Red
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Adult
About 8:00pm tied out in yard
Urbandale
Lost: 10/31/2016
ID: 4201
Name: Oscar
Type: Cat
Color: Brown Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He has white paws and he also has some white under his neck, the rest of him is brown. He is very friendly and has a loud unique meow.