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>='1562803200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 4/13/2016
ID: 2658
Name: Oscar
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Loves food . Very nice .
Bussey
Lost: 4/12/2016
ID: 2992
Name: Scarlet
Type: Dog
Color: Tricolor
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
She is my daughter's 7th birthday gift. Believe to be stolen. Reward offered.
Treynor
Lost: 4/12/2016
ID: 2722
Name: Ellie
Type: Dog
Color: White and black
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in town with a german shepard
Treynor
Lost: 4/12/2016
ID: 2661
Name: Ellie
Type: Dog
Color: White with black
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Ellie was last seen Tuesday April 12th at 10am. She's the sweetest and won't hurt you
Bondurant
Lost: 4/12/2016
ID: 2653
Name: Phillip
Type: Cat
Color: Yellow Tabby Manx
Breed: Manx
Gender: Male
Fixed: Unknown
Age: Adult
Has a short tail, is rather overweight, and timid around strangers. Very scared of other cats, but loves meat and will come for food. If found a reward will be given. 319-316-3032.
Des Moines - South
Lost: 4/12/2016
ID: 2652
Name: zoey
Type: Dog
Color: white
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on the south side of Des moines near James Cownie soccer complex
Altoona
Lost: 4/11/2016
ID: 2678
Name: Lego
Type: Cat
Color: Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen 4/11/2016. Lego is very sweet. He loves cat treats. His family misses him very much!! If you have seen him or have him please call. He is part of the family!!last seen 1st st e Altoona Iowa.
Des Moines - East
Lost: 4/9/2016
ID: 2670
Name: Rosco
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is scared of people he doesn't know well. Probably hiding somewhere.
Winfield
Lost: 4/7/2016
ID: 2643
Name: Nala and Daisy
Type: Dog
Color: Yellow Lab and Black Lab
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Last Seen at my house in winfield at 6 am thursday very loveable. My daughter best friends any help is a greatly appericated. Daisy Black lab has arthits in her back legs. I have a very heart broken 3 year old girl. PLEASE HELP
Des Moines - South
Lost: 4/7/2016
ID: 2637
Name: Tosser
Type: Cat
Color: White with orange spots
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Senior
In our back yard took off heading west across fenced in yards
Lu Verne
Lost: 4/6/2016
ID: 2784
Name: Debo
Type: Dog
Color: Red with white
Breed: Domestic Long Hair
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.