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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 7/1/2021
ID: 17094
Name: Kai
Type: Dog
Color: grey and white
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Young
11:30am
Ankeny
Lost: 7/1/2021
ID: 17093
Name: Kai
Type: Dog
Color: White and black
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around Oak Creek Golf Course in Ankeny. Friendly, but thinks chasing is a game. Please call if spotted.
Altoona
Lost: 7/1/2021
ID: 14393
Name: Stitch
Type: Cat
Color: Gray/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
If anyone took him in or saw him injured or dead, please just let us know. Ty. He just vanished in JUNE 2020 & he was friendly yet tough, it’s hard to imagine he just disappeared. I’d rather know he’s in a nice home or pet heaven. Ty
Cedar Falls
Lost: 6/30/2021
ID: 17162
Name: Mystic
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
700 W Ridgeway Ave lot 636
Des Moines - East
Lost: 6/30/2021
ID: 17098
Name: Oreo
Type: Dog
Color: White and brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Idaho St and he barks at unknown people, he also likes to play, and even run. His collar is not on him, he took it off and ran off.
Des Moines - East
Lost: 6/30/2021
ID: 17097
Name: Joy
Type: Dog
Color: Brown body W/ brown and white face
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Joy was last seen 06/30/2021 around 8AM on the East Side of Des Moines.
Des Moines - East
Lost: 6/30/2021
ID: 17083
Name: Joy
Type: Dog
Color: Grey/brown
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Young
Escaped from our yard. Very shy and no collar
Des Moines - South
Lost: 6/30/2021
ID: 16860
Name: Bishop
Type: Dog
Color: Dark Brown/Black
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
County Line Road (South Des Moines) or SE5th close to Ft. Des Moines park
Cedar Rapids
Lost: 6/29/2021
ID: 17185
Name: India
Type: Cat
Color: Brown and gray tabby/tiger cat with white and peach markings
Breed: Australian Shepherd
Gender: Female
Fixed: Not Applicable
Age: Adult
Our beloved cat, India, missing since 6/29, in the Wanatee Creek Rd area. Mt Vernon Rd is the major cross street, and at the other end of Wanatee Creek Rd is Lakeside Rd. India is 11 years old. Brown and gray tabby/tiger cat with white and peach markings.
West Des Moines
Lost: 6/29/2021
ID: 17099
Name: Misty
Type: Cat
Color: Grey tiger stripe
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen on our acreage- she never goes far from home
Carlisle
Lost: 6/29/2021
ID: 17085
Name: Sam & Dean
Type: Other
Color: Black & white
Breed: Other
Gender: Male
Fixed: Not Neutered
Age: Baby
Goats were seen on our property in their pen. Gone within 20 min of us and our dogs coming inside. Goats have never left the property before. 10 week old fainting goats.
Dubuque
Lost: 6/29/2021
ID: 17077
Name: Peanut
Type: Dog
Color: Red
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
I put him out to go potty last night about midnight. By 1230 am, when I went out to get him, he was gone. Napp trailer court by John Deere. He's overly friendly and loves car rides.
Waterloo
Lost: 6/29/2021
ID: 17074
Name:
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Adult
Found on interstate 380 by mile marker 59
Walcott
Lost: 6/28/2021
ID: 17403
Name: Rose
Type: Cat
Color: Tortoiseshell-black brown & orange
Breed: Great Pyrenees
Gender: Unknown
Fixed: Neutered
Age: Adult
We think she jumped out at McDonald's at Walcott I80 exit but could have got out at I 80 westbound exit near Victor Ia. I don't have a picture but she looks just like the picture shown.
Waterloo
Lost: 6/28/2021
ID: 17209
Name: Twilight Sparkle
Type: Cat
Color: Tortieshell and white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Last seen western and 2nd in Waterloo
Waterloo
Lost: 6/28/2021
ID: 17145
Name: Twilight
Type: Cat
Color: 4 white paws, black and orange mottled with some white
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Twilight often spends the night with a neighbor but we have been unable to locate her this time. She is spayed.
Monticello
Lost: 6/28/2021
ID: 17088
Name: TC
Type: Cat
Color: White with brown markings
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Escaped behind Casey's gas station off the main street. She is super friendly and loves being held. We are offering a significant reward for her return.
Ankeny
Lost: 6/28/2021
ID: 17087
Name: Cheddar
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
West Des Moines
Lost: 6/28/2021
ID: 17078
Name: Luna
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Walnut woods park, she got spooked and ran off. Super sweet cat wont scratch
Huxley
Lost: 6/28/2021
ID: 17069
Name: Maci
Type: Dog
Color: Grey and white
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Young
4 pm, just gave birth 2 weeks ago
Des Moines - East
Lost: 6/28/2021
ID: 17064
Name: Pe pe
Type: Dog
Color: Black/White
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Unknown
Des Moines - South
Lost: 6/28/2021
ID: 17061
Name: Rosie
Type: Dog
Color: Tan white
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Adult
About noon when left for bf Gma funeral. Our Apts were broken into and destroyed. There is a reward leading to her return
Madrid
Lost: 6/27/2021
ID: 17105
Name: Baby
Type: Dog
Color: tan/fawn
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
6/29/21 we received a ping from her Tile on her collar near the Speedway in Boone. She has the Tile app so anyone else who has the Tile app and is within 400' of her will provide another ping of her location.
Farley
Lost: 6/27/2021
ID: 17055
Name: Puppy
Type: Dog
Color: White
Breed: Jack Russell Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Near the Corbin Farm off Highway 20 between Farley and Epworth
Urbandale
Lost: 6/27/2021
ID: 17054
Name: Tigger
Type: Cat
Color: Grey and black striped
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Won’t scratch or claw if you pick him up please call 515-210-5140 if you find Tigger.