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>='1424476800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 2/25/2015
ID: 7
Name: Bobby
Type: Dog
Color: White with black spots
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at 63rd St and Franklin
Newton
Lost: 2/25/2015
ID: 3
Name: Dogfood
Type: Bird
Color: grey,yellow, white
Breed: Cockatiel
Gender: Male
Fixed: Not Applicable
Age: Adult
7:20am East side near theisens headed towards Agnes Park. Dogfood slipped out the door on his beloved master yesterday morning. Dogfood will perch on your shoulder or finger, but is freightened by being grabbed. His master has been searching dilegently since it happened early wed morning. Expecially in light of the bad storm we just had. We know the wind was blowing with Western and NW gust. So dogfood cld be anywhere if he has survived the worse. So we arent prepared to give up on him yet. If you have seen, or find, Dogfood or know anything that cld help please please contact his loving companion Mark Bartlow through fb or at 641-521-2223.
Des Moines - South
Lost: 2/24/2015
ID: 1
Name: O Malley
Type: Cat
Color: Black and gray striped (Tabby)
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He ran out on 2/24 in the morning and just disappeared. He is skittish and will hide when startled. He acts scared with strangers, loud noises or unfamiliar environment. I think he is hiding but I hope he found someone or shelter. It will be 10 below tonight.
Des Moines - East
Lost: 2/23/2015
ID: 6
Name: zoey
Type: Dog
Color: white/yellow/tan
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen on Thompson St. Between E.14th and Glenbrook Dr. She's very friendly.
Hamburg
Lost: 12/24/2014
ID: 8
Name: Norah
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Earlham
Lost: 11/13/2014
ID: 10
Name: Greta
Type: Dog
Color: black/white/grey
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Missing from Earlham Iowa since November 13th. No sightings of her since.
West Des Moines
Lost: 9/26/2014
ID: 11
Name: Lady
Type: Dog
Color: White with white and tan strands mixed on ears
Breed: Maltese
Gender: Female
Fixed: Not Neutered
Age: Adult
Maltese/ Shihtzu Lady has skin color or pinkish on lower right corner of rim that is about 1 or2 millimeters. The rest of that lower eye rim is black. Other eye rim is completely black. Nose is black. Tail curls up towards back. Sometimes not always has a tooth that sticks out I believe the right side. Lady was taken from my home on 8655 Bridgewood Blvd/ 88th St. Close to Jordan Creek Mall. This picture is not Lady but it looks exactly like her. This dog I thought was her. It was in bad shape but I'm using the picture.
Des Moines - East
Lost: 6/25/2014
ID: 9
Name: Gunner
Type: Dog
Color: black with white under neck and chest
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Applicable
Age: Young
Last place was 27th capitol ave from garage the owner of house let him go and shut door so he couldn't get back in he has one nail on back foot that is white and like a spot or scar between eyes