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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 4/6/2016
ID: 2625
Name: Jesse
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Senior
He will probably come if you call him. He's partially blind. Please let us know
Des Moines - East
Lost: 4/6/2016
ID:
Name: Fred
Type: Dog
Color: red and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
4212 Thompson Ave, Des Moines, Ia 50317. Entered woods towads Pleasent Hill and Copper Creek area
Waterloo
Lost: 4/4/2016
ID: 2628
Name: Alvin
Type: Dog
Color: Black
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
ONEIDA ST. WATERLOO. HAS A YELLOW AND GREEN TAGS ON BLUE COLLAR.
Des Moines - Central
Lost: 4/3/2016
ID: 2620
Name: Charley dog
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Unknown
Fixed: Neutered
Age: Adult
She got out in the middle of a hair cut so she is half shaved, has a very large underbite
Des Moines - Central
Lost: 4/3/2016
ID: 2613
Name: Kyle
Type: Dog
Color: he is black with brown white and black on his face.
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
On Arlington ave is where he was last seen.
De Witt
Lost: 4/2/2016
ID: 3166
Name: Hawkeye
Type: Dog
Color: white and red black mask
Breed: Papillon
Gender: Male
Fixed: Not Neutered
Age: Adult
went missing from rural DeWitt.. Hawkeyes "brother" stayed home
Grimes
Lost: 4/2/2016
ID: 2595
Name: Unknown
Type: Dog
Color: Light brown
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Was running west on SE 19th and Jacob Street. Super friendly, another couple was taking the dog in for the night before calling ARL. I have the couples contact info.
Grimes
Lost: 4/2/2016
ID: 2594
Name: Tyrone
Type: Dog
Color: medium brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near corner of S. James and SE 19th Street. He was dropped off today at a feed store by his owner who could no longer care for him. The store said that if no one took him (and his "brother" today they would take them to the ARL tomorrow. We brought him home and he was very sweet and cuddly. When we took him outside he slipped of his collar and ran away very, very quickly. We hadn't even had time to take a photo. We think he may be looking for his previous owner, who lived in Winterset.
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.