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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 8/16/2015
ID: 1210
Name: Splash
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Baby
Brand new kitten we just adopted bolted! He's small, black. Has a sore on his nose that looks white and a couple other small sores. He was wearing a blue/yellow collar with a bell and a bow but no tags as we just got him.
Belmond
Lost: 8/15/2015
ID: 1211
Name: Buddy
Type: Dog
Color: white and black
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
By the Belmond swimming pool around 9a.m. He also has his blue leash attached to him. He's very sweet and shy also skittish. He ran away from my parents when they were at the Homestead Power Craft show by Belmond. My parents miss him like crazy and really need your help. He has his tags on also and my moms phone number is on it and they are also from Barnum. There is a $250 reward.
Des Moines - South
Lost: 8/14/2015
ID: 1302
Name: Scruffy
Type: Cat
Color: Gray with a white chin patch
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Applicable
Age: Adult
She's afraid of everyone and everything. She was an abused kitty when we adopted her. Please move slowly if possible. She has green eyes.
Runnells
Lost: 8/14/2015
ID: 1212
Name: Missy
Type: Cat
Color: Brindle
Breed: Tabby
Gender: Female
Fixed: Not Applicable
Age: Adult
****Reward for Missy's Return**** Please call day or night if you find her!
Maquoketa
Lost: 8/12/2015
ID: 1214
Name: Joker
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Last seen in Canton, near Maquoketa. May be hiding and scared.
Kelley
Lost: 8/11/2015
ID: 1215
Name: Freckles / also goes by Midget
Type: Cat
Color: Gray/White
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Kelley Iowa. She looks like a kitten, but is an adult dwarf cat. She had on a purple flea collar. She is timid, but she is a very sweet cat.
Des Moines - West
Lost: 8/11/2015
ID: 1206
Name: Goku
Type: Cat
Color: Brown , Has a lil M mark on forehead , meows a lot
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Cat was let out outside in Washigton Heights Apartments in West Des Moines IA Please call me if found (270) 421-4403
Des Moines - Central
Lost: 8/10/2015
ID: 1180
Name: Gotti
Type: Dog
Color: Gray and White
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
4140 50th St by Hoover High School if find please contact immediately.
Des Moines - West
Lost: 8/10/2015
ID: 1176
Name: Mr. Kitty
Type: Cat
Color: Brown Tiger and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
**REWARD FOR RETURN** He is declawed, last seen in Des Moines over by 56th St and Hickman, if found please call 515-979-4207
Des Moines - South
Lost: 8/9/2015
ID: 1172
Name: Whiskey
Type: Dog
Color: Tri
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
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!!!