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
Ames
Lost: 8/8/2018
ID: 9419
Name: Trudy Lou
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen 56934 245th Street, SE of Ames. Green eyes, scared of strangers, very quiet meow.
Jewell Junction
Lost: 8/8/2018
ID: 9359
Name: Dora
Type: Cat
Color: Black and white Tuxedo
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen sleeping on our porch about the morning of the 8th
Des Moines - South
Lost: 8/8/2018
ID: 9352
Name: Chloe
Type: Dog
Color: white with tan spots
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Park Avenue and SW 9th area
Des Moines - South
Lost: 8/8/2018
ID: 9339
Name: Jax
Type: Dog
Color: Black/brown
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Young
Put outside chained up around 9 pm 937 gone
Des Moines - Central
Lost: 8/7/2018
ID: 9346
Name: Persephone/ Percy
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is freshly spayed so her belly is shaved. Last in the Sherman Hill neighborhood
Des Moines - Central
Lost: 8/7/2018
ID: 9334
Name:
Type: Dog
Color: Black
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Adult
19th and Keo
Paton
Lost: 8/6/2018
ID: 9441
Name: Casey
Type: Dog
Color: White/Grey/Brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - North
Lost: 8/6/2018
ID: 9336
Name: Layla
Type: Dog
Color: White
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Adult
We believe she was taken. Please help if anyone knows of her whereabouts.
Des Moines - North
Lost: 8/6/2018
ID: 9335
Name: Layla
Type: Dog
Color: White
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
Let her out to go potty and we believe she was taken. Please anyone tht has seen her, please help return our baby!!!
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.