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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 7/6/2018
ID: 9078
Name: Gordo
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
On south side he is friendly won’t bite please call 5154414375 with info
Ankeny
Lost: 7/6/2018
ID: 9072
Name: King
Type: Cat
Color:
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
1010 SE Lowell Drive, Ankeny. He is microchipped. No collar is on.
Des Moines - Central
Lost: 7/6/2018
ID: 9069
Name: Captain
Type: Dog
Color: Brown/black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Lost German Shepherd male puppy. 7months old. Not yet neutered. Tall and skinny. Long skinny tail. Very loving.
Des Moines - Central
Lost: 7/6/2018
ID: 9068
Name: Captain
Type: Dog
Color: Brown/black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Lost 7month old puppy. Not yet nurtured. Tall and skinny. Very loving
Atlantic
Lost: 7/5/2018
ID: 9135
Name: Chewy
Type: Dog
Color: Reverse Brindle
Breed: Old English Bulldog
Gender: Female
Fixed: Not Neutered
Age: Adult
My dog was taken from my driveway 70222 630th St, Griswold, IA right on highway 71. She is my baby and my kids miss her terribly a
Des Moines - South
Lost: 7/5/2018
ID: 9097
Name: Opal
Type: Cat
Color: Black and white
Breed: Old English Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Escaped out the door when I let my dog out. Usually he wonders off and comes home in the morning. Haven't seen him since.
Ellsworth
Lost: 7/5/2018
ID: 9066
Name: Lilly
Type: Dog
Color: White and tan
Breed: Old English Bulldog
Gender: Male
Fixed: Unknown
Age: Senior
Wilson ave in Ellsworth
Stanwood
Lost: 7/5/2018
ID: 9061
Name: Erza
Type: Cat
Color: Multi
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Baby
Des Moines - East
Lost: 7/5/2018
ID: 9048
Name: Storm
Type: Dog
Color: Black amd white
Breed: Great Dane
Gender: Unknown
Fixed: Neutered
Age: Young
Corner of capitol and 19th street. I put them outsode to go to the bathroom took a phone call went out 20 min later and they are gone. They are together. He has blue collar and is fixed and chipped too. They are NOT outside dogs so the heat will be to much for them today. My number is 5154948852 they have tags with info on them also. Very hyper but friendly dogs.
Donnellson
Lost: 7/4/2018
ID: 9268
Name: Tal
Type: Cat
Color: Orange and cream, stripes. Has claws.
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
South of Donnellson in Lee county. Possibly and hopefully making his way northwest towards Henry, van buren, or Jefferson county where our farm is near Lockridge.
Collins
Lost: 7/4/2018
ID: 9188
Name: Maggie
Type: Dog
Color: liver
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
july4th. scared of fireworks. Ran off
Fairfield
Lost: 7/4/2018
ID: 9161
Name: Tal
Type: Cat
Color: Orange and cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen following car accident at 255th Street and 27 south of Donnellson, IA
Truro
Lost: 7/4/2018
ID: 9084
Name: Katie
Type: Dog
Color: Black
Breed: Basset Hound
Gender: Unknown
Fixed: Neutered
Age: Adult
She has a chip but for Tampa Florida area. She now lives in Truro, ia
Des Moines - South
Lost: 7/4/2018
ID: 9070
Name: Myla
Type: Dog
Color: Black & Brown
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Applicable
Age: Young
Myla was last seen south of Des Moines around 50320 area. Visiting family around Easter lake- Avon Cemetary area. We think she was frightened by fireworks and ran off. She is not familiar with that area.
Pleasant Hill
Lost: 7/4/2018
ID: 9067
Name: Ollie
Type: Cat
Color: brown and gray striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
St. Marys
Lost: 7/4/2018
ID: 9062
Name: Ruby
Type: Dog
Color: Reddish/golden
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen east of St.Marys, got scared by the fireworks and took off running west towards St.Marys.
Ankeny
Lost: 7/4/2018
ID: 9060
Name:
Type: Cat
Color: Black, white patch
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Young
2 black cats
Cambridge
Lost: 7/4/2018
ID: 9040
Name:
Type: Cat
Color: Dark brown withe a mix of tan
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Last seen in the White Oak Neighborhood
Des Moines - North
Lost: 7/4/2018
ID: 9038
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
“LOST “ dog . Part German Sheperd that answers to the name of CHIEF. He busy through a window because of all the fireworks and is bleeding . Lost in the 1600 block of Hull. He is a friendly dog. If found, please message me ASAP! Thank you 515 669 7100
Des Moines - North
Lost: 7/4/2018
ID: 9037
Name: Cheif
Type: Dog
Color: Brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
1600 block hull ave. “LOST “ dog . Part German Sheperd that answers to the name of CHIEF. He busy through a window because of all the fireworks and is bleeding . Lost in the 1600 block of Hull. He is a friendly dog.
Des Moines - North
Lost: 7/4/2018
ID: 9035
Name: Ms Beasley
Type: Cat
Color: Grey, brown, tan
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
We saw her last evening but we had company come over and she usually hides but we have looked all over and have not found her. We think she may have snuck outside when they were going in and out.
Granger
Lost: 7/4/2018
ID: 9031
Name: Baby
Type: Dog
Color: White with brown spots
Breed: Terrier
Gender: Unknown
Fixed: Neutered
Age: Adult
She was spooked by fireworks and was headed towards Jester park
Ames
Lost: 7/4/2018
ID: 9027
Name: Spanky
Type: Dog
Color: White/brown spots
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
West Ames by Mortensen St.
Keokuk
Lost: 7/3/2018
ID: 9483
Name: Lucy
Type: Cat
Color: gray with tiger stripes
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Last seen in Carbide Lane area of Keokuk. She was wearing a purple flea collar. Mostly shy & timid
Cumming
Lost: 7/3/2018
ID: 9056
Name: Whiskers
Type: Cat
Color: Black and brown tabby with white feet
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Baby
We adopted whiskers and his bonded buddy cheeta at the ARL Des Moines in July 2015 He is micro chipped Very very friendly kitty. Very affectionate and Loving He enjoys going outside with cheetah Please call with any info. We are missing whisker so much Thank you