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
Cherokee
Lost: 11/11/2017
ID: 7435
Name: Oliver
Type: Cat
Color: Gray/black with white strip nose, belly and feet
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Mike and Judy O'Neal Home 5243 crest dr cherokee, IA 51012. Cross roads hwy 3 and keeline Rd. 712-225-5084. Please check your sheds, under decks, and garages.
Des Moines - North
Lost: 11/11/2017
ID: 7397
Name: Oscar
Type: Cat
Color: black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
the cornor of madison & bowdoin ... hes been gone for a few days & really worried about him .. he dosent like taking pictures with me but in that you can see the little scar & a little bit of his collar. hes all black with a little white on his chest , with a red collar .. has a little scar on his nose ...
Altoona
Lost: 11/11/2017
ID: 7384
Name: Scooter
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Scooter snuck out through our garage Saturday evening. We have been out searching the neighborhood since for our loveable boy. He is very friendly and might have even gone in someone's house to warm up.
Chariton
Lost: 11/10/2017
ID: 7430
Name: Kane and Pepper
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Baby
Both are missing. Male is black and white. Female is light colored
Des Moines - Central
Lost: 11/10/2017
ID: 7374
Name: Titus
Type: Dog
Color: black
Breed: Cocker Spaniel
Gender: Male
Fixed: Unknown
Age: Baby
Had ran off with chain that he pulled out of the ground
Urbandale
Lost: 11/10/2017
ID: 7372
Name: Pumba
Type: Dog
Color: White, Brown, black spots
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Young
Last seen 11/10, 10pm, his leash unclipped while he was out to go potty. Called his name and drove around looking for him with no success.
Davenport
Lost: 11/10/2017
ID: 7371
Name: Scarlett
Type: Dog
Color: Brindle and White
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Adult
Lost from the Days Inn on Northeast Ave. Went to dinner and she was gone when we returned. Unsure if she somehow opened the door or was taken. Friendly, beloved family pet.
Urbandale
Lost: 11/9/2017
ID: 7368
Name: Tosh
Type: Cat
Color: Orange
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Jensen Elementary.
Des Moines - North
Lost: 11/9/2017
ID: 7363
Name: Fergie
Type: Dog
Color: Brindle
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Senior
30th and shawnee area 50310
Randolph
Lost: 11/8/2017
ID: 7351
Name: Gray
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Still missing
Johnston
Lost: 11/8/2017
ID: 7422
Name: Baby
Type: Cat
Color: Orange and white. Freckles on his nose and white pointed tail
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Chapel Ridge Apartments
Johnston
Lost: 11/8/2017
ID: 7421
Name:
Type: Cat
Color: Orange and white. Freckles on his nose and white pointed tail
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Chapel Ridge Apartments
Des Moines - North
Lost: 11/8/2017
ID: 7375
Name: Spot
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Last seen at cambridge and madison friendly family companion loved and missed please help us bring him home
Des Moines - East
Lost: 11/8/2017
ID: 7352
Name: Daisy
Type: Dog
Color: White and Black
Breed: Great Dane
Gender: Unknown
Fixed: Not Applicable
Age: Young
Daisy is a sweet and shy 2 year old female Great Dane. Was last seen North of University Ave areound E 28th Street. Mostly white with black spots.
Des Moines - Central
Lost: 11/7/2017
ID: 7369
Name: Bo
Type: Cat
Color: Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was 15 lbs at his last vet exam (not that I'm expecting someone to weigh him, but to give an idea of his size). The only white spot he has is on his chin, and he does not have his collar. He is not declawed.
West Des Moines
Lost: 11/7/2017
ID: 7359
Name: Smoky or Kitty cat meow face
Type: Cat
Color: Gray striped
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Very friendly, does not respond to name.
Dallas Center
Lost: 11/6/2017
ID: 7393
Name: Atticus
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Wandered off from our acreage in Dallas Center
Harpers Ferry
Lost: 11/6/2017
ID: 7382
Name: Riley
Type: Dog
Color: Brindle
Breed: Mastiff
Gender: Male
Fixed: Neutered
Age: Adult
Riley is 5 years old. He is our house dog. He is seen in the picture with his owner. Thank you for helping him find his way home.
Des Moines - Central
Lost: 11/6/2017
ID: 7360
Name:
Type: Cat
Color: Grey
Breed: Mastiff
Gender: Female
Fixed: Unknown
Age: Adult
11/8 keeps trying to come into my house. Very friendly and very hungry!
Cumming
Lost: 11/6/2017
ID: 7353
Name: Squirt
Type: Cat
Color: Gray with stripes
Breed: Mastiff
Gender: Female
Fixed: Not Neutered
Age: Baby
Super friendly indoor kitten, she is litter trained and escaped the house Monday morning around 0630.
Des Moines - South
Lost: 11/5/2017
ID: 7339
Name: Máximo
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by Lincoln High School
Des Moines - Central
Lost: 11/5/2017
ID: 7328
Name:
Type: Dog
Color: Brown black white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Senior
MLK and university
Des Moines - North
Lost: 11/4/2017
ID: 7396
Name: Oscar
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Escaped out of house on the corner of Madison and Bowdoin.
Bondurant
Lost: 11/4/2017
ID: 7346
Name: Pumpkin
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Very sweet, loved....please help us locate pumpkin.
Des Moines - South
Lost: 11/3/2017
ID: 7458
Name: Mazimus Tank a Bank
Type: Dog
Color: Brown and Black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Young
Southside Walmart when my Rv went up in flames