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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Rock Rapids
Lost: 8/8/2015
ID: 1193
Name: Pugslie
Type: Dog
Color: Black Pug
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Senior
Pugslie is a black female pug, she ran off when neighbors decided to shoot off fireworks with out warning... we were outside enjoying the cooler evening, since pugslie cannot tolerate heat at all during the day... she does have a little wart/bump on her forehead
Des Moines - East
Lost: 8/8/2015
ID: 1183
Name: HARLEY
Type: Dog
Color: Brindle
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Des. Moines=eastside by fairgrounds. My daughters and I miss him dearly. Please contact if found.
Bondurant
Lost: 8/8/2015
ID:
Name: snickers
Type: Cat
Color: gray
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Our kitty got out last night and never returned. He is my sons cat. He is super friendly. His name is Snickers. Last seen in the 900 block of Lincoln St Se Bondurant.
Waukee
Lost: 8/8/2015
ID: 1163
Name: Benjamin
Type: Dog
Color: White
Breed: Old English Bulldog
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen at 9am by Le grant pkwy
Altoona
Lost: 8/6/2015
ID: 1160
Name: Boomer
Type: Dog
Color: Tan with White
Breed: Old English Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - South
Lost: 8/4/2015
ID: 1198
Name: shadow
Type: Dog
Color: white with brindel
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 8/4/2015
ID: 1146
Name: Pablo
Type: Cat
Color: brown and black
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Pablo escaped out of our house at 35th and Iola yesterday afternoon. He has done this before and tends to stay close by but hides under porches.
Des Moines - South
Lost: 8/4/2015
ID: 1143
Name: Jim
Type: Dog
Color: Brown
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
11pm on e. McKinley he is very afraid he's a service dog he's never been away from home or outside
West Des Moines
Lost: 8/4/2015
ID: 1141
Name:
Type: Cat
Color: Calico
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Found at Brown's Woods park wearing black collar with whit polka dots, pink trim. Looks about 6 months old.
Ankeny
Lost: 8/3/2015
ID: 1138
Name: HARLEY
Type: Cat
Color: Tiger tabby
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
He darted out our door last night we live off of NW Chapel Drive by Caseys.
Des Moines - East
Lost: 8/2/2015
ID: 1137
Name: Rocky
Type: Dog
Color: White and Carmel around ear
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Call 507 319 2688 515 988 6866 or 515 250 4959 If found. Please spread the word and help find him because our family are sadden by this event. He was last seen on 1113 Winegardner Rd Des Moines, IA, United States
Des Moines - East
Lost: 8/2/2015
ID: 1136
Name: Rocky
Type: Dog
Color: White and Carmel around ear
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Call 507 319 2688 515 988 6866 or 515 250 4959 If found. Please spread the word and help find him because our family are sadden by this event. He was last seen on 1113 Winegardner Rd Des Moines, IA, United States
Des Moines - East
Lost: 8/1/2015
ID: 1144
Name: Boots
Type: Cat
Color: Black/white boots
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Searsboro
Lost: 8/1/2015
ID: 1121
Name: Crown
Type: Dog
Color: Black and Tanish/Brown
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around Noon 8/2/2015. Crown is very missed! Pure Bred German Shepard, about 8 years old. Has a tip piece of his right ear torn off. He's friendly, as well as collar and leash trained. Crown has HIP DYSPLASIA so it is VERY important that we get him home to his family! Was last seen being picked up by 2 ladies in a WHITE SUV. Most likely living around the Grinnell - Newton - Monte - Sully area. He's also not microchipped and is neutered. Thank you to anyone who has shared! Very much appreciated! Please call/text/ or PM me on Facebook. https://www.facebook.com/babygirl.12358
Grinnell
Lost: 8/1/2015
ID: 1119
Name: Crown
Type: Dog
Color: Brown & Black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Adult
Picked up by 2 ladies in a WHITE SUV, those ladies had asked a couple weeks prior about who's dog it was. These girls are really missing their baby! Please help get Crown home!!!
Des Moines - Central
Lost: 7/31/2015
ID: 1123
Name: Ben
Type: Dog
Color: black and gray
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
Last seen around the 1500 block of 19th St. Family dog, children sad.
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.