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 - West
Lost: 5/11/2015
ID: 518
Name: Yoda
Type: Cat
Color: Black
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
Last seen near 30th St 4 Blocks South of Hickman.
Indianola
Lost: 5/9/2015
ID: 543
Name: Riddick
Type: Dog
Color: bridle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Adult
Indianola
Lost: 5/9/2015
ID: 532
Name: Riddick
Type: Dog
Color: bridle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Adult
Summrset rd. .very friendly. White crest on chest
Des Moines - East
Lost: 5/9/2015
ID: 500
Name: Collin
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen on E 24th and Grand
Scranton
Lost: 5/8/2015
ID: 507
Name: Snuggles
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Not Neutered
Age: Adult
Blue collar, has been missing for a couple days was last seen by court.
Cedar Falls
Lost: 5/8/2015
ID: 504
Name: Karma
Type: Dog
Color: Brindle with white markings on face, chest, and paws
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen at 1504 Sunnyside Dr in Cedar Falls. She's a very friendly 5 month old Boxer Puppy. She means everything to me. PLEASE HELP!!! Contact Troy Felderman @ 256-797-6006. $500.00 Reward If Safely returned to Me!!
West Des Moines
Lost: 5/8/2015
ID: 502
Name:
Type: Cat
Color: striped brown gray black
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Young
Missy got out last night at the Noel crest townhouses in west des moines. She has never been outside so she will be very scared.(woodland ave area) it's my elderly mothers who's very upset losing her cat.
Des Moines - West
Lost: 5/8/2015
ID: 501
Name: Bosely
Type: Cat
Color: White, blackish grayish head
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Senior
Snuck out of our house on 59th street. right off of N.Waterbury Children miss him so much
Des Moines - East
Lost: 5/7/2015
ID: 574
Name: Kirra
Type: Dog
Color: Black and brown
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 5/6/2015
ID: 498
Name: molli
Type: Cat
Color: tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 5/6/2015
ID: 499
Name: molli
Type: Cat
Color: tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Young
Urbandale
Lost: 5/6/2015
ID: 493
Name: Bentley
Type: Dog
Color: White with black ears
Breed: Yorkie Poo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen about 89th Street & Horton
Adel
Lost: 5/4/2015
ID: 716
Name: Ball
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Colfax
Lost: 5/4/2015
ID: 465
Name: Puppy
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Adult
She does have a bad eye she is blind in. She bolted out the door during the storm when she got scared.
Waverly
Lost: 5/3/2015
ID: 830
Name: Kiki
Type: Cat
Color: Brown and white
Breed: Tabby
Gender: Unknown
Fixed: Not Applicable
Age: Adult
In our home, about two months ago. Everyday we wish for her safe return to us. We don't ever want to stop looking.
Ankeny
Lost: 5/3/2015
ID: 456
Name: winston was found
Type: Dog
Color:
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 5/3/2015
ID: 455
Name: winston
Type: Dog
Color: brown white and a little black
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Baby
in my backyard
Waukon
Lost: 5/2/2015
ID: 453
Name: Ruby
Type: Cat
Color: Black with with on stomach
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Ruby was take by a women with dark hair pulled back with bangs probably in her late 30's. She drove a grey/silver suv. Probably thought Ruby was a stray cat. She was taken Saturday between 2 and 3 p.m. a block north of Gus and Tony's Steakhouse. no collar. Ruby is black and has white fur on her stomach. missing a huge strip of fur because she had stickers caught on her fur and I had to cut them out.
Altoona
Lost: 5/1/2015
ID: 550
Name: tiger
Type: Cat
Color: calaco
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Council Bluffs
Lost: 5/1/2015
ID: 461
Name: Molly
Type: Dog
Color: Black with White tummy
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at the scene of a car accident on I-29 and exit 42. She ran west across the interstate. She is very shy and timid but never violent.
Johnston
Lost: 4/30/2015
ID: 497
Name: Pumba
Type: Cat
Color: orange and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Senior
Pumba was last seen in our house. He got out by accident. He is neutered and front declaw. He has medium length fur. He has allergies so his eyes are usually watery.
Woodburn
Lost: 4/30/2015
ID: 441
Name: patch
Type: Dog
Color: brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Patch has been found!!!!
Des Moines - East
Lost: 4/30/2015
ID: 434
Name: Mary
Type: Dog
Color: mostly black. some tan and white.
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Young
E29 th and Mahaska. Our front gate was accidentally left open and she wandered off around 7pm or 8pm. She is very friendly And gets along with other animlas. She has a curly tail.
Adel
Lost: 4/28/2015
ID: 510
Name: Ball
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
She's sweet but shy
Des Moines - South
Lost: 4/28/2015
ID: 425
Name: Diva
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last seen on Virginia Ave, south side of Des Moines. Shes very friendly. We've only lived in our home for 4 wks so shes familiar with the yard but not the area.