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>='1618444800')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 10/9/2022
ID: 15170
Name: Charlie
Type: Cat
Color: White with black spots/tail
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
At home address. Comes to “Ki Ki”. Friendly
Cedar Falls
Lost: 4/20/2021
ID: 16514
Name: Juno
Type: Dog
Color: Black
Breed: Schipperke
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Cedar Falls, Industrial Boulevard area. Near Aloha Pet Resort and Spa.
Cedar Falls
Lost: 4/20/2021
ID: 16513
Name: June
Type: Dog
Color: Black
Breed: Schipperke
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Cedar Falls, Industrial Boulevard, area. Near Aloha Pet Resort and Spa.
Waterloo
Lost: 4/18/2021
ID: 16515
Name: Penny
Type: Cat
Color: white and grey
Breed: Himalayan
Gender: Female
Fixed: Not Neutered
Age: Young
she’s pregnant. last seen on the 18th of april
Des Moines - North
Lost: 4/18/2021
ID: 16511
Name: Peaches
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Afternoon/evening of Sunday the 18th. Slipped outside unseen, did not show for breakfast. Skittish and hates being picked up, but not too shy to go up to a person with food. Talkative.
Des Moines - East
Lost: 4/18/2021
ID: 16504
Name: Moxxi
Type: Dog
Color: White with black
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
On E 14th
West Des Moines
Lost: 4/18/2021
ID: 16500
Name: Cowboy
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
Don't chase! Very thin, crooked ear. Friendly. Skittish.
Des Moines - East
Lost: 4/18/2021
ID: 16499
Name:
Type: Dog
Color:
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Baby
E 25th and E Sheridan
Grimes
Lost: 4/18/2021
ID: 16495
Name: Jersey
Type: Dog
Color: Black and white
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 4/17/2021
ID: 16517
Name: Big kitty
Type: Cat
Color: Grey/white
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Senior
She is very friendly, declawed. 15 yrs old.
East Peru
Lost: 4/17/2021
ID: 16497
Name: Wulfgar
Type: Dog
Color: Reddish brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Senior
Beginning to go deaf.
Pleasant Hill
Lost: 4/17/2021
ID: 16496
Name: Clyde
Type: Cat
Color: Ginger
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen early morning on April 17. He is about 6 lbs and has a crook at the end of his tail. If you have any information please email Jamiej85@gmail.com.
Des Moines - North
Lost: 4/17/2021
ID: 16491
Name: Willow (black&brown) Nova (black&white blue eyes)
Type: Dog
Color: One looks like a German Shepard with brown eyes and husky is black an white with blue eyes
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen around the 4500 block of Hubbell on the Southside of the apartment complex by the new housing being built.
Des Moines - South
Lost: 4/17/2021
ID: 16490
Name: Bernadette (Bernie)
Type: Dog
Color: Black/white
Breed: Australian Cattle Dog
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen around sw 9th between McKinley and watrous. She is a pretty shy girl and won't come to people easily. She is friendly and super sweet nonetheless. Just want to bring our sweet girl home!!
Des Moines - East
Lost: 4/17/2021
ID: 16489
Name: Toto
Type: Dog
Color: Black grayish brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Senior
I live on the corner of Hubble Avenueand Guthrie ave so he could’ve walked down either road. He has one eye and his tongue hangs out the last side of his mouth he looks exactly like the dog on Wizard of Oz except he’s 19 years old
Des Moines - East
Lost: 4/17/2021
ID: 16488
Name: Toto
Type: Dog
Color: Black grayish brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Senior
I live on the corner of horrible and got three so he could’ve walked down either road
Des Moines - East
Lost: 4/17/2021
ID: 16486
Name: Cooper
Type: Dog
Color: Brown and black
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
By east high
Des Moines - North
Lost: 4/17/2021
ID: 16485
Name:
Type: Dog
Color:
Breed: Coonhound
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - East
Lost: 4/17/2021
ID: 16483
Name: Jackson
Type: Dog
Color: Silver/tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
He is larger than you'd expect a yorkie to be, has some hair loss by his legs and a scar on his lower back. He has cushings disease, will come to you for food. His collar was still attached to the tether. Lost near the Fairgrounds in Des Moines, IA. Please call or text 515.991.5633
Des Moines - South
Lost: 4/17/2021
ID: 16478
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 4/16/2021
ID: 16516
Name: Browni
Type: Cat
Color: White / Orange
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a runner Nice cat tho
Des Moines - South
Lost: 4/16/2021
ID: 16512
Name: Luna
Type: Cat
Color: Black
Breed: Bombay
Gender: Unknown
Fixed: Not Neutered
Age: Young
Near Yeader Creek @ South Union
Des Moines - West
Lost: 4/16/2021
ID: 16477
Name: Keoki
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Gold heart tag and green rabies tag. Has a purr like yoda.
Norwalk
Lost: 4/16/2021
ID: 16476
Name: Leo
Type: Cat
Color: Brown/gold
Breed: Bengal
Gender: Male
Fixed: Not Neutered
Age: Young
Got out of our screen door please call if found
Ankeny
Lost: 4/16/2021
ID: 16469
Name: Kaiser
Type: Dog
Color: Grey white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Maple court