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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 1/30/2016
ID: 2266
Name: Kane
Type: Dog
Color: White
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at E.23rd and Des Moines St.
Des Moines - North
Lost: 1/29/2016
ID: 2264
Name: Jax
Type: Dog
Color: Black and White
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 9pm near Firestone on 2nd Ave, he is a small black and white dog and he should come if you call out his name.
Des Moines - East
Lost: 1/24/2016
ID: 2246
Name: Onyx
Type: Dog
Color: Blue and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 1/23/2016
ID: 2270
Name: Lady
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Senior
16th and Lincoln 5154903517
Des Moines - South
Lost: 1/22/2016
ID: 3136
Name: Russo
Type: Dog
Color: Black with brown
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Young
He is a really nice dog !! He's been gone for a while , if you know where I could find him or have info please contact me !
Des Moines - South
Lost: 1/22/2016
ID: 2602
Name: Russo
Type: Dog
Color: Black and brown in mouth chest legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog ! If you seen him or may know where he is at please call me!
Des Moines - South
Lost: 1/22/2016
ID: 2364
Name: Russo
Type: Dog
Color: Black with brown around his mouth , legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Adult
He's a really nice and loving dog !! our family miss him so much , he's been gone for while now . If you have any information of where he is at or seen him , please call me !
Des Moines - North
Lost: 1/22/2016
ID: 2269
Name: Lady
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Senior
at the corner of 16th and lincoln 5154903517 please call if you've seen Lady I've very worried about her.
Des Moines - South
Lost: 1/22/2016
ID: 2262
Name: Russo
Type: Dog
Color: Black with brown on his chest , around his mouth , legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog. If you have any info please call me !
Des Moines - West
Lost: 1/22/2016
ID: 2237
Name: Unknown
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 1/22/2016
ID: 1971
Name: Russo
Type: Dog
Color: Black with brown on top of his eyes , around his mouth and on his legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog . If you know any info about him please call my number !
Des Moines - South
Lost: 1/22/2016
ID: 1951
Name: Russo
Type: Dog
Color: Black with brown no top of his eyes, around his mouth and legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog ! If you have any info please call my number .
Des Moines - East
Lost: 1/21/2016
ID: 2236
Name: Boo Boo
Type: Cat
Color: orange
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
On the 21st of January eating in the morning at home I live in a red barn house on se 26th court she's orange tiger strip with orange eyes with a pink harley davidson collar on she very lovable she was given to me by my daughter tasha who has passed away she's very very precious to me
Des Moines - East
Lost: 1/19/2016
ID: 2228
Name: Ryder
Type: Dog
Color: white with black markings
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
Last seen on east 27th st. and easton blvd.
Ankeny
Lost: 1/17/2016
ID: 2221
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Very friendly! Lost in north Ankeny late afternoon/early evening.
Des Moines - Central
Lost: 1/16/2016
ID: 2249
Name: Logan
Type: Dog
Color: White
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
E. 38th and Easton
Decorah
Lost: 1/16/2016
ID: 2239
Name: Rosabelle
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Young
At our home near burr oak iowa. Very friendly dog and answers to rosabelle.
Lorimor
Lost: 1/16/2016
ID: 2224
Name: Max
Type: Dog
Color: brown, tan and whit
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Lorimor Iowa
Runnells
Lost: 1/12/2016
ID: 2217
Name: Cy
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in the Runnells/Pleasant Hill area. East of Yellow Banks Park 2 miles. Has blue collar and possibly red harness.
Waterloo
Lost: 1/10/2016
ID: 2525
Name: Odin
Type: Dog
Color: White and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
I found him
Creston
Lost: 1/10/2016
ID: 2182
Name: Cinderella
Type: Dog
Color: Black
Breed: Shar Pei
Gender: Female
Fixed: Unknown
Age: Adult
Cinder was last seen around the Campground area at the City Park. She is small, around 30 pounds. She is known as a mini in her breed. She is shy and may not come up to people. She may run if approached. Please do not chase her. A little coaxing with food may be helpful. Stauffer's Animal Crackers will Win her over. Shake the bag and you may get her to come to you. Because of no sightings in Crestion after 4:30 pm, she may have headed out into the Open fields. May have found shelter in an open barn or shed.
Clarinda
Lost: 1/8/2016
ID: 2229
Name:
Type: Cat
Color: white and black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
that he is shy and we miss him
Des Moines - East
Lost: 1/5/2016
ID: 2167
Name: Fabi
Type: Dog
Color: tan and white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
English bulldog beagle mix. docked tail. if seen please call or text 515-443-9448
Des Moines - East
Lost: 1/5/2016
ID: 2162
Name: Fabbi
Type: Dog
Color: Tan with white chest
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
She is very skitches and most likely run from new people. Very sweet and don't bark. She has a bobbed tail. Please call 515-443-9448 if you see her or have found her thank you.
Des Moines - East
Lost: 1/5/2016
ID: 2161
Name: Fabi
Type: Dog
Color: tan and white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Fabi is skittish and nervous around New people. She's a 3 year old beagal English bulldog mix.