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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Altoona
Lost: 8/6/2018
ID: 9326
Name: Yogi
Type: Dog
Color: Brown and white
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
LOST IN SW side of Altoona. He hoppped our fence.
Ankeny
Lost: 8/5/2018
ID: 9457
Name: Marcel
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 8/5/2018
ID: 9323
Name: Lily
Type: Dog
Color: White and brindle
Breed: American Bulldog
Gender: Unknown
Fixed: Neutered
Age: Baby
Last seen in the vicinity of East 23rd and Guthrie in Des Moines
Des Moines - East
Lost: 8/5/2018
ID: 9318
Name: Dallas and sky
Type: Dog
Color: One black one tan
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
Two dogs black one dallas tan one blue collar named sky
Des Moines - Central
Lost: 8/5/2018
ID: 9311
Name:
Type: Dog
Color: Black
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Found dragging a long metal chain
Des Moines - West
Lost: 8/4/2018
ID: 9338
Name: Alex
Type: Dog
Color: Black and white
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Unknown
Age: Young
Last seen at approximately 715 PM. Around 24th and Rollins Ave
Des Moines - East
Lost: 8/4/2018
ID: 9321
Name: Titan
Type: Dog
Color: White
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Senior
Was last seen at Sheridan Park on Hull Ave.
Des Moines - East
Lost: 8/4/2018
ID: 9319
Name: Titan
Type: Dog
Color: Pure white
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
730 am Saturday morning. Our toddler let him out. HE IS DEAF. Super sweet and lovable. And we miss him so much.
Des Moines - North
Lost: 8/4/2018
ID: 9314
Name: Chloe
Type: Cat
Color: Black with small white spots on her chest and belly
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen at 49th Place and Hickman road
Des Moines - South
Lost: 8/4/2018
ID: 9310
Name: Ralaya
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
Des Moines - West
Lost: 8/4/2018
ID: 9309
Name: Kitty
Type: Cat
Color: Grey
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Senior
Saraleigh Monroe is the owner.
Des Moines - South
Lost: 8/3/2018
ID: 9308
Name: Roma.
Type: Dog
Color: Merle, black and gray
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Young
Lost on the 500 block of wall Ave south side of des moines. He is one of the sweetest boys.
Dubuque
Lost: 8/3/2018
ID: 9307
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
3100 block of Brunskill Road. Name is Pines or Pinesy
Des Moines - West
Lost: 8/3/2018
ID: 9301
Name: Lola
Type: Dog
Color: Grey with cream stripes
Breed: American Staffordshire Terrier
Gender: Unknown
Fixed: Neutered
Age: Baby
Was in my backyard, boyfriend let them out and left her unattended. 4 white paws white tip on tail. 10th and Jefferson Ave. She needs medication we are worried sick!
Pleasant Hill
Lost: 8/3/2018
ID: 9300
Name:
Type: Dog
Color: Black with white chest and paws
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Indianola
Lost: 8/2/2018
ID: 10615
Name: Natalia
Type: Cat
Color: Siamese
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
Siamese mix cat. Skinny. Maybe missing a tooth or two. Hoarse meow. Large blue eyes. White spot between shoulders.
Des Moines - East
Lost: 8/2/2018
ID: 9302
Name: Moriana
Type: Cat
Color: Grey & white
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen on the middle of the block on E22nd & Capitol. She doesn't usually drift too far. I feel like someone has her.
Grimes
Lost: 8/2/2018
ID: 9294
Name: Pudding
Type: Cat
Color: White,orange,gray
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last saw Thursday 8/2 around 9:00 PM
Des Moines - West
Lost: 8/2/2018
ID: 9293
Name: Two Chihuahua dogs
Type: Dog
Color: Black
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Unknown
Age: Adult
With neighbors help leashed dogs and got them off busy street. I have them home with me for now but will be moving to shelter soon. Found on 44th St south of Franklin.
Des Moines - West
Lost: 8/2/2018
ID: 9292
Name: Two Chihuahas
Type: Dog
Color: Brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
With neighbors help leashed dogs and got them off busy street. I have them home with me for now but will be moving to shelter soon.
Sheldahl
Lost: 8/2/2018
ID: 9285
Name: Dixie
Type: Dog
Color: Dark brown with light brown striping
Breed: Plott Hound
Gender: Male
Fixed: Neutered
Age: Adult
She jumped the fence in the backyard and loves to chase birds, squirrels and rabbits. She listens to commands unless she is set on chasing something. She is nice and good with adults and children.
Winterset
Lost: 8/1/2018
ID: 9322
Name: Alley aka Sissy
Type: Cat
Color: Black and grey
Breed: Oriental Tabby
Gender: Female
Fixed: Neutered
Age: Young
Docked ear, tip of tail bent.
Runnells
Lost: 8/1/2018
ID: 9284
Name: Cooper
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
last seen at 56th in Runnells.
Urbandale
Lost: 8/1/2018
ID: 9282
Name: Nala
Type: Cat
Color: Gray and orange
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Baby
Runnells
Lost: 8/1/2018
ID: 9280
Name: Cooper
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
56th Ave in Runnells. Contact Jake at 515-689-7412 if found.