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
Harlan
Lost: 7/27/2015
ID: 1731
Name: Blaze
Type: Dog
Color: White with some gray
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Very nice husky. Does like to jump up on you but ONLY to give you kisses! Will probably only come to you if you have food. He is very very sweet and friendly and knows his basic commands.
Des Moines - North
Lost: 7/25/2015
ID: 1109
Name: Zoey
Type: Cat
Color:
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
4th and Clark
Des Moines - North
Lost: 7/25/2015
ID: 1108
Name: Zoey
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
4th and Clark
Des Moines - Central
Lost: 7/25/2015
ID: 1102
Name: Starlet
Type: Cat
Color: White, brown and gray
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
Super sweet and friendly.
West Des Moines
Lost: 7/24/2015
ID:
Name: Pearl
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
White Oaks Villas townhome development near Grand Ave. and EP True in West Des Moines. She is super friendly and sweet.
West Des Moines
Lost: 7/24/2015
ID: 1070
Name:
Type: Dog
Color: Tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Female followed me home on Western Hills Drive in West Des Moines around 8 o'clock when I was walking my other dog she is now safe inside. please call with description of your dog.
West Des Moines
Lost: 7/24/2015
ID: 1069
Name:
Type: Dog
Color: Tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Female followed me home on Western Hills Drive in West Des Moines around 8 o'clock when I was walking my other dog she is now safe inside. please call with description of your dog.
Cedar Falls
Lost: 7/24/2015
ID:
Name: Cookie
Type: Dog
Color: black and white
Breed: Chihuahua
Gender: Female
Fixed: Not Applicable
Age: Adult
5425 University Ave
Pleasant Hill
Lost: 7/23/2015
ID: 1075
Name: Mac
Type: Cat
Color: orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Declawed on all four paws. Very long canine teeth. Black freckles on nose and lips. Has medical condition that requires medication. Emerald green eyes.
Urbandale
Lost: 7/22/2015
ID: 1107
Name: Boston
Type: Cat
Color: Black with White stripe on face tummy and feet
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Indoor/Outdoor buddy that wondered off for too long unexpectedly. Last seen between Aurora Ave and Meredith Dr off 61st st. Please help get my buddy back 5154470791
Des Moines - East
Lost: 7/21/2015
ID: 1269
Name: Rondo
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - West
Lost: 7/21/2015
ID:
Name: Rupert
Type: Cat
Color: White
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 7/21/2015
ID: 1052
Name: littlebear
Type: Cat
Color: orange tips, white body, striped tail (orange)
Breed: Himalayan
Gender: Male
Fixed: Not Neutered
Age: Young
35th and cottage grove. He's never been outside before so probably scared to death. He sleeps snuggled with my 2 year old every night, so sweet and has a super purchase motor. We are sick with worry and miss him so much!
Ankeny
Lost: 7/21/2015
ID: 1043
Name: Cooper
Type: Dog
Color: brown and white
Breed: Poodle Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
In autumn ridge estates in ankeny. Very friendly as we have 3 kids under 4. Please contact us!
Pleasant Hill
Lost: 7/20/2015
ID: 1061
Name: Ares
Type: Cat
Color: Black with mixture of brown and grey
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Marion
Lost: 7/19/2015
ID: 1039
Name: Ginger
Type: Dog
Color: White w/ brown spots
Breed: Jack Russell Terrier
Gender: Female
Fixed: Neutered
Age: Senior
Last seen in Marion, not wearing any collar. She is a very small dog, like a chihuahua. Also has a brown spot on the back not visible in picture
Des Moines - East
Lost: 7/19/2015
ID: 1038
Name: scooter
Type: Dog
Color: black and white
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
he needs his seizure meds!! last seen east 14th and royer. grandview college area. please help find our dog.
Des Moines - North
Lost: 7/19/2015
ID: 1037
Name: scooter
Type: Dog
Color: white and black
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
he needs his seizure medication!! please if you see him call us we are very worried. he is very lovable and playful and high energy. last seen east 14th and royer. grandview area.
Polk City
Lost: 7/19/2015
ID: 1035
Name: Jingles
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Senior
Took off just south of Jester Park campgrounds. Friendly but sometimes sciddish
Polk City
Lost: 7/17/2015
ID: 1032
Name: Callie Mae
Type: Cat
Color: Calico - markings on back and head
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen 2 am Friday on Grimes St. May be hard to pick up or get her to approach but in need of food, water or shelter she may be easier to approach.
Des Moines - North
Lost: 7/17/2015
ID: 1018
Name: Jack jack
Type: Dog
Color: White and brown
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Last seen on twana Dr des Moines ia, he was not wearing a collar
New Hampton
Lost: 7/16/2015
ID: 1009
Name: Emma
Type: Dog
Color: light tan / white
Breed: Jack Russell Terrier
Gender: Female
Fixed: Not Applicable
Age: Adult
Emma moved from Des Moines to New Hampton in January 2015. She has a black tip tail. She has a shock collar. Friendly. Loveable. Adores children. Spayed. Microchip. Runs like a grayhound. 50 pounds. Tan/white.
Des Moines - Central
Lost: 7/15/2015
ID: 2279
Name: kebe
Type: Dog
Color: brown / black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Bonaparte
Lost: 7/15/2015
ID: 1900
Name: Faye
Type: Dog
Color: Blonde. Dark color nose.
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
A visitor accidentally let her out of our home, then followed her on Highway J40 into a driveway, which led to a hayfield. Believed to have gone back to Hwy and picked up by a traveler passing through the area. She was unfamiliar with area outside of our new property. Please help her find her way back home. Very loved and missed by her family.
Ankeny
Lost: 7/15/2015
ID: 1005
Name: oscar
Type: Cat
Color: blackcalico with flecks of gold and white and a tan paw
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Young
live on sw oakmont cat got out with my older cat. cat is friendly but typically will laydown if you try to get her and she lets you pick her up, her tummy is shaved and she is supposed to get fixed on 21st and get her shots etc. i love her please help me find her