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: 4/1/2016
ID: 3803
Name: Lilo
Type: Dog
Color: reddish tan
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Young
Missing 5 months. 17 lbs when she went missing - small dog. Knee high at the top of her head. Shy, almost xenophobic. Reward offered if leading to just seeing her in person. Larger reward if it leads to retrieval. Do not try to catch as she will run. Call with any info: 515-257-6616.
Ankeny
Lost: 4/1/2016
ID: 3045
Name: Lilo
Type: Dog
Color: Tan to reddish brown with white socks and white streak down chin and chest.
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Adult
Call 515-257-6616. Consider placing this number in your cell phone to call while you have eyes on her. DO NOT CHASE. She is afraid of people. Last sighted 5/17 on NE Berwick Dr about 1/4 mile south of Oralabor. She tends to use culverts and ditches. Small dog, knee high at the top of her head. REWARD.
Des Moines - East
Lost: 4/1/2016
ID: 2616
Name: Be Be
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 4/1/2016
ID: 2615
Name: Colby jack
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is really nice, and if u whistle he will come 2 u.
Dubuque
Lost: 4/1/2016
ID: 2607
Name: Tommy
Type: Dog
Color: Black
Breed: Retriever, Labrador
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on the corner of 22nd and Central
Ankeny
Lost: 4/1/2016
ID: 2592
Name: LILO
Type: Dog
Color: Red with white paws looks like a fox
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Baby
She's very timid and may not come to people, try coaxing with a treat.
Des Moines - East
Lost: 4/1/2016
ID: 2586
Name: Oso little
Type: Dog
Color: Black
Breed: Shiba Inu
Gender: Male
Fixed: Not Neutered
Age: Adult
E.18Th n walnut Brandi 515-525-2722
Des Moines - South
Lost: 4/1/2016
ID: 2585
Name: Princess
Type: Dog
Color: Red
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
Was at hyvee pk ave jumped out of car
Ankeny
Lost: 4/1/2016
ID: 2582
Name: Itty
Type: Cat
Color: black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Itty is a sweet, loving kitty. He is front declawed but very athletic and vocal. Last seen at Belmont Park in Ankeny.
Redfield
Lost: 3/31/2016
ID: 2610
Name: JJ
Type: Dog
Color: Brown, Black, White
Breed: Poodle Miniature
Gender: Male
Fixed: Not Neutered
Age: Baby
Has a shaved face and the rest of his hair is long.
Redfield
Lost: 3/31/2016
ID: 2609
Name: JJ
Type: Dog
Color: Brown, Black, White
Breed: Poodle Miniature
Gender: Male
Fixed: Not Neutered
Age: Baby
Has a shaved face and the rest of his hair is long.
Redfield
Lost: 3/31/2016
ID: 2608
Name: Chevy
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Chevy has blue eyes. Had on a case international collar when she ran away.
Des Moines - South
Lost: 3/31/2016
ID: 2579
Name:
Type: Dog
Color: Black
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
Last seen on the Johnson street block near the blank park zoo
Des Moines - East
Lost: 3/30/2016
ID: 2581
Name: luka
Type: Cat
Color: black and white tuxedo
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen outside my house hes very nice and loving
Ankeny
Lost: 3/30/2016
ID: 2578
Name: Tawnie
Type: Dog
Color: White with apricot spots
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
She is a Cavachon. She has one ear that is shorter than the other.
Adair
Lost: 3/30/2016
ID: 2566
Name: Lilly
Type: Dog
Color: white with light tan on face.
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Neutered
Age: Baby
On Iowa I80 At rest area A2 in Adair. Lilly was traveling to Colorado with her Dad Alan Craig in an R.V. from Vermont. He stopped at the rest area for some sleep and took his other dog out at 12:30 am and thinks Lilly slipped out. He did not realize she was missing right away.
Adair
Lost: 3/30/2016
ID: 2565
Name: Lilly
Type: Dog
Color: white with light tan on face.
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Neutered
Age: Baby
On Iowa I80 At rest area A2 in Adair. Lilly was traveling to Colorado with her Dad Alan Craig in an R.V. from Vermont. He stopped at the rest area for some sleep and took his other dog out at 12:30 am and thinks Lilly slipped out. He did not realize she was missing right away.
Cedar Falls
Lost: 3/29/2016
ID: 2574
Name: Cali
Type: Cat
Color: White/Gray
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Left eye tends to water and build up. Small, real friendly cat
Greenfield
Lost: 3/28/2016
ID: 2570
Name: Nashville
Type: Dog
Color: Brown black
Breed: Coonhound
Gender: Male
Fixed: Not Neutered
Age: Baby
He is An amazing puppy he got out the door the 28 and we have t been able to find him he has always been an inside dog since we have had him and I don't think he can survive out side very long
Prairie City
Lost: 3/26/2016
ID: 2548
Name: Sadie
Type: Pig
Color: Black with white stripe
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
This pig is very tame. She usually comes right to me when called for. She likes her ears scratched and will roll on her tummy. She is a little intimidating, as probably weighs about 400 lbs.
Urbandale
Lost: 3/26/2016
ID: 2545
Name: Miss Kitty
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen Saturday night in Lockner Drive area of Urbandale.
Bagley
Lost: 3/25/2016
ID: 2683
Name: Bella Fi Fi
Type: Dog
Color: tan and black
Breed: Beagle
Gender: Female
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Lost: 3/25/2016
ID: 2547
Name: Rory
Type: Dog
Color: Tan with black on his back.
Breed: Norwegian Elkhound
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in front yard during day. He is very friendly and will not bite anyone if they come close, has intimidating bark but really 100% not a biting dog. Has arthritis so I kinda waddles.
Des Moines - West
Lost: 3/23/2016
ID: 2569
Name: Henry
Type: Cat
Color: Black/white
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Adult
Indoor/outdoor cat. Last seen going outside for his morning walk.
Des Moines - West
Lost: 3/23/2016
ID: 2568
Name: Henry
Type: Cat
Color: Tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult