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>='1614643200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 5/29/2019
ID: 12002
Name: Smudge
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
On 39th St and Douglas St. Roommate let him out. Black with reddish tint scattered single white hairs throughout
State Center
Lost: 5/29/2019
ID: 11562
Name: Theo
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 5/29/2019
ID: 11466
Name: Crookshanks
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
She is very skittish and may not come to you but might for wet food/meat.
Davenport
Lost: 5/28/2019
ID: 11490
Name: $1000 REWARD FOR IGGY ALIVE
Type: Dog
Color: White/Grey
Breed: Shih Tzu
Gender: Female
Fixed: Not Applicable
Age: Young
A pedestrian reported they had seen iggy struck by a slow moving vehicle and that she had gotten up and ran off she was seen on Tuesday (the day she got out) going into the ravine behind enterprise and t mobile on 53rd st with paw prints leading under the bridge to the area behind target and pet smart. there's been 2 post that may have been her down on bridge ave and the area of Jersey ridge and east st.
Des Moines - East
Lost: 5/28/2019
ID: 11486
Name: Jack
Type: Dog
Color: White and tan
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Missing since tu s evening . Last seen on 30th and university...east side des moines. Jack had on a dark blue collar and that flea collar u put on all 3
Des Moines - East
Lost: 5/28/2019
ID: 11485
Name: Jack
Type: Dog
Color: Whte and brown
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Missing since tu s evening . Last seen on 30th and university...east side des moines. Jack had on a dark blue collar and that flea collar u put on all 3
Des Moines - North
Lost: 5/28/2019
ID: 11457
Name:
Type: Dog
Color: Tan
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen 4200 blk me 6th st
Des Moines - East
Lost: 5/28/2019
ID: 11450
Name: Cali
Type: Dog
Color: Dark chocolate/tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on East Walnut in Des Moines
Des Moines - South
Lost: 5/28/2019
ID: 11441
Name: LeRoi
Type: Dog
Color: Dark brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
SW 10th & Titus
Martensdale
Lost: 5/27/2019
ID: 11540
Name: HARVEY
Type: Dog
Color: BLACK/WHITE W/BROWN
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Adult
Harvey home is in Prole in the country and his family is heartbroken. Please help my friends find him. He is missed breed of Border Collie/Australian Shepherd. He may be Medium to Large dog and a year old.
Ankeny
Lost: 5/27/2019
ID: 11438
Name: Mac
Type: Dog
Color: Brown and white
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Rock creek elementary
Thompson
Lost: 5/27/2019
ID: 11435
Name: Ruger
Type: Dog
Color: Black and Tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
Last seen this morning at 7:30 AM. He is most likely running with his sister, Whiskey. Ruger is a year old and has a blaze orange reflective collar on and the brand is Remington. He has a metal tag with his name and my phone number on it along with a rabies vaccination tag.
Thompson
Lost: 5/27/2019
ID: 11434
Name: Whiskey
Type: Dog
Color: Black and Tan
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen was at 7:30 AM this morning. Her caller is the Browning brand and she has a metal tag with her name and my number on it along with rabies vaccination tag.
La Motte
Lost: 5/26/2019
ID: 11511
Name: Linka
Type: Dog
Color: Brown ticked
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Running after a pigeon Friendly dog..
Cedar Rapids
Lost: 5/26/2019
ID: 11477
Name: Vern
Type: Dog
Color: Tan
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on SE side of CR. He’s my grandparents dogs and my Pa has Alzheimer’s. He’s devastated without his companion.
Cedar Rapids
Lost: 5/26/2019
ID: 11476
Name: Vern
Type: Dog
Color: Tan
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
SE side of CR
West Des Moines
Lost: 5/26/2019
ID: 11461
Name: Kit Kat
Type: Cat
Color: Grey and white tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Aspen and Prairie View Dr in WDM. She’s friendly and will come say hi.
Des Moines - Central
Lost: 5/26/2019
ID: 11454
Name: Cash Money Moors
Type: Dog
Color: Gray white black
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen between MLK and 19th
Des Moines - Central
Lost: 5/26/2019
ID: 11453
Name: Cash Money Moors
Type: Dog
Color: Gray white black
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen 19th and MLKy
Des Moines - East
Lost: 5/25/2019
ID: 11429
Name: Dar Dar
Type: Dog
Color: White
Breed: Poodle Miniature
Gender: Male
Fixed: Neutered
Age: Senior
Cambridge
Lost: 5/25/2019
ID: 11425
Name: Sparky
Type: Dog
Color: Black & White
Breed: Rat Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Got loose at White Oak Cemetery. He is white with black ears and a black spot on his tail.
Windsor Heights
Lost: 5/24/2019
ID: 11426
Name: Fuzzy angel aka BabyBoy
Type: Cat
Color: Dark grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He got out of our front door and took off into a neighbors yard and he’s been gone for 2 days now. It’s not like him to be gone that long. PLease reach out if there are any signs of him!
Des Moines - North
Lost: 5/24/2019
ID: 11416
Name:
Type: Dog
Color:
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 5/24/2019
ID: 11415
Name:
Type: Dog
Color:
Breed: Boxer
Gender: Unknown
Fixed: Unknown
Age: Baby
Altoona
Lost: 5/23/2019
ID: 11551
Name: Kyra
Type: Dog
Color: Brown white
Breed: Border Collie
Gender: Female
Fixed: Not Neutered
Age: Young
She was lost at the Flying J truck stop.