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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
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
West Des Moines
Lost: 7/3/2018
ID: 9052
Name: Polly
Type: Dog
Color: Balck and White
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Baby
West Des Moines
Lost: 7/3/2018
ID: 9051
Name: Woody
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Baby
West Des Moines
Lost: 7/3/2018
ID: 9050
Name: Sally
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Baby
Mid afternoon, Border Collie pup 12 weeks old.
Bondurant
Lost: 7/3/2018
ID: 9045
Name: Laka
Type: Dog
Color: Brown-white, blue eyes
Breed: Alaskan Husky
Gender: Female
Fixed: Unknown
Age: Young
Last seen running into corn field between Bondurant and Mitchelville near I-80.
Des Moines - South
Lost: 7/3/2018
ID: 9034
Name: Maddy
Type: Cat
Color: Mackrel Tabby, Brown & Black tiger stripe
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
This is Maddy she was heading to the vet on 7/3/18 south side Des Moines (SW 3rd between Watrous & Rose)when the kennel broke open & she got loose. In a panic she ran into the trees/bushes behind the neighbors between SW 2nd off of Watrous and is now missing. Long hair, hates loud noises, scared, very timid and shy, hates to be picked up by people. She will hunker down and not move even if you are standing right next to her. She won't make a sound, but will growl or hiss if you try to pick her up or just run. No collar on & does not have a chip. She does have all of her claws. She is spayed & her belly hangs down alot. Please don't chase her, she will come to me if she can she me. Very skinny, weighs about 7 lbs she is 6 years old.
Bondurant
Lost: 7/3/2018
ID: 9029
Name: Olliver
Type: Dog
Color: Brown black white
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Senior
Dug out from underneath fence between 830-1030 pm.
Bondurant
Lost: 7/3/2018
ID: 9028
Name: Sully
Type: Dog
Color: Golden
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
Last seen running from 2nd st (Cemetry rd) through corn field toward high school.