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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Lu Verne
Lost: 4/6/2016
ID: 2784
Name: Debo
Type: Dog
Color: Red with white
Breed:
Gender: Male
Fixed: Not Neutered
Age: Adult
Carpenter
Lost: 4/6/2016
ID: 2639
Name: Rebel
Type: Dog
Color: Blackish brown
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
He was seen on 4/7/2016, running south through a field, the people that saw him couldn't catch him.
Windsor Heights
Lost: 4/6/2016
ID: 2632
Name: EARL CRAIG
Type: Dog
Color: Blonde
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Earl is a blonde Shorkie. Shitzu and Yorkie mix. Last seen in Windsor Heights near 69th Street. Very skiddish and hard to catch. Please call 618-240-9015 ASAP if you see him.
Adel
Lost: 4/6/2016
ID: 2631
Name: Milli
Type: Dog
Color: White
Breed: GoldenDoodle
Gender: Female
Fixed: Unknown
Age: Young
Carlisle
Lost: 4/6/2016
ID: 2627
Name: Harley
Type: Dog
Color: Tan
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Carlisle in Hardin Dr. Very friendly. No collar on since he was able to get it off.
Des Moines - South
Lost: 4/6/2016
ID: 2626
Name: Chloe
Type: Dog
Color: Black/tan/white
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
last seen wearing a purple fleece with UNI on it and a pink harness
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.