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
Ankeny
Lost: 5/18/2016
ID: 2934
Name: Sweetie
Type: Dog
Color: Brown & Tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
Lost from NW School St & 5th in Ankeny in late morning on May 18
Des Moines - North
Lost: 5/17/2016
ID: 2930
Name: Bonnie
Type: Dog
Color: Red
Breed: Irish Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Last seen by Madison and Lawnwoods dr. Lower bever area. Des moines iowa
Johnston
Lost: 5/16/2016
ID: 3564
Name: Snoopy
Type: Cat
Color: He is white with brown\grey tips
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
he was last seen on NW 51st Street. he is a very friendly cat and loves kids. he is actualy my little sisters cat, she is 3 years old and lately she will all of the sudden say "where is my kitty cat?' It's realy sad and we've covinced he the he is visiting his friends and will be back soon, so please bring him back. Oh and is is trained to sit for a treat, he thinks he's a dog. any way we love him, miss him and we can't wait for him to come home, so, even if you only see him please call 515-829-8687 or bring him to 6689 NW 51st Street, Johnston, Iowa. Thanks
Johnston
Lost: 5/16/2016
ID: 3044
Name: Snoopy
Type: Cat
Color: white with gray/brown tips and tail gray/brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
last seen at home:6689 NW 51st street. WE LOVE OUR CAT SO PLEASE BRING HIM HOME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Johnston
Lost: 5/16/2016
ID: 3043
Name: Snoopy
Type: Cat
Color: domestic long hair white with tail and tips brown/gray
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Young
We last saw him at our house. He is friendly and loves kids. We love him so much so if seen bring him to 6689 NW 51st street Johnston, Iowa.
Des Moines - North
Lost: 5/15/2016
ID: 2989
Name: Daisy May
Type: Dog
Color: Fawn with black muzzle white spot on nose and white chest and pawns
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
Got out of friends fenced yard on Aurora and NW 2nd Ave. she is only two but she love to run and thinks being chased is a game. Please my kids and I miss her so much. We just pray to have her home.
Des Moines - North
Lost: 5/15/2016
ID: 2923
Name: Unknown
Type: Dog
Color: Black
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
Found on Euclid and 2nd. Will be going to the ARL in the morning.
Des Moines - East
Lost: 5/15/2016
ID: 2922
Name: Mac
Type: Dog
Color: Black with some white
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
He was last seen on the East side of Des Moines. He has high anxiety and may not come to someone that he does not know. Please call/text with any information or siting's of him so that we can get to that area and find him. Anything is appreciate, we are desperate to have him back. (712) 249-9337
Des Moines - South
Lost: 5/12/2016
ID: 2928
Name: Scratchy
Type: Cat
Color: Black with a few white hairs on chest
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Wed at 2 am a
Earlham
Lost: 5/12/2016
ID: 2924
Name:
Type: Rabbit
Color: white with black spots
Breed: Dutch
Gender: Male
Fixed: Unknown
Age: Young
170th & Green lane
Polk City
Lost: 5/12/2016
ID: 2914
Name: Lizzie
Type: Cat
Color: Grey striped tabby, short hair domestic
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Suspect she got out around 9-9:30 PM. Is shy by nature, but friendly.
Winterset
Lost: 5/11/2016
ID: 2901
Name: Jax
Type: Dog
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
$ 100 REWARD. Lost 8 MLS west of Winterset hwy 92 area. May be with young 16 week old Irish Wolfhound female puppy ( dark brindle ).
Winterset
Lost: 5/11/2016
ID: 2899
Name: Shiloh
Type: Dog
Color: Black brindle
Breed: Irish Wolfhound
Gender: Female
Fixed: Not Applicable
Age: Young
$100 REWARD . 8 miles west of Winterset hwy 92 area. Only 16 weeks old. May be with our old english sheepdog mix male, 9 y/o.
West Des Moines
Lost: 5/11/2016
ID: 2894
Name: spot
Type: Cat
Color: orange with white
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Baby
got out just before sundown
Glenwood
Lost: 5/10/2016
ID: 2907
Name: Olive
Type: Dog
Color: Black/Tan/White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Last seen at home early morning. Close to Pony Creek area NW of Glenwood. Eastman & 202nd. 402-598-3458
Cedar Rapids
Lost: 5/10/2016
ID: 2888
Name: Dexter
Type: Cat
Color: Black & White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
We live in the NW side of Cedar Rapids, off of E Ave close by Taft Middle school and Truman Elementary School. He is a big boy 18-20 lbs. He clawed through our back screen door last night and he hasn't come back home. PLEASE contact us if you find him as we miss him so much & just want him back home safe with us. 319-521-7713
Webster City
Lost: 5/10/2016
ID: 2884
Name:
Type: Dog
Color: Black brown brindle
Breed: Mastiff
Gender: Unknown
Fixed: Not Applicable
Age: Baby
We are missing 3 6 week old puppies! 2 are black and brown brindle and one is light brown
Des Moines - North
Lost: 5/10/2016
ID: 2883
Name: Toby
Type: Dog
Color: Black/White
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Neighbor stated he was picked up by ARL in our front yard, 33rd and Hickman area.
Des Moines - Central
Lost: 5/8/2016
ID: 2896
Name: Trouble
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Trouble escaped from our yard at 40th and Woodland in Des Moines. He's been missing for several days now. He's friendly, but very skittish and may be hiding in your bushes, under your car, or under your porch. If you see him, please let us know.
Des Moines - West
Lost: 5/8/2016
ID: 2889
Name: Thunder
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Friendly cat excellent pet to a devastated family , offering $200 reward
Des Moines - West
Lost: 5/8/2016
ID: 2865
Name: Cuddles
Type: Dog
Color: White, black, and gray
Breed: Tuxedo
Gender: Female
Fixed: Not Neutered
Age: Baby
She is a very friendly and we miss her dearly. Contact me at 515 943 3832 if you have any info. Thanks
Ames
Lost: 5/7/2016
ID: 2916
Name: Lily
Type: Cat
Color: Brown/black tiger
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
She does have claws on all four paws still. She is microchipped. Reward offered for safe return! I want my baby back!
Des Moines - East
Lost: 5/7/2016
ID: 2912
Name: maxi
Type: Dog
Color: brindle
Breed: Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
Des Moines - South
Lost: 5/7/2016
ID: 2872
Name: Diamond
Type: Dog
Color: Black/white
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 5/7/2016
ID: 2866
Name: Diamond
Type: Dog
Color: Black/white
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Near Fulton Dr area