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>='1560470400')) ORDER BY pm1.meta_value DESC, post_date DESC
Grinnell
Lost: 6/4/2019
ID: 11532
Name: Tyson
Type: Dog
Color: Blue brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen / went missing a couple miles east of Rock Creek Lake between Grinnell Iowa and Kellogg Iowa. Wearing a blue reflector collar with silver dog bones on it. No tag. ‼️‼️ NOW OFFERING A $200 REWARD FOR A SAFE RETURN‼️‼️
Des Moines - South
Lost: 6/4/2019
ID: 11514
Name: Link
Type: Dog
Color: White with brindle spots, butt, half of tail, and partial face
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Around Se 5th and Pionner road, all the way to Se 14th and Pionner road.
Des Moines - South
Lost: 6/4/2019
ID: 11512
Name: Ash
Type: Dog
Color: Black
Breed: Yorkie Poo
Gender: Male
Fixed: Not Neutered
Age: Young
He’s a very friendly runner.
Des Moines - Central
Lost: 6/3/2019
ID: 11591
Name: Mittens
Type: Cat
Color: Brown and black
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Beaverdale around 49th St. and Urbandale Ave. she has 6 toes on her front paws.
Des Moines - Central
Lost: 6/3/2019
ID: 11590
Name: Mittens
Type: Cat
Color: Brown and black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Beaverdale on 49th St. and Urbandale Avenue. She has 6 toes on front paws.
Des Moines - South
Lost: 6/3/2019
ID: 11526
Name: Constantine
Type: Cat
Color: Gray black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Surrounding property
Des Moines - South
Lost: 6/3/2019
ID: 11525
Name: Ivy
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Baby
Surrounding property
Des Moines - South
Lost: 6/3/2019
ID: 11524
Name: Zoe
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Surrounding property
Indianola
Lost: 6/3/2019
ID: 11509
Name: Ace
Type: Dog
Color: Tan and white
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Lost between boston and Clinton. On n h st. Please help find him.
Des Moines - North
Lost: 6/2/2019
ID: 11544
Name: Mr. Theo
Type: Cat
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
York and Hull
Des Moines - South
Lost: 6/2/2019
ID: 11523
Name: Josie
Type: Cat
Color: Tortieshell
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Not Neutered
Age: Young
Surrounding property
North Liberty
Lost: 6/2/2019
ID: 11521
Name: Penny
Type: Cat
Color: Black with white belly/chin and 4 white paws
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on N. Colton Dr. near the corner of Cherry & Jones in North Liberty, IA. Very friendly. Not an outdoor cat. Her family is very worried and misses her dearly!
Des Moines - South
Lost: 6/2/2019
ID: 11517
Name: Jack / jacky
Type: Cat
Color: Dark tiger
Breed: Bobtail
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in area of sw 9th and pleasant view dr, Jack has no tail, missing him a lot . Please contact me if found at 515 943 8682
Des Moines - South
Lost: 6/2/2019
ID: 11516
Name: Jack / jacky
Type: Cat
Color: Dark tiger
Breed: Bobtail
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in the area of sw 9th and pleasant view Dr , Jack has no tail my phone number is 515 943 8682 if found , missing him a lot,
Dubuque
Lost: 6/2/2019
ID: 11507
Name: Zeke
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly. Lost in Parkway St area (between Finley Hospital and YMCA). Hurt front leg, but healed.
Des Moines - West
Lost: 6/2/2019
ID: 11504
Name: CharLee
Type: Dog
Color: Tan mix
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Baby
Ankeny
Lost: 6/2/2019
ID: 11502
Name: Bishop
Type: Dog
Color: Brown brindle
Breed: English Bulldog
Gender: Male
Fixed: Neutered
Age: Senior
Nw 17th st and Greenwood in Ankeny. He is friendly but deaf and won’t respond to his name. He takes seizure meds daily. We need help finding him. 641-430-7908 or 641-430-9415
Des Moines - South
Lost: 6/2/2019
ID: 11495
Name: Ruth
Type: Dog
Color: Brown
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the Easter Lake Area. My parents were dog sitting and she ran off around 7am. If you see her please call 515-333-1409
Collins
Lost: 6/1/2019
ID: 11547
Name: Oscar
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
Independence
Lost: 6/1/2019
ID: 11505
Name: Mater
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 6/1/2019
ID: 11484
Name: Ivy and Jake
Type: Dog
Color: Brown and black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
East Lake area
Des Moines - Central
Lost: 6/1/2019
ID: 11483
Name:
Type: Cat
Color: White and grey and black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 6/1/2019
ID: 11482
Name:
Type: Cat
Color:
Breed: Tuxedo
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Lost: 6/1/2019
ID: 11481
Name: Oreo
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen outside around Motel 6 in Wes Des Moines, outside on the grass towards McDonald’s. Oreo was adopted in Cleveland, Ohio and my family is driving to California with him. He was found missing around 8am on 06/01/2019, last seen outside Motel 6 in West Des Moines (7655 Office Plaza Drive North).
Des Moines - East
Lost: 6/1/2019
ID: 11479
Name: Marley
Type: Dog
Color: Tan and white
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
She’s very scared as she is my moms dog and they just got to town this morning and don’t know where she is. She may be hurt and need medical attention. She ran into the side of a car and then took off! Please help find my moms baby!!