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 - East
Lost: 5/6/2018
ID: 8500
Name: Lil bit
Type: Cat
Color: Black White Gray Orange
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
600 block of se 28th ct south of the fairgrounds
Ankeny
Lost: 5/6/2018
ID: 8481
Name: Autumn
Type: Cat
Color: Black, Grey hint of brown
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
She does not like dogs she has not met before and will possibly throw some claws. She is a loving kitty and her family misses her.
Des Moines - South
Lost: 5/6/2018
ID: 8478
Name: Ivy the black, tai is the tan
Type: Dog
Color: Black-tan
Breed: French Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
117 e Philip st Des Moines southside
Des Moines - South
Lost: 5/6/2018
ID: 8476
Name: Ivy-tai
Type: Dog
Color: One black, one tan
Breed: French Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
At 117 e Philip st Des Moines southside
Ankeny
Lost: 5/6/2018
ID: 8475
Name: Sherman
Type: Cat
Color: Peach
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the 2800 block of Glennbrooke court ankeny ia. Very friendly will answer to sherman or shermmy.. This is an older picture he looks the same in the face but bigger (lean) and long
Des Moines - South
Lost: 5/6/2018
ID: 8473
Name: Coco
Type: Dog
Color: Black
Breed: Pomeranian Toy
Gender: Female
Fixed: Unknown
Age: Adult
Grimes
Lost: 5/6/2018
ID: 8472
Name: Ginger
Type: Cat
Color: Orange
Breed: Oriental Short Hair
Gender: Female
Fixed: Not Applicable
Age: Adult
Meadowlark South, Grimes
Pleasant Hill
Lost: 5/6/2018
ID: 8469
Name: Caine
Type: Dog
Color: Brown
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 5/6/2018
ID: 8468
Name:
Type: Dog
Color:
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 5/5/2018
ID: 8502
Name: Fritz
Type: Cat
Color: Gray Striped
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the 1600 Block of Dean ave in Des Moines
Urbandale
Lost: 5/5/2018
ID: 8467
Name: Archer
Type: Cat
Color: Grey/brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Douglas and 70th in urbandale around 4 PM on May 5th.
West Des Moines
Lost: 5/5/2018
ID: 8454
Name: Zoey
Type: Dog
Color: White
Breed: Maltese
Gender: Female
Fixed: Neutered
Age: Adult
Zoey is very shy.
Des Moines - Central
Lost: 5/4/2018
ID: 8464
Name: Sallymae
Type: Dog
Color: Brown and white
Breed: Hound
Gender: Female
Fixed: Neutered
Age: Young
Ingersoll and 28th If u site her call me at 515 229 6739. She won't come to you
Des Moines - Central
Lost: 5/3/2018
ID: 8455
Name: Penny
Type: Cat
Color: Tri color longhair
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
She's an outside/inside cat that got lost or disorientated during the storm. Maybe she took shelter in someone's garage/shed or someone took her in during the storm
Woodward
Lost: 5/2/2018
ID: 8730
Name: Tinker
Type: Dog
Color: Tan/Black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Not Neutered
Age: Adult
Woodward
Lost: 5/2/2018
ID: 8558
Name: Tinker
Type: Dog
Color: Tan, Black, gray
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Not Neutered
Age: Adult
1480 300th St, she has a breast tumor
Woodward
Lost: 5/2/2018
ID: 8498
Name: Tinker
Type: Dog
Color: Tan, Black, gray
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Adult
last seen 300th St North of Woodward, South of the boy scout camp, Camp Matigwa. 7 lbs female.
Des Moines - East
Lost: 5/2/2018
ID: 8438
Name: Leo King
Type: Dog
Color: tan with white chest
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
e14th and mattern, should be with white american bulldog with brindle eyes
Des Moines - East
Lost: 5/2/2018
ID: 8437
Name: pluto King
Type: Dog
Color: white with brindle eyes and a black spot on head
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen near mattern ave and e14th
Des Moines - East
Lost: 5/2/2018
ID: 8435
Name: Midnight
Type: Cat
Color: Black and white
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Last seen on the corner of Capitol ave and 22nd st. Midnight is a loving cat, but hes easily scared and doesn't like strangers. He slipped outside this morning at 6am. This is his first time outside by himself.
Des Moines - East
Lost: 5/2/2018
ID: 8434
Name: Midnight
Type: Cat
Color: Black and white
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Last seen in the corner of Capitol ave and 22nd st. Hes a nice but scared of strangers. He slipped out this morning at 6am. My family and I havent seen him since
Des Moines - West
Lost: 5/1/2018
ID: 8436
Name: Prince
Type: Cat
Color: Brown black grey light emerald eyes
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
He was last seen in the Roosevelt area. His tail is turning white and grey. He was playing with our other kittens when we realized it was too quiet. Please reunite us with our cat! He is very missed. He is fairly timid.
Mitchellville
Lost: 5/1/2018
ID: 8432
Name: Buffy
Type: Cat
Color: Tan, Black, Gray, Tiger Striped
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
Last seen: (Ne 104th st mitchellville /its a gravel road) she has one messed up eye
Mitchellville
Lost: 5/1/2018
ID: 8431
Name: Buffy
Type: Cat
Color: Tan, Black, Gray, Tiger Striped
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Young
I last saw her on (NE 104th st ) its a gravel road She got out of a window and we live on 8 acres of land
Des Moines - South
Lost: 5/1/2018
ID: 8429
Name: Charlie
Type: Cat
Color: Black, Gray and Tan
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Adult
Charlie is an XL cat that has been missing since approximately Monday in the Easter Lake Area. Please call 515-724-9036 if found!! In the picture, Charlie is the closest one to the camera!