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
Pleasant Hill
Lost: 11/29/2016
ID: 4565
Name: Snowflake
Type: Cat
Color: White black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Very friendly will come to you inside cat loves to get outside when he can get away with it he always comes back but this time he didn't have the paperwork
Des Moines - South
Lost: 11/29/2016
ID: 4447
Name:
Type: Dog
Color: Brindel color
Breed: Pointer
Gender: Female
Fixed: Unknown
Age: Young
She was last seen at motel 6 on fluer drive. Her name is honey and she is my service pet. Pleas. Return her asap
Des Moines - South
Lost: 11/29/2016
ID: 4445
Name:
Type: Dog
Color: Brindel color
Breed: Pointer
Gender: Female
Fixed: Unknown
Age: Young
She was last seen at motel 6 on fluer drive. Her name is honey and she is my service pet. Pleas. Return her asap
Johnston
Lost: 11/29/2016
ID: 4444
Name: Clayton
Type: Cat
Color: Off White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very skittish, snuck out front door. Last seen near Linden Circle in Johnston.
Johnston
Lost: 11/29/2016
ID: 4443
Name: Clayton
Type: Cat
Color: Off White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very skiddish, indoor only cat, snuck out while someone opened the front door.
Des Moines - West
Lost: 11/29/2016
ID: 4435
Name: Max
Type: Dog
Color: Brown black white
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
He was in the back yard fenced in. He must of jumped over
Des Moines - West
Lost: 11/29/2016
ID: 4434
Name: Max
Type: Dog
Color: Brown black white
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Adult
He was in the back yard fenced in. He must of jumped over
Runnells
Lost: 11/28/2016
ID: 4560
Name: Molly
Type: Dog
Color: Blonde
Breed: Cairn Terrier
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 11/28/2016
ID: 4439
Name: Bella
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Grimes
Lost: 11/27/2016
ID:
Name: Jose
Type: Cat
Color: Yellow and whote
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Orange City
Lost: 11/27/2016
ID: 4460
Name: Thor
Type: Dog
Color: Copper
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on Sunday, earlier in the day.
Altoona
Lost: 11/27/2016
ID: 4428
Name: Jester
Type: Cat
Color: black & white (tux)
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Baby
6930 n.e. 59th st. no
Altoona
Lost: 11/27/2016
ID: 4427
Name: MO Jo
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Altoona Lake Shore Drive
Grimes
Lost: 11/27/2016
ID: 4426
Name: Jose
Type: Cat
Color: Yellow and whote
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 11/27/2016
ID: 2057
Name: Reuben
Type: Dog
Color: Brindle w/ Tuxedo
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Taking Reuben out for morning walk at Laurel Cemetery. Something snapped from his collar and he ran off chasing a dear. Please let me know if you find him!!!
Granger
Lost: 11/26/2016
ID: 4476
Name: lucy
Type: Dog
Color: white and brown
Breed: English Coonhound
Gender: Female
Fixed: Not Neutered
Age: Senior
Escaped from kennel. Around hwy 17 by bridge between Madrid and granger.
Des Moines - West
Lost: 11/26/2016
ID: 4425
Name: Darby
Type: Dog
Color: Black/dark brown
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Near 42nd and woodland an HR ago 10:00 am
Altoona
Lost: 11/23/2016
ID: 4414
Name: Phoenix (Cass)
Type: Dog
Color: Brindle black/brown
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
She's very friendly, loves kids. Somehow managed to open the door and get out
Des Moines - East
Lost: 11/22/2016
ID: 4408
Name: Ziggi
Type: Dog
Color: Black and brown with white paws and brown eyebrows
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
At the caseys on e 14th and Euclid
Runnells
Lost: 11/21/2016
ID: 4410
Name: Molly
Type: Dog
Color: Blonde
Breed: Cairn Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
459 se garrett dr
Altoona
Lost: 11/19/2016
ID: 4416
Name: Fat Fat
Type: Cat
Color: Tigger
Breed: Cairn Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
6930 NE 56th st Altoona he has a cricked tell at the end his 2 back feet have white very loving
Urbandale
Lost: 11/18/2016
ID: 4732
Name: Charlie
Type: Cat
Color: Black, Brown, Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Very sweet, has all of his claws, please help bring him home, my kids are devastated.
Durango
Lost: 11/18/2016
ID: 4450
Name: Lovey
Type: Dog
Color: Red/Black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Senior
Last seen Friday, Nov. 18 @ 9 pm when she went out potty. She is deaf, low vision, has only a few teeth. At that time her hair was longer than photo. She had a healing sore on her left upper leg. She is friendly and would go to anyone. Reward.
Fort Dodge
Lost: 11/18/2016
ID: 4404
Name: Chloe
Type: Cat
Color: Light brown with darker brown, Black and Tan stripes
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
Last seen in Fort Dodge on 9th avenue south between 14th and 15th street near Butler school and a few blocks from Olsen Park. Her family misses her so much. Please help me bring her home!!!!
Fort Dodge
Lost: 11/18/2016
ID: 4393
Name: Chloe
Type: Cat
Color: Light brown with darker brown and black stripes
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Last seen the morning of novemeber 18, 2016. In Fort Dosge Iowa on 9th avenue south between 14th and 15th steeet(near the Butler school area and a few blocks from Olsen Park. She has all of her claws.