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
Ankeny
Lost: 8/10/2018
ID: 9351
Name:
Type: Dog
Color: White / yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
At our home off of sw 41st ct 50023
Johnston
Lost: 8/10/2018
ID: 9347
Name:
Type: Dog
Color: Black, tan
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
Beaver ave and 54th
Des Moines - East
Lost: 8/9/2018
ID: 9397
Name: Shadow
Type: Cat
Color: Grey tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
14th and Dean. He is a very loving cat. He has some very distinct features. He is a polydactyl on 3 paws also has a half tail.
Des Moines - East
Lost: 8/9/2018
ID: 9348
Name: King
Type: Dog
Color: Brown and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
If anyone finds him please don’t let him outside by himself and call 515-313-5977
Des Moines - South
Lost: 8/9/2018
ID: 9344
Name: Kiwi
Type: Bird
Color: Green
Breed: Parrot
Gender: Unknown
Fixed: Unknown
Age: Baby
She was last seen by skate south she is very friendly and does answer to my kiwi there is a $100 reward
Des Moines - South
Lost: 8/9/2018
ID: 9340
Name: skip
Type: Dog
Color: Black
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Senior
Heading east on Summit Vista (east side of SW 31st) He's very friendly, chipped and has two tags on. (Owners live on Summit Vista) Cathy: 867.6688 mobile 244.4779 home
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