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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 7/7/2017
ID: 6140
Name: Hero
Type: Dog
Color: Light brown and dark brown with the white stripe
Breed: Groenendael
Gender: Female
Fixed: Not Neutered
Age: Adult
Last see at the north side library
Sheffield
Lost: 7/7/2017
ID: 6131
Name: Clayto
Type: Cat
Color: Black and WHITE
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Mear firshill cresent and home
Des Moines - North
Lost: 7/7/2017
ID: 6128
Name: Franklin
Type: Dog
Color: White and tan
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Off mondamin ave May have a blue bandana extremely friendly
Ankeny
Lost: 7/6/2017
ID: 6145
Name: Little Cat
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
We think she got out of the house the evening of 7/6 and we had the garage door open all night.
Indianola
Lost: 7/6/2017
ID: 6123
Name: Nin Nin
Type: Dog
Color: Black and tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
I am in need of help from the Indianola community! He is very skiddish, so if you find him, you might need to lure him with something!! He is wearing a tan collar with a red rabies tag.
Indianola
Lost: 7/5/2017
ID: 10469
Name: Nin-Nin
Type: Dog
Color: Black with brindle color on legs
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by 407 N J Street in Indianola Iowa. He is a chihuahua mix, about 12 pounds with a fatty abcess on his stomach. If you have any information, please contact me via email at c.o.vorwald@gmail.com
Des Moines - North
Lost: 7/5/2017
ID: 6132
Name: Oliver
Type: Cat
Color: Black, grey and some white
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
He may look grumpy, but he is sweet and lovable and we miss him a lot. My kids think he looks like a raccoon. If found, please call!!!
Des Moines - West
Lost: 7/5/2017
ID: 6118
Name: Charlie
Type: Cat
Color: White and Gray
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Loves being outside. Not declawed. Friendly. May nibble. Very chatty.
Osceola
Lost: 7/5/2017
ID: 6117
Name: Lizzy
Type: Dog
Color: Golden with white face
Breed: Golden Retriever
Gender: Female
Fixed: Not Applicable
Age: Senior
2718 Utah street Osceola Iowa Out side of New virginia
Des Moines - West
Lost: 7/5/2017
ID: 6106
Name: Charlie
Type: Cat
Color: White/Gray
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
May not come when called. Friendly and independent. Scared of cars.
Norwalk
Lost: 7/5/2017
ID: 6105
Name: Manny
Type: Dog
Color: Brindle
Breed: Greyhound
Gender: Male
Fixed: Neutered
Age: Adult
Scared by fireworks noise and ran off. Last seen at 30th Ave. and Harrison in Norwalk. Please call 912 665 4966.
Des Moines - Central
Lost: 7/4/2017
ID: 6546
Name: Johnny Baby
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Clark St And 4th, he is very vocal and responds to Johnny, John John, n Johnnybaby. He has poofy tale, medium/long hair, white spot on his lower tummy.
Mitchellville
Lost: 7/4/2017
ID: 6144
Name: Fergus
Type: Cat
Color: Black and White
Breed: Extra-Toes Cat (Hemingway Polydactyl)
Gender: Male
Fixed: Not Neutered
Age: Young
Fergus is the sweetest cat ever. Our family misses him dearly. He has 6 toes on his front paws and all 4 of his feet are white. He was last seen by 2 nd st NE and Arch.
Des Moines - West
Lost: 7/4/2017
ID: 6134
Name: princess
Type: Cat
Color: tortoise
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Ankeny
Lost: 7/4/2017
ID: 6122
Name: Phoenix
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in SW Ankeny
Norwalk
Lost: 7/4/2017
ID: 6107
Name: Unknown
Type: Dog
Color: White with darker spots throughout back
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Came to our home north of the Bevington, IA Kum and Go. I believe I saw him Monday come through the yard and my dogs scared him off. Had on what I believe to be a shock collar with a bright orange strap. Then on the night of the Fourth he returned as the fireworks were going off. Great dog, well mannered, loves to play ball, doesn't mind cats at all.
Des Moines - South
Lost: 7/4/2017
ID: 6095
Name: Jessie
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
Two rows of bottom teeth. Reward family dog
Ankeny
Lost: 7/4/2017
ID: 6088
Name: Ali
Type: Dog
Color: Brown
Breed: Dachshund
Gender: Female
Fixed: Neutered
Age: Adult
Lost on SE 9th from our backyard. Will bark at first but NOT aggressive!
Dysart
Lost: 7/4/2017
ID: 6087
Name: Ariel
Type: Dog
Color: Black White Brown
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Young
Entered Cornfield East of Dysart
Bondurant
Lost: 7/4/2017
ID: 6085
Name: Maxx
Type: Dog
Color: Black
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Ran from our back yard because of fireworks, we live rural
Dexter
Lost: 7/4/2017
ID: 6072
Name:
Type: Dog
Color: White
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
We found this beautiful girl on our deck this morning at Diamondhead Lake (north between Dexter and Stuart).
Birmingham
Lost: 7/3/2017
ID: 7218
Name: Kona
Type: Dog
Color: Black, white belly, white paws, white on face, white tip on tail, tan markings where the white and black meet.
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last sighting had him west of Birmingham, in the country, south of Interstate 34. Has been missing for several months; I am desperately searching and running out of hope.
Adair
Lost: 7/3/2017
ID: 6371
Name: Dusty
Type: Cat
Color: Gray And white
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Adult
Sightings by other residents on west end of town mid July . His home is on east end of town. Answers to his name and "food food food" (called they way you'd call here kitty kitty)
Mount Pleasant
Lost: 7/3/2017
ID: 6102
Name: Arizona
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Ran when she was spooked by neighborhood fireworks. Has not been seen so may have been picked up and taken to another town. Very friendly but scares easily.
Urbandale
Lost: 7/3/2017
ID: 6094
Name: Henry
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Collar is a Petsafe shock collar. Friendly cat, vocal, will tap you with his front paw to get attention.