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 - South
Lost: 11/15/2017
ID: 7442
Name:
Type: Cat
Color: Black
Breed:
Gender: Male
Fixed: Neutered
Age: Adult
Medium- Large indoor/ outdoor cat WITHOUT HIS COLLAR. Overly friendly... probably has a second family somewhere, but we are looking for him. His names Frank, he's up to date on all shots, neutered and microchipped but he has not been turned into ARL. We live close to Quick Trip on se 14th and waterous and he has been known to visit.
Des Moines - North
Lost: 11/15/2017
ID: 7415
Name: bessie
Type: Dog
Color: white and black with black spots
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
last seen in the area of martin luther king and Euclid. she is a very friendly dog, can't post a photo because I didn't take any. also she is black and white with a lot of black spots. also she has a micro chip in #985113000958439
Pleasant Hill
Lost: 11/14/2017
ID: 7398
Name: Pookie
Type: Cat
Color: White and grey tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He’s mostly white with patches of grey tabby on his head, back, rear legs and tail. He is obese, neutered, front declawed and has been a strict indoor cat so he has no collar. He is incredibly friendly but may be skittish due to the situation.
Pella
Lost: 11/13/2017
ID: 7448
Name: Brooklyn
Type: Dog
Color: Mostly Black with orange markings
Breed: Beagle
Gender: Female
Fixed: Not Neutered
Age: Young
Outside of Otley at home
Pella
Lost: 11/13/2017
ID: 7444
Name: Brooklyn
Type: Dog
Color: Mostly Black with orange markings
Breed: Beagle
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at home in county outside of Otley, Iowa
Ankeny
Lost: 11/13/2017
ID: 7411
Name: Abu
Type: Cat
Color: Black and Tan calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
we live by Saylorville Lake. Inside outside cat.
Des Moines - East
Lost: 11/13/2017
ID: 7404
Name: Cujo
Type: Dog
Color: White and Black
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Adult
He is inside right now Call to pick him up
Pella
Lost: 11/13/2017
ID: 7399
Name: Brooklyn
Type: Dog
Color: Mostly Black with orange markings
Breed: Beagle
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen at our home on 11-13-17 (Dubuque Drive, Otley Iowa)
Pella
Lost: 11/13/2017
ID: 7391
Name: Brooklyn
Type: Dog
Color: Mostly Black with orange markings
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Young
Last seen at 11:00 Monday morning country outside of Otley Iowa, Brooklyn goes to Tri-County Veterinary Clinic in Pella, Iowa for her veterinary care.
Milo
Lost: 11/13/2017
ID: 7390
Name: Ace
Type: Dog
Color: Brown/black
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
Last seen at our home. Very friendly, would jump into anyone's vehicle.
Des Moines - South
Lost: 11/13/2017
ID: 7388
Name: Max
Type: Dog
Color: Red
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Adult
720 this morning.
Des Moines - South
Lost: 11/13/2017
ID: 7385
Name: Baby
Type: Dog
Color: Black with white on her chest stomach
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
She is very friendly but hyper and jumps a lot . Lost around se 20th st and evergreen
Grimes
Lost: 11/12/2017
ID: 7481
Name: Boots (Bootsie)
Type: Cat
Color: White and gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She’s an indoor/outdoor cat. Never been gone this long. We are worried and scared. She is very sweet and loving!
Grimes
Lost: 11/12/2017
ID: 7479
Name: Boots (Bootsie)
Type: Cat
Color: White and gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She’s an indoor/outdoor cat. Never been gone this long. We are worried and scared. She is very sweet and loving!
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.