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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 8/18/2019
ID: 12238
Name: Grendel
Type: Cat
Color: Gray
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 8/18/2019
ID: 12228
Name: Sheo
Type: Cat
Color: White
Breed: Turkish Angora
Gender: Male
Fixed: Unknown
Age: Baby
Last seen on sw Loomis. Has two colored eyes and is deaf.
Des Moines - South
Lost: 8/18/2019
ID: 12166
Name: Cypher
Type: Cat
Color: Black with white markings
Breed: Tuxedo
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen around 7500 SE Bloomfield Road. She has a scab behind her left ear from scratching too much. She’s possibly with her mom Eve Noelle who’s also reported as missing. Her paws are white as well as her nose and mouth area.
Des Moines - South
Lost: 8/18/2019
ID: 12165
Name: Eve Noelle
Type: Cat
Color: White
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen at 7500 SE Bloomfield Road. Possibly has her kitten Cypher with her who is also reported as lost. She has some scabs on her neck from scratching.
Des Moines - South
Lost: 8/18/2019
ID: 12157
Name:
Type: Dog
Color: Tan and while
Breed: Shiba Inu
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Lost: 8/17/2019
ID: 12187
Name: Kane
Type: Cat
Color: Brown tiger
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
He is a little shy.
Altoona
Lost: 8/17/2019
ID: 12152
Name: Oliver
Type: Cat
Color: Dark brown
Breed: Exotic Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 8/17/2019
ID: 12151
Name: Onyx
Type: Dog
Color: Dark brown
Breed: Exotic Shorthair
Gender: Female
Fixed: Unknown
Age: Senior
She's fast and unfortunately will not come to her name. Tried for 3 hours to catch her, last seen running towards mercy urgent care clinic off 1st St. In ankeny
Des Moines - West
Lost: 8/17/2019
ID: 12147
Name: Sophia
Type: Cat
Color: Grey & White
Breed: Exotic Shorthair
Gender: Female
Fixed: Not Neutered
Age: Young
Waterbury Area
West Des Moines
Lost: 8/17/2019
ID: 12145
Name: Jaeger
Type: Dog
Color: Black
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly
Ankeny
Lost: 8/17/2019
ID: 12143
Name: sammy
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
meows alot
Urbandale
Lost: 8/17/2019
ID: 12140
Name: Beau
Type: Dog
Color: Brown with white chest
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Applicable
Age: Young
Last seen on the corner of 76th and Oakwood. Likely traveling with another dog named Bailey. Very friendly!
Urbandale
Lost: 8/17/2019
ID: 12139
Name: Bailey
Type: Dog
Color: White, brown spots
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Not Applicable
Age: Young
Corner 76th Street And Oakwood Drive. Likely traveling with brown dog named Beau. Very friendly!
Pacific Junction
Lost: 8/16/2019
ID: 12176
Name: Bentley
Type: Dog
Color: brown, white and black
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
He went missing from area near Hwy 75 and Chicago Ave outside Plattsmouth. The Iowa boarder is not very far. We are offering a reward. We really want him home! He comes when asked if he wants a treat!
Des Moines - East
Lost: 8/16/2019
ID: 12162
Name: Baby girl
Type: Dog
Color: Med brown
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
We are looking for are baby girl she was taken out of the fence friday evening.
Ankeny
Lost: 8/16/2019
ID: 12160
Name: Lucy
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 8/16/2019
ID: 12136
Name:
Type: Dog
Color:
Breed: Bichon Frise
Gender: Unknown
Fixed: Neutered
Age: Senior
North of North high school, in Des Moines. Has id tags and license.
Denver
Lost: 8/16/2019
ID: 12134
Name: Scruffy (adopted name is Ike)
Type: Dog
Color: White
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Young
Denver Iowa cross street Killdeer Ave. and 260th St.
Des Moines - Central
Lost: 8/14/2019
ID: 12149
Name: Beans
Type: Cat
Color: Tan/black
Breed: Maltese
Gender: Male
Fixed: Unknown
Age: Adult
54th st. Between Madison and Aurora. Ran west. He walks with a limp due to his right leg being broken.
Des Moines - South
Lost: 8/14/2019
ID: 12135
Name: Bella
Type: Cat
Color: Orange,black, and fawn
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Adult
She has an orange spot on her forehead.
Dubuque
Lost: 8/13/2019
ID: 12156
Name: Annabelle
Type: Dog
Color: black
Breed: Labradoodle
Gender: Female
Fixed: Unknown
Age: Adult
my ex-wife gave her to lady Amy McDermott is her name
Des Moines - Central
Lost: 8/11/2019
ID: 12108
Name: mindy aronow
Type: Cat
Color: black
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
She lives at 4650 NW 52 street She is black long haired She is spayed. She goes by Sally and will come when called
Ankeny
Lost: 8/11/2019
ID: 12106
Name: Koby
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Baby
Washington
Lost: 8/11/2019
ID: 12105
Name: Ellen
Type: Dog
Color: White
Breed: Pointer
Gender: Female
Fixed: Neutered
Age: Senior
She is not familiar with running in the fields and farms. She may be afraid of people but she is used to the sound of four-wheelers. She is a retired sled dog and may follow along if you find her. She has pine tar dripping on her back from laying under the pine tree. And I've tried to give her a hair cut so you can see where I've clipped her hair.
Des Moines - South
Lost: 8/11/2019
ID: 12103
Name: Archer and Doby
Type: Dog
Color: White black and brown
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Sw 14th