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
Osceola
Lost: 5/1/2018
ID: 8427
Name: We Named Him Scooter
Type: Other
Color: Gold, cream, brown,
Breed: Other
Gender: Male
Fixed: Unknown
Age: Young
He is safe with a friend who has other chickens.
Griswold
Lost: 5/1/2018
ID: 8424
Name: Dante
Type: Dog
Color: Orange and white
Breed: Collie
Gender: Male
Fixed: Neutered
Age: Adult
Friendly loving dog up to date on shots no collar scared of storm please help get him home he's family
De Soto
Lost: 5/1/2018
ID: 8422
Name: Chloe
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen at Hawkeye Auto Salvage in DeSoto. Extremely friendly, her belly is shaved from being spayed recently.
Des Moines - East
Lost: 5/1/2018
ID: 8420
Name: Gerald
Type: Cat
Color: Black with white spots
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
This is an indoor cat
Johnston
Lost: 5/1/2018
ID: 8417
Name: Darby
Type: Dog
Color: Silver Beige
Breed: Poodle Standard
Gender: Female
Fixed: Neutered
Age: Adult
Dogwood Circle in Johnston, Iowa
Des Moines - West
Lost: 4/30/2018
ID: 8501
Name: Cutter
Type: Dog
Color: tan and white
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen in des moines!!!
Des Moines - East
Lost: 4/30/2018
ID: 8426
Name:
Type: Cat
Color: Black/Gray/Whte
Breed: Staffordshire Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
Young, very pregnant cat found near 26th and Capitol Ave. Very hungry, no collar, no sign of ownership. She wouldn't leave me alone, jumped into my car and wouldn't leave. Brought her home with intention of getting her scanned for a chip the next day but she gave birth overnight to healthy kittens.
Johnston
Lost: 4/30/2018
ID:
Name:
Type: Dog
Color: White
Breed: Staffordshire Bull Terrier
Gender: Unknown
Fixed: Neutered
Age: Adult
Across the street, tried calling for her.
Altoona
Lost: 4/29/2018
ID: 8445
Name: Phoenix
Type: Bird
Color: Rainbow bright colors
Breed: Conure
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Lost: 4/29/2018
ID: 8411
Name: Tank
Type: Dog
Color: Brown, cream
Breed: Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Stolen from car at scheels in wdm. Pic from surveillance camera showed white avalanche truck and 2 Hispanic men.
Melcher-Dallas
Lost: 4/28/2018
ID: 8413
Name: Bear
Type: Cat
Color: Black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Senior
Shy senior cat, skinny due to strict diet from bad health.
Melcher-Dallas
Lost: 4/28/2018
ID: 8412
Name: Bear
Type: Cat
Color: Black & white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Senior
Bear is a 12 year old cat who is never outside but we are worried we have not seen him in two days. We have check the neighborhood multiple times he is very old & very skinny due to his strict diet.
Des Moines - South
Lost: 4/27/2018
ID: 8893
Name: Bella
Type: Dog
Color: White
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Baby
Answers to the name of Bella , has little pinkish on one of her eyes
Urbandale
Lost: 4/27/2018
ID: 8401
Name: found !!!
Type: Dog
Color:
Breed: Dachshund Long Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
Urbandale
Lost: 4/27/2018
ID: 8400
Name: found
Type: Dog
Color: black brown
Breed: Dachshund Long Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
metro ice arena aera
Des Moines - West
Lost: 4/27/2018
ID: 8397
Name: Catrick Swayze
Type: Cat
Color: Cream/gray
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Young
Corner of 37th and Crocker, wearing a blue collar
Des Moines - East
Lost: 4/26/2018
ID: 8402
Name: scooby
Type: Dog
Color: tan
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Very friendly. Dearly missed please call 5157106860
Ankeny
Lost: 4/26/2018
ID: 8393
Name: Whiskers
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Corner of SW Maple and SW Ordnance Rd in Ankeny
State Center
Lost: 4/26/2018
ID: 8391
Name: Felix
Type: Cat
Color: gray and black tabby with white on his chin, belly, and under his nose
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen morning of 4/26 on the far north side of town near St Paul Lutheran Church. Felix has 2 wounds behind his left ear. He's a bit skittish and will probably not come when called. He might come to food.
Eldridge
Lost: 4/26/2018
ID: 8390
Name: Macy
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
$100 reward if found!
Des Moines - Central
Lost: 4/26/2018
ID: 8386
Name: Russell
Type: Dog
Color: White & brindle with black patch over left eye
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
Ran out the door when my daughter opened it. Last seen E13th St between Mattern and Jefferson.
Des Moines - North
Lost: 4/26/2018
ID: 8383
Name: Sadie
Type: Dog
Color: Black and White and graying....
Breed: Rat Terrier
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen when we let her out to potty at 4:15 a.m. this morning... She is going deaf, arthritic and incontinent. She is 22 yrs old....
Clive
Lost: 4/26/2018
ID: 8381
Name: Zeke
Type: Dog
Color: Black and Brown
Breed: Rottweiler
Gender: Male
Fixed: Neutered
Age: Young
Last seen around 86th and hickman in clive. Is newly rescued, and doesn't know his name well.
Stratford
Lost: 4/25/2018
ID: 8403
Name: Destiny
Type: Dog
Color: Black & white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
We live in the country outside Stratford. She is very very friendly, will go up to anyone to be pet. Not a mean Bone in her. Had pups recently. She is my love!
Independence
Lost: 4/25/2018
ID: 8394
Name: Dominic or Dom
Type: Dog
Color: Black on top and face tan eyebrows and bottom half, mostly legs,arms,chin,and butt.
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
My Parents Home. 507 4TH St SE He answers to the name Dominic or Dom. I really miss him, I love him so much. Hope he is found. I can't stop thinking about him. He is mix of blue heeler, rat terrier and little bit Chihuahua.