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
Redfield
Lost: 12/5/2016
ID: 4526
Name: Barnabus
Type: Dog
Color: Black with a reddish tint
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
At the corner of highway 44 and p46 Dallas County Iowa. 10 miles south of Dawson, 8 miles east of Panora and 8 miles north of Redfield.
Chariton
Lost: 12/5/2016
ID: 4490
Name: Toby
Type: Dog
Color: Fawn w/ black mask
Breed: Mastiff
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen at Chariton airport and then later running past GW bank in Chariton with my other dog, possibly heading back home, disappeared right after that, black dog came home without him. He hasn't been seen since. We believe he might possibly be stolen. If you have any info of him or seen any sign of him anywhere please notify us at 641-931-0229
Berwick
Lost: 12/5/2016
ID: 4485
Name: Treble
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
1 mile north of Berwick
Ankeny
Lost: 12/5/2016
ID: 4482
Name: TREBLE
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
8.30.pm Dec 5
West Des Moines
Lost: 12/3/2016
ID:
Name: Phoebe
Type: Dog
Color: Black white and brown
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Last seen at Graveyard circle at Mills Civic and S 88th around noon on 12/3, she is skiddish and may run, call megan 515-974-9134, phoebe is so sweet but scared, we think heading home to waukee, she jumped the fence at Raccoon River Kennel at 10 am 12/3.
West Des Moines
Lost: 12/3/2016
ID:
Name: Phoebe
Type: Dog
Color: Black white and brown
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Last seen at Graveyard circle at Mills Civic and S 88th around noon on 12/3, she is skiddish and may run, call megan 515-974-9134, phoebe is so sweet but scared, we think heading home to waukee, she jumped the fence at Raccoon River Kennel at 10 am 12/3.
Des Moines - South
Lost: 12/3/2016
ID: 4466
Name: Tony
Type: Dog
Color: Black and white tan eye brows
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Boston terrier x daschund mix. Very hyper very happy is a jumper very approachable and will come when called. Very very very fast. Mistaken alot for a puppy pitbull. Does not bite and is not a Barker. Last seen this morning 530am on pioneer in between indianola and se5th.
Cumming
Lost: 12/2/2016
ID: 4487
Name: Nellie Rosa
Type: Cat
Color: Black and Orange Tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Maffitt Lake Farms
Cedar Falls
Lost: 12/2/2016
ID: 4464
Name: Belle
Type: Dog
Color: White/black
Breed: Basset Hound
Gender: Male
Fixed: Not Applicable
Age: Young
Won't let me select Waterloo.. But I'm on w 11th street in Waterloo and she got out overnight. I'm assuming chasing a squirrel. Doesn't have a collar on but she is chipped. She's really friendly. Call me at 3199392219
Urbandale
Lost: 11/30/2016
ID: 4730
Name: Zippy
Type: Dog
Color: fawn with white patch on chest and paws
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Adopted from the arl and they had him listed as a Labrador retriever mix, he look like he is mixed with terrier.
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!!!