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 - South
Lost: 9/10/2015
ID: 1382
Name: Cheta
Type: Cat
Color: Black and brown spotted
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Adult
Adair
Lost: 9/9/2015
ID: 1375
Name: Tank
Type: Dog
Color: Red
Breed: Redbone Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Lost Wednesday night northwest of Fontanelle
Adair
Lost: 9/9/2015
ID: 1374
Name: Tank
Type: Dog
Color: Red
Breed: Redbone Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Lost Wednesday night northwest of Fontanelle
Columbus Junction
Lost: 9/9/2015
ID: 1373
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Unknown
Age: Young
Please help and keep sharing. $$200 REWARD. Contact Walt Shellabarger with any information 5632998339. Lost on Burlington road fruitland/ Grandview area... Elegedly last seen by otools/Christmas tree farm. Comes to her name Jane or a good whistle.
Letts
Lost: 9/9/2015
ID: 1372
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Lost near Burlington road, last elegedly seen by otools/Christmas tree farm
Grandview
Lost: 9/9/2015
ID: 1371
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Lost by Burlington road... Last elegedly seen by otools/Christmas tree farm
Fruitland
Lost: 9/9/2015
ID: 1370
Name: Jane
Type: Dog
Color: Golden red brown
Breed: Chesapeake Bay Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Lost by Burlington road, last elegedly seen near otools/Christmas tree farm.
Des Moines - North
Lost: 9/9/2015
ID: 1356
Name: Lucky
Type: Dog
Color: Brown black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
E 9th & Sheridan ave
Des Moines - North
Lost: 9/9/2015
ID: 1355
Name: Lucky
Type: Dog
Color: Brown black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
E 9th & Sheridan ave
Des Moines - East
Lost: 9/8/2015
ID: 1408
Name: Bently
Type: Dog
Color: Black/brown/tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Near fairgrounds in DSM bently wanders away and makes it long ways from home from time to time he was wearing both regular college and fle collar and has tags but the phone number on his tags and microchip isn't current if he is found please call 5154473327 anytime day or night
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.