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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Harvey
Lost: 11/27/2018
ID: 10166
Name: Ginger
Type: Dog
Color: White, yellow and black coloring on face
Breed: Great Pyrenees
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen just east of the old hwy 92 / T17 intersection. Please help!
Stuart
Lost: 11/26/2018
ID: 10158
Name: Tippy
Type: Dog
Color: Black, tan, and white
Breed: Dachshund
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen 2 blocks from her home at the local grocery store, Hometown Foods.
Ankeny
Lost: 11/26/2018
ID: 10119
Name: Leo
Type: Cat
Color: Grey
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly!!
Ankeny
Lost: 11/26/2018
ID: 10108
Name: Leo
Type: Cat
Color: Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Long hair gray cat named Leo. He is incredibly sweet. Lost on far north NE Briarwood in Ankeny near 118th street. Please call 515-571-7391.
Ankeny
Lost: 11/26/2018
ID: 10098
Name: Pippin
Type: Cat
Color: White/Orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Ashbrooke Apartments
Des Moines - Central
Lost: 11/26/2018
ID: 10096
Name: Wells
Type: Dog
Color: Multicoloredn
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Very friendly.. Got off chain in backyard by 40th and madison avenue off Douglas.
Des Moines - South
Lost: 11/26/2018
ID: 10091
Name: Stayley
Type: Dog
Color: Yellow
Breed: Labradoodle
Gender: Male
Fixed: Not Neutered
Age: Adult
Got out at se 30 th ct Easter lake
Des Moines - East
Lost: 11/25/2018
ID: 10114
Name: Duke
Type: Cat
Color: Black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Indianapolis Ave East side
Des Moines - South
Lost: 11/25/2018
ID: 10084
Name:
Type: Dog
Color:
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
Missing from se 5th and leach
Des Moines - Central
Lost: 11/24/2018
ID: 10209
Name: Meg
Type: Cat
Color: Gray with black stripes and a slight orange tint
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Young
She was let out of my apartment off Meredith and Hay by my roommate on accident. I don't know how she would have left the building but I put up flyers in the building and didn't hear anything and checked ARL.
Des Moines - Central
Lost: 11/24/2018
ID: 10110
Name: Louise
Type: Cat
Color: Grey and white
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Very sweet friendly cat last seen on Oak Forest Dr. South of Grand.
Des Moines - West
Lost: 11/24/2018
ID: 10104
Name: Yuki
Type: Cat
Color: White and grey
Breed: Turkish Van
Gender: Male
Fixed: Neutered
Age: Adult
Yuki was last seen in Beaverdale around 8pm on Saturday 11/24. He is an indoor/outdoor cat and has been coming and going for 5 years. He has never stayed out any longer than 8 hours and usually comes home sooner. He is a super friendly cat and loves people and children.
Des Moines - North
Lost: 11/24/2018
ID: 10102
Name: Navi
Type: Cat
Color: Brown/Black Tabby
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Navi is a very friendly and sweet kitty. He can also be quite timid. Our security cameras recorded him in the front yard near the steps at 5:11pm on 11/24. We are very hopeful that there is a nice family out there that has taken him in to keep him warm during these cold days. He is very precious to us - if you know anything at all ..even if it is sad news..please let us know.
Clare
Lost: 11/24/2018
ID: 10089
Name: Quinn
Type: Dog
Color: Tan
Breed: Poodle Standard
Gender: Male
Fixed: Not Neutered
Age: Young
He was possibly last seen in Barnum, IA on 11/25/18. Offering reward once found & returned safely!
Ames
Lost: 11/24/2018
ID: 10087
Name: Pippy
Type: Cat
Color: White
Breed: Poodle Standard
Gender: Unknown
Fixed: Neutered
Age: Young
Norwalk
Lost: 11/24/2018
ID: 10082
Name: Francesca
Type: Dog
Color: Black/white
Breed: Italian Greyhound
Gender: Female
Fixed: Neutered
Age: Adult
Waukee
Lost: 11/24/2018
ID: 10079
Name: Summer
Type: Cat
Color: Tabby Brown/Gray
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 11/24/2018
ID: 10076
Name: Unknown
Type: Dog
Color: Brown
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Also had a pink leash
Indianola
Lost: 11/24/2018
ID: 10075
Name: Cubbie
Type: Dog
Color: White
Breed: Poodle
Gender: Male
Fixed: Not Neutered
Age: Young
Our Irish doodle Cubbie took off chasing deer west side of town. My 8 year old is heart broken- please contact if seen.
Indianola
Lost: 11/24/2018
ID: 10074
Name: Cubbie
Type: Dog
Color: White
Breed: Labradoodle
Gender: Male
Fixed: Not Neutered
Age: Young
Our Irish doodle Cubbie took off chasing deer west side of town. My 8 year old is heart broken- please contact if seen.
Des Moines - South
Lost: 11/24/2018
ID: 10072
Name: Pookie
Type: Cat
Color: Gray black whute
Breed: Labradoodle
Gender: Male
Fixed: Not Neutered
Age: Adult
Big green eyes all white belly except one spot and it looks just like a happy face
Des Moines - Central
Lost: 11/23/2018
ID: 10218
Name: Cissy
Type: Cat
Color: Gray white long haired
Breed: Labradoodle
Gender: Female
Fixed: Neutered
Age: Senior
Last seen near Price Chopper in Beaverdale. She is very skiddish. Please call or text Barb if seen. 515-205-3167
Bellevue
Lost: 11/23/2018
ID: 10133
Name: KOKO
Type: Dog
Color: black silver long hair
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Young
Call 563-213-8257 if seen. has one Blue eye and one mostly brown eye. Very friendly Female dog.. Looks intimidating but she isn't. Husky/Akita mix.
Des Moines - East
Lost: 11/23/2018
ID: 10092
Name: Rocky
Type: Cat
Color: Orange
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in yard at 3249 State Ave. Des Moines, IA. He is very friendly to most people. He has a fatty cyst on his lower back.
Des Moines - East
Lost: 11/23/2018
ID: 10078
Name: King
Type: Dog
Color: White brindle
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Young
Very friendly. He got out of the gate e9th in university ave