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
Urbandale
Lost: 10/22/2016
ID: 4262
Name: Oliver
Type: Cat
Color: Black and white
Breed:
Gender: Male
Fixed: Not Neutered
Age: Young
He has a lil black freckle on his nose...down his back within his spots it maybe looks like the letter J. Big beautiful yellow eyes and offering a reward. He doesnt like collars but loves to climb all the way to the top of tree to show off ..$$$ reward plz help
Urbandale
Lost: 10/22/2016
ID: 4261
Name: Oliver
Type: Cat
Color: Black and white
Breed:
Gender: Male
Fixed: Not Neutered
Age: Young
He has a lil black freckle on his nose...down his back within his spots it maybe looks like the letter J. Big beautiful yellow eyes and offering a reward. He doesnt like collars but loves to climb all the way to the top of tree to show off ..$$$ reward plz help
Cedar Rapids
Lost: 10/22/2016
ID: 4240
Name: Mina
Type: Cat
Color: Black/white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
At home, she had a calico spot on her back left leg
Ankeny
Lost: 10/22/2016
ID: 4208
Name: Smokey
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
No front claws and has a little notch in one of his ears.
West Des Moines
Lost: 10/22/2016
ID: 4178
Name: Cheotos
Type: Cat
Color: Tiger Grey with Dark Stripes
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Green Eyes
Indianola
Lost: 10/22/2016
ID: 4159
Name: Sugar
Type: Dog
Color: Black & brown
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
She got out of her collar so she isn't wearing one. She is kind of shy of strangers. She has a loud bark. Her family misses her lots!
Urbandale
Lost: 10/22/2016
ID: 4137
Name: Sam
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is very friendly and will come up to you!
Urbandale
Lost: 10/21/2016
ID: 4156
Name: Dora
Type: Cat
Color: Black, white, and tan
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 5905 Townsend Ave, Urbandale. Dora has never been out of the house other than a couple times in the yard. She does know her name; she's less than a year old. Please call Jeremy at 712-320-0760 or Andrea at 712-209-4958. Thank you.
Ankeny
Lost: 10/21/2016
ID: 4136
Name: Newton
Type: Cat
Color: Dark orange and yellow.
Breed: Extra-Toes Cat (Hemingway Polydactyl)
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, last seen around 2 in the morning on October 21st 2016. He has black and white whiskers, 24 toes, bright green eyes! Very fat!! If anyone sees him or knows of anything please contact me!
Des Moines - West
Lost: 10/21/2016
ID: 4130
Name: Louie
Type: Dog
Color: White and brown
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Senior
He was last seen on the 32nd street block...he is really friendly
Des Moines - East
Lost: 10/20/2016
ID: 4270
Name: Pj
Type: Cat
Color: Black
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Adult
In home at 25th and Logan ave
Des Moines - East
Lost: 10/20/2016
ID: 4269
Name: Pj
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
In home at 25th and Logan ave
Corydon
Lost: 10/20/2016
ID: 4166
Name: Willie
Type: Pig
Color: Black with Redish undertones
Breed: Pot Bellied
Gender: Male
Fixed: Neutered
Age: Young
Willie was at a friends house just outside of Corydon Ia, when he went missing. He ran off with their dog into a corn field, the dog returned a few hours later however, we still have had no luck locating Willie. He is an indoor pet and is loved dearly. Please help our mini pot bellied piggy find his way home.
Corydon
Lost: 10/20/2016
ID: 4165
Name: Willie
Type: Pig
Color: Black with Redish undertones
Breed: Pot Bellied
Gender: Male
Fixed: Neutered
Age: Young
Willie was at a friends house just outside of Corydon Ia, when he went missing. He ran off with their dog into a corn field, the dog returned a few hours later however, we still have had no luck locating Willie. He is an indoor pet and is loved dearly. Please help our mini pot bellied piggy find his way home.
Norwalk
Lost: 10/20/2016
ID: 4119
Name: Georgia
Type: Dog
Color: White, tan, brown, black
Breed: Pot Bellied
Gender: Female
Fixed: Unknown
Age: Young
Missing from Norwalk. Please contact Stefanie or Kevin Hook at 515-808-0087 if she is found! Thank you!!
Des Moines - North
Lost: 10/20/2016
ID: 4115
Name: Odin
Type: Dog
Color: Gray and white
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Sioux City
Lost: 10/19/2016
ID: 4403
Name: Garfield
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Sioux City
Lost: 10/19/2016
ID: 4398
Name: Garfield
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Pleasant Hill
Lost: 10/19/2016
ID: 4176
Name: Roscoe
Type: Dog
Color: Brown has stripes looks likes a pit mix with husky slim tall ears big paws
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Call 515-779-9875 or 515-357-2092
Des Moines - East
Lost: 10/19/2016
ID: 4134
Name: Pete
Type: Cat
Color: Black/white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Norwoodville. Pete has 1/2 a black mustache
Des Moines - East
Lost: 10/19/2016
ID: 4133
Name: Pete
Type: Cat
Color: Black/white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Norwoodville. Pete has 1/2 a black mustache
Des Moines - East
Lost: 10/19/2016
ID: 4132
Name: Pete
Type: Cat
Color: Black/white
Breed: Tuxedo
Gender: Female
Fixed: Unknown
Age: Young
She has 1/2 a black mustache
Des Moines - South
Lost: 10/19/2016
ID: 4116
Name: Ruthie
Type: Dog
Color: tan
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Young
Ruthie was last seen in the Riverwoods Development on the South Side of Des Moines. She is about 15 lbs.
Clive
Lost: 10/19/2016
ID: 4114
Name: Beckham
Type: Dog
Color: black/grey spots
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
8:45 pm
Des Moines - East
Lost: 10/18/2016
ID: 4103
Name: Kamila
Type: Dog
Color: Tan
Breed: Pomeranian
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen on the east side of des moines around E 9th and fremont. She is very friendly and will come when called by her name