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
Des Moines - South
Lost: 11/12/2017
ID: 7401
Name: Simba
Type: Cat
Color: Orange white cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Around south side by earl may on Indianola
Des Moines - East
Lost: 11/12/2017
ID: 7387
Name: Cujo
Type: Dog
Color: White,black and brown
Breed: Pomeranian Toy
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - East
Lost: 11/12/2017
ID: 7386
Name: Cujo
Type: Dog
Color: White,black and brown
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen was around 2pm on Sunday from my home
Ankeny
Lost: 11/12/2017
ID: 7381
Name: Scooby
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Baby
He was last seen in my apartment on Sunday morning around 8 since then he has gone missing
Des Moines - East
Lost: 11/12/2017
ID: 7378
Name:
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Applicable
Age: Adult
He was last seen on East 19th and Logan in Des Moines. he's orange and white and one of his ears is a little messed up from recently getting into a fight with another cat. His fur is a little bit longer but not real fluffy
Des Moines - East
Lost: 11/12/2017
ID: 7377
Name:
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Applicable
Age: Adult
He was last seen on East 19th and Logan in Des Moines. he's orange and white and one of his ears is a little messed up from recently getting into a fight with another cat. His fur is a little bit longer but not real fluffy
Patterson
Lost: 11/11/2017
ID: 7499
Name: Jersey
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Applicable
Age: Adult
South of Patterson with smaller black and brown dog named Reggie
Patterson
Lost: 11/11/2017
ID: 7498
Name: Jersey
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Applicable
Age: Adult
South of Patterson with smaller black and brown dog named Reggie
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