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>='1594252800')) ORDER BY pm1.meta_value DESC, post_date DESC
Bondurant
Lost: 3/9/2020
ID: 13538
Name: Chole
Type: Cat
Color: White white dark spots
Breed:
Gender: Male
Fixed: Neutered
Age: Adult
At my home 1216 Kadin trail
Bondurant
Lost: 3/9/2020
ID: 13537
Name: Chole
Type: Cat
Color: White white dark spots
Breed:
Gender: Male
Fixed: Neutered
Age: Young
At home
Des Moines - East
Lost: 3/9/2020
ID: 13532
Name: Wrigley
Type: Dog
Color: Brown - Merle with White
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Adult
5000 Stream Side Circle - Brook Run Neighborhood, very friendly loves people and dogs.
Urbandale
Lost: 3/8/2020
ID: 13709
Name: Mattie aka mattcat
Type: Cat
Color: Grey with white chest marking and white stomach marking
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Ashford ridge apartments Urbandale he was inside when it burned down and his remains were not found so we are trying to be optimistic that he made it out! He is 13 pounds grey with a white marking on his chest and a bikini like white marking on his stomach his left eye is a little fuzzy and not as clear we lost everything in the fire and are hoping maybe he made it alive and we can find him! Last in urbandale Iowa
Des Moines - East
Lost: 3/8/2020
ID: 13525
Name: Bella Chiquita
Type: Dog
Color: Blonde
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Not Neutered
Age: Young
Sw 7th and w mlk Jr pkwy
Indianola
Lost: 3/8/2020
ID: 13523
Name: Cocoa
Type: Dog
Color: Chocolate dapple
Breed: Dachshund-Miniature
Gender: Female
Fixed: Neutered
Age: Adult
Near Simpson College 1 block east
Bondurant
Lost: 3/8/2020
ID: 13521
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Senior
Des Moines - South
Lost: 3/8/2020
ID: 13374
Name: Leo
Type: Dog
Color: Grey white brown black
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Adult
By Tasty Tacos. Across street from Menards
Des Moines - North
Lost: 3/7/2020
ID: 13604
Name: Mama Kitty
Type: Cat
Color: Brown tabby with orange
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around 63rd & Univesity Des Moines, IA. UPDATE - She returned on 4/4/20
Nevada
Lost: 3/7/2020
ID: 13545
Name: Ace
Type: Cat
Color: White and balck
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Last seen at home on 6th st by the senior care
Nevada
Lost: 3/7/2020
ID: 13544
Name: Ace
Type: Cat
Color: White and black
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at home by 6th street by the senior care center
Urbandale
Lost: 3/7/2020
ID: 13518
Name: Goonie
Type: Dog
Color: Black/Brown on paws
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Seen at the Rocklyn Trailer Parks was supposedly picked up by a lady in a small black sedan. He’s sweet and will come running to you with open arms.
Des Moines - Central
Lost: 3/7/2020
ID: 13508
Name: Miss.Butter
Type: Cat
Color: Orange
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
She is probably hiding, it looks like she may have gotten into a fight from our camera outside.
Madrid
Lost: 3/6/2020
ID: 13511
Name: Cooper
Type: Dog
Color: Black and white
Breed: Havanese
Gender: Male
Fixed: Neutered
Age: Young
Last seen around Meadow Estates in Madrid, Iowa
Bondurant
Lost: 3/6/2020
ID: 13506
Name: Gizmo
Type: Dog
Color: Brown/black/white
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Adult
Pomeranian/sheltie mix
Ankeny
Lost: 3/6/2020
ID: 13501
Name: Rocky
Type: Dog
Color: Black, Tan,White
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Senior
Off of NW 84th Ave in Ankeny 515-339-9422
Des Moines - East
Lost: 3/5/2020
ID: 13852
Name: Fluffy
Type: Cat
Color: Gray & white
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Baby
Around E 25th Garfield Was pregnant about to give birth She super friendly prefers to be outside. Has the worst meow ever .
Des Moines - Central
Lost: 3/5/2020
ID: 13496
Name: Churro
Type: Dog
Color:
Breed: Chiweenie
Gender: Male
Fixed: Not Neutered
Age: Young
3000 block of E Douglas. Near Seargent Park & Reno Memorial Dog Park.
Des Moines - North
Lost: 3/5/2020
ID: 13494
Name: Jackson
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 3/5/2020
ID: 13493
Name: frankie
Type: Dog
Color: red
Breed: GoldenDoodle
Gender: Female
Fixed: Not Neutered
Age: Baby
Des Moines - East
Lost: 3/4/2020
ID: 13533
Name: Nebby
Type: Cat
Color: Grey, brown and white. Pink nose.
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Baby
Last seen on corner of E Washington & 27TH St. Answers to “meow meow
Grimes
Lost: 3/4/2020
ID: 13504
Name: Spunky
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
Very good cat he was last seen inside at 601 se dovetail in grimes he is fully declared.
Altoona
Lost: 3/4/2020
ID: 13492
Name: Gizmo
Type: Dog
Color: Brown and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Got out of our fenced yard in Altoona. He isn’t wearing a collar.
Bondurant
Lost: 3/4/2020
ID: 13488
Name: Lulu
Type: Cat
Color: Black/white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
She’s never been outside. She is front declawed.
West Des Moines
Lost: 3/4/2020
ID: 13483
Name: Berry
Type: Dog
Color: Reddish brown
Breed: Rhodesian Ridgeback
Gender: Male
Fixed: Neutered
Age: Young
Berry slipped off his collar so he has no identification on him. :( I live on 12th and vine in Valley Junction so he is likely still in this area. He’s very very friendly but high energy and can look a little intimidating if you don’t know any better. He loves treats and other dogs and of course all people.