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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 10/24/2016
ID: 4151
Name: ZuZu
Type: Cat
Color: Black, orange & white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Our cat hopped the backyard fence. She usually plays in the backyard but comes in when called. This is the first time she's escaped. She is gentle and may come when called. Declawed both front and back. Smaller for an adult. Her tail curls all the way to the tip. Microchipped through the main ARL.
Des Moines - North
Lost: 10/24/2016
ID: 4146
Name: Bella
Type: Dog
Color: Bridle dark brown light brown
Breed: Cairn Terrier
Gender: Unknown
Fixed: Unknown
Age: Baby
Last Fareway parking lot on Euclid ave. Jumped out of truck older owner tried to locate unable to. Very friendly does bark slot with strangers but never aggressive or mean. Has been her owners older retired vetenern. Companion love and joy for the six great years! Please contact if found No collar happy beautiful and friendly
Des Moines - North
Lost: 10/23/2016
ID: 4595
Name: Cassie
Type: Dog
Color: white w/ red streaks on her ears
Breed: English Setter
Gender: Female
Fixed: Neutered
Age: Senior
last seen E 14th and Euclid, DEAF, 13 yrs old, super friendly, loves to hunt, especially cats ,doesn't hurt them, just watches them.
Altoona
Lost: 10/23/2016
ID: 4188
Name: Sammy
Type: Cat
Color: Charcoal and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Went out on sunday and never returned. He has a white spot on his back and front declawed.
Altoona
Lost: 10/23/2016
ID: 4187
Name: Sammy
Type: Cat
Color: Charcoal and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Went outside sunday and never returned.
Des Moines - North
Lost: 10/23/2016
ID: 4177
Name: Cassie
Type: Dog
Color: white w/ red streaks on her ears
Breed: English Setter
Gender: Female
Fixed: Neutered
Age: Senior
cash saver e14th and euclid, Cassie is DEAF! very friendly, will go up to anyone
Lacona
Lost: 10/23/2016
ID: 4149
Name: Rainee
Type: Dog
Color: Tan & White
Breed: Cocker Spaniel
Gender: Female
Fixed: Neutered
Age: Senior
Last seen October 23rd. She takes heart medicine twice a day & needs the Asap!
Urbandale
Lost: 10/22/2016
ID: 4421
Name: Oliver
Type: Cat
Color: Black and white
Breed: Cocker Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
$$!! Reward offered for his return to his family . They miss him so much!!! He has a lil freckle on his nose and big yellow eyes and loves the outdoors but also loves to cuddle with a family member . plz help us find our lil buddy Oliver $$$ reward is offered for his return .
Urbandale
Lost: 10/22/2016
ID: 4420
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
$$!! Reward offered for his return to his family . They miss him so much!!! He has a lil freckle on his nose and big yellow eyes and loves the outdoors but also loves to cuddle with a family member . plz help us find our lil buddy Oliver $$$ reward is offered for his return .
Urbandale
Lost: 10/22/2016
ID: 4419
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Westpoint apts . Canterbury rd . He is very friendly big yellow eyes & a lil black freckle on his nose. I am offering a reward for his return , his family misses him so much . he loves the outdoors and loves to climb all the way to the top of trees to show off, but i know he is lookin for his family but cant find his way back plz help $$$ is offered for his return .
Urbandale
Lost: 10/22/2016
ID: 4262
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He has a lil black freckle on his nose...down his back within his spots it maybe looks like the letter J. Big beautiful yellow eyes and offering a reward. He doesnt like collars but loves to climb all the way to the top of tree to show off ..$$$ reward plz help
Urbandale
Lost: 10/22/2016
ID: 4261
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He has a lil black freckle on his nose...down his back within his spots it maybe looks like the letter J. Big beautiful yellow eyes and offering a reward. He doesnt like collars but loves to climb all the way to the top of tree to show off ..$$$ reward plz help
Cedar Rapids
Lost: 10/22/2016
ID: 4240
Name: Mina
Type: Cat
Color: Black/white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
At home, she had a calico spot on her back left leg
Ankeny
Lost: 10/22/2016
ID: 4208
Name: Smokey
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
No front claws and has a little notch in one of his ears.
West Des Moines
Lost: 10/22/2016
ID: 4178
Name: Cheotos
Type: Cat
Color: Tiger Grey with Dark Stripes
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Green Eyes
Indianola
Lost: 10/22/2016
ID: 4159
Name: Sugar
Type: Dog
Color: Black & brown
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
She got out of her collar so she isn't wearing one. She is kind of shy of strangers. She has a loud bark. Her family misses her lots!
Urbandale
Lost: 10/22/2016
ID: 4137
Name: Sam
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is very friendly and will come up to you!
Urbandale
Lost: 10/21/2016
ID: 4156
Name: Dora
Type: Cat
Color: Black, white, and tan
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 5905 Townsend Ave, Urbandale. Dora has never been out of the house other than a couple times in the yard. She does know her name; she's less than a year old. Please call Jeremy at 712-320-0760 or Andrea at 712-209-4958. Thank you.
Ankeny
Lost: 10/21/2016
ID: 4136
Name: Newton
Type: Cat
Color: Dark orange and yellow.
Breed: Extra-Toes Cat (Hemingway Polydactyl)
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, last seen around 2 in the morning on October 21st 2016. He has black and white whiskers, 24 toes, bright green eyes! Very fat!! If anyone sees him or knows of anything please contact me!
Des Moines - West
Lost: 10/21/2016
ID: 4130
Name: Louie
Type: Dog
Color: White and brown
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Senior
He was last seen on the 32nd street block...he is really friendly
Des Moines - East
Lost: 10/20/2016
ID: 4270
Name: Pj
Type: Cat
Color: Black
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Adult
In home at 25th and Logan ave
Des Moines - East
Lost: 10/20/2016
ID: 4269
Name: Pj
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
In home at 25th and Logan ave
Corydon
Lost: 10/20/2016
ID: 4166
Name: Willie
Type: Pig
Color: Black with Redish undertones
Breed: Pot Bellied
Gender: Male
Fixed: Neutered
Age: Young
Willie was at a friends house just outside of Corydon Ia, when he went missing. He ran off with their dog into a corn field, the dog returned a few hours later however, we still have had no luck locating Willie. He is an indoor pet and is loved dearly. Please help our mini pot bellied piggy find his way home.
Corydon
Lost: 10/20/2016
ID: 4165
Name: Willie
Type: Pig
Color: Black with Redish undertones
Breed: Pot Bellied
Gender: Male
Fixed: Neutered
Age: Young
Willie was at a friends house just outside of Corydon Ia, when he went missing. He ran off with their dog into a corn field, the dog returned a few hours later however, we still have had no luck locating Willie. He is an indoor pet and is loved dearly. Please help our mini pot bellied piggy find his way home.
Norwalk
Lost: 10/20/2016
ID: 4119
Name: Georgia
Type: Dog
Color: White, tan, brown, black
Breed: Pot Bellied
Gender: Female
Fixed: Unknown
Age: Young
Missing from Norwalk. Please contact Stefanie or Kevin Hook at 515-808-0087 if she is found! Thank you!!