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
Des Moines - South
Lost: 9/8/2015
ID: 1361
Name: Movado aka Mo Mo
Type: Dog
Color: white with caramel spots
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen by Fort Des Moines by Army Post Rd. He is a very friendly and loving dog. He may act very shy and timid and full of energy. The sides of his face has caramel spots along wit caramel spots on his back. He is my best friend and need to find him. Any tips help.
Des Moines - South
Lost: 9/7/2015
ID: 1589
Name: Jinx
Type: Cat
Color: Gray and black striped
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Polk City
Lost: 9/6/2015
ID: 1340
Name: Bently
Type: Dog
Color: tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Baby
Near polk city drive, little baby around 5 pounds
Ankeny
Lost: 9/6/2015
ID: 1339
Name: Bently
Type: Dog
Color: tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Baby
Near 1st st, around 6 pounds
Des Moines - South
Lost: 9/6/2015
ID: 1338
Name:
Type: Dog
Color:
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Found near Weeks MS on SSDSM. Great bath taker and playful. Does NOT enjoy cats or being left alone
Des Moines - East
Lost: 9/3/2015
ID: 1378
Name: niko
Type: Cat
Color: tan and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
last seen 1310 ovid ave des moines iowa there is a hundred dollar reward
Des Moines - East
Lost: 9/3/2015
ID: 1377
Name: gracie mae
Type: Cat
Color: tan and white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
last seen 1310 ovid ave des moines iowa there is 100 dollar reward
Des Moines - East
Lost: 9/3/2015
ID: 1376
Name: niko
Type: Cat
Color: tan and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
last seen 1310 ovid ave des moines iowa
Des Moines - East
Lost: 9/3/2015
ID: 1317
Name: Lucky
Type: Cat
Color: White with black tip ears, face, paws, ears
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
3900 block of e 32nd St & e Madison ave
Peterson
Lost: 9/2/2015
ID: 2206
Name: Tony
Type: Cat
Color: grey and black
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
He was temporarily staying at a farm in Peterson. May be at one of the other farms around Peterson.
Pleasant Hill
Lost: 9/2/2015
ID: 1460
Name: Little Bear
Type: Cat
Color: Brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Lost 9-2-2015 Evans Blvd and Parkridge Dr , Pleasant Hill, Ia 50327 Completely Brown 1.5 yr old male . Tip of tail is white and small spot of white on chest otherwise completely brown. Brown long whiskers . Stomach hair getting light and curl;y with mats starting under his arms. Went out after breakfast and never returned, gone quickly and has never done this before. Don't know if hurt or lost or anything . PLEASE HELP . 515-299-4709 OR 515-710-9808 MISSED DEARLY long HAIRED CAT AND TAIL LOOKS LIKE A BIG OLE BUSHY FEATHER DUSTER BUT FLAT ON ONE SIDE . PLEASE HELP US.. THANK YOU
Pleasant Hill
Lost: 9/2/2015
ID: 1323
Name: Bear
Type: Cat
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Evans Blvd and Parkridge location Big Completely brown 1.5 yrs old male cat with white tip on tail and just a bit on white on chest. Long hair Hair getting curly on stomach. Big boy last seen 9-2-15 am in pleasant hill along hwy 65 just east of Doanns park 515*-299-4709 or 515-710-9808 He ate breakfast and then disappeared. He has never not come back after eating. One brother and sister still here as they have been since birth. Please help find the 3rd musketeer. Very pretty rare color. Had Blue break away collar. If you took him in thinking he was a stray, thank you but he has a home that misses him like a child. Miss terribly please help him get home where is badly wanted. Don't know if he is hurt, alive or don't know anything //...PLEASE HELP 515-710-9808 515-299-4709
Pella
Lost: 9/2/2015
ID: 1318
Name: n/a
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Found abandoned/lost by Red Rock Marina
Seymour
Lost: 9/1/2015
ID: 1987
Name: Kiki
Type: Cat
Color: Gray and black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She was staying on a farm in Seymour and ran away. She has all her claws, and was in good health when lost. Might be a tabby cat.
Hartford
Lost: 9/1/2015
ID: 1322
Name: Ivy
Type: Dog
Color: Black and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Small white with black spots one blue eye and one brown eye.
Winterset
Lost: 8/30/2015
ID: 1362
Name: Luna
Type: Cat
Color: Gray, black, white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
S 8th Ave and Summit in Winterset
Winterset
Lost: 8/30/2015
ID: 1348
Name: Luna
Type: Cat
Color: Tabby/ White
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
corner of S 8th Ave and summit in Winterset Iowa
Clive
Lost: 8/30/2015
ID: 1300
Name: Charlie
Type: Cat
Color: Black & white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
5 pm Saturday, declawed front and back, glaucoma in right eye,grumpy deminor, beloved pet
West Des Moines
Lost: 8/28/2015
ID: 1311
Name: Rowdy
Type: Dog
Color: White with black and brown spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Jumped out of car in the Valley Junction area and ran into the woods. He is very friendly and will go to anyone. He is missed very much.
West Des Moines
Lost: 8/28/2015
ID: 1310
Name: Rowdy
Type: Dog
Color: White with black and brown spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Jumped out of car in the Valley Junction area and ran off into the woods. He is very friendly and will go to anyone. He needs to be found as he is very much missed.
Des Moines - East
Lost: 8/26/2015
ID: 1573
Name: kebe
Type: Dog
Color: brown and black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Adult
In back yard
Clarence
Lost: 8/25/2015
ID: 1307
Name: Timin
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
No tags but has phone number in permanent marker on his collar.
Des Moines - East
Lost: 8/25/2015
ID: 1282
Name: Stevie
Type: Cat
Color: White/Grey w/tiger stripes
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 5pm on Aug 25th. Very nice, but shy and probably wont let anyone approach. Used to be a fairly regular outdoor cat until his owner passed away. Last seen on East 29th street, at the intersection of E29th and Shawnee (Norwoodville area)
Des Moines - East
Lost: 8/24/2015
ID: 1365
Name: Reggie
Type: Cat
Color: Strawberry blonde
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Pleasant Hill
Lost: 8/24/2015
ID: 1297
Name: Loki, Persephone, Thor
Type: Cat
Color: Black, calico, gray and black tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen, dropped off by my boyfriends sisters and mother........ They took them to a little gathering of homes in pleasenthill hill just up the street from E. Oakwood Dr. I think it's NE 64th or 67th. But its also by rising sun Dr. As well. One is female. The brothers are boys. They are my babies and I miss them so much. I need them back!