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>='1437609600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ames
Lost: 7/27/2015
ID: 1098
Name: Turtle
Type: Cat
Color: White on chest and face, calico on the black
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Baby
I live on S Hyland street in names so I assume she will be around there somewhere. She is very young and somewhat friendly but also skittish.
Des Moines - South
Lost: 7/26/2015
ID: 1096
Name: Bones
Type: Dog
Color: Black with white spot on chest
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at end of East Hackley Drive behind home depot. He will come if you call his name, sits, drops, eats anything about 8 years old but very energetic, mostly black but getting gray in his older age.
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.
Grundy Center
Lost: 7/25/2015
ID: 1085
Name: Sami
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 7/25/2015
ID: 1083
Name: Leo
Type: Dog
Color: Tan
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
Near 5100 block of Lower Beaver Rd in Des Moines, Iowa
Des Moines - North
Lost: 7/25/2015
ID: 1082
Name:
Type: Dog
Color:
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
Last seen in the Lower Beaver Rd area around 5100 block
Des Moines - Central
Lost: 7/24/2015
ID: 1091
Name: Morrison
Type: Cat
Color: Tabby (Brown, Grey, Black stripes)
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Morrison was last seen sneaking out of my house at 2123 60th St, Des Moines, 50322. He is very friendly and has a home that is worried sick about him. Please call, text or email anytime of the day or night if you have seen him!
Des Moines - Central
Lost: 7/24/2015
ID: 1081
Name: Junior – 2 1/2 year old VERY GENTLE Terrier mix
Type: Dog
Color: Brindle -(not my picture - my snout is a bit narrower - but good overall coloration - a bit darker perhaps
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
His sister was found in the 24th & High Street areas on 7/25/15 so I am hoping he is still in the area. PLEASE - even if the news is bad, let me know so I can stop worrying. I will worry until I find him. His name is JUNIOR - Call 515-779-5275 in Des Moines Len Also call 515-203-7620 alternate phone # - Ask for Len - mention Junior's name. Thank you!
Grimes
Lost: 7/24/2015
ID: 1080
Name: Zeke
Type: Dog
Color: Black with white paws
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Kids left the gate open and he escaped the yard evening of 7/24. Very friendly dog. Mostly black, white paws, long legs. Last seen in Grimes on northwest side of town. Please contact me if you've seen him! Thank you!
Johnston
Lost: 7/24/2015
ID: 1076
Name: Clayton
Type: Cat
Color: Off-White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 5624 Linden Circle, Johnston, Iowa. Near Pioneer Parkway/Greendale Road.