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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Lost: 5/2/2019
ID: 11234
Name: Bean
Type: Cat
Color: Tortoiseshell
Breed: Tortoiseshell
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - South
Lost: 5/2/2019
ID: 11232
Name: Spotty
Type: Cat
Color: Black and white
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
Spotty is skittish at first but not aggressive in any way. He’s my dad’s buddy and we are heartbroken he’s missing. Please keep a lookout.
Bondurant
Lost: 5/2/2019
ID: 11220
Name: Tucker
Type: Dog
Color: Drk Brown
Breed: Italian Greyhound
Gender: Male
Fixed: Neutered
Age: Senior
Le Mars
Lost: 5/2/2019
ID: 11214
Name: Benito
Type: Dog
Color: Black and white
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
I think in the yards
Urbandale
Lost: 5/2/2019
ID: 11212
Name: Tess
Type: Dog
Color: Fawn
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Baby
Des Moines - East
Lost: 5/1/2019
ID: 11849
Name: Oscar
Type: Cat
Color: Tabby with white legs and belly
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Woodbine
Lost: 5/1/2019
ID: 11265
Name: King
Type: Dog
Color: White & cream
Breed: Anatolian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by Willow Lake area in Woodbine, IA Very friendly, went missing with daughter Sissy, and Zena white Great Pyrenees
Woodbine
Lost: 5/1/2019
ID: 11264
Name: Zena
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Female
Fixed: Neutered
Age: Young
Last seen by willow lake Woodbine, IA Recently spayed, 2 weeks out of surgery , she will need her stitches removed and I am worried about her getting an infection. Please call if you have or seen any of our 3 Great Pyrenees Went missing with King Anatolian Shepherd/ Pyrenees and sissy white Pyrenees
Woodbine
Lost: 5/1/2019
ID: 11263
Name: Sissy
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Female
Fixed: Neutered
Age: Young
Sissy is 11 months old, Recently spayed 2 weeks ago , she will need her stitches removed, she had a bald 2 bald spots on her back Extremely friend , and loves kids. Went missing with her dad King, Anatolian Shepherd/Pyrenees with black harness and went missing with Zena Pyrenees red collar All 3 recently fixed.
Des Moines - East
Lost: 5/1/2019
ID: 11208
Name: Missy
Type: Dog
Color: White
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Baby
Stewart st East side Des Moines
Davenport
Lost: 5/1/2019
ID: 11206
Name: Sheila
Type: Dog
Color: Red and white
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Adult
(563)200 2416. 528 west 6th St Davenport apt 2
Davenport
Lost: 5/1/2019
ID: 11205
Name: Sheila
Type: Dog
Color: Red and white
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Adult
Please help find sheila
Des Moines - South
Lost: 4/30/2019
ID: 11204
Name: Tito
Type: Dog
Color: Brown
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
Tito wondered off from the 300 block of Kenyon Ave
Altoona
Lost: 4/30/2019
ID: 11199
Name:
Type: Cat
Color:
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
Colfax
Lost: 4/30/2019
ID: 11197
Name: Tank
Type: Dog
Color: Black and white
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Very nice dog ,white with black spots
Des Moines - South
Lost: 4/29/2019
ID: 11203
Name: Hunter lee
Type: Dog
Color: Black with small white patch on chest
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Around south Union and park heading north
West Des Moines
Lost: 4/29/2019
ID: 11190
Name: Cecil
Type: Dog
Color: Black & White
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Holiday Park. He has a name tag with address & phone number listed.
Des Moines - South
Lost: 4/29/2019
ID: 11189
Name: Miley
Type: Cat
Color: Dark Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Miley was last seen 4/8/19 by SW 12th Pl and Thornton Ave. we miss her so very much and really want her to be home. She has no collar on so someone might have thought she was a stray and took her in. If you have any info please let us know. Help us find our babygirl please!
Des Moines - South
Lost: 4/29/2019
ID: 11188
Name: Snooki
Type: Dog
Color: Cream
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
From south side Des Moines by McKinley Elementary School but was seen last in Copper Creek area
Des Moines - South
Lost: 4/29/2019
ID: 11187
Name: Snooki
Type: Dog
Color: Cream
Breed: Poodle
Gender: Unknown
Fixed: Neutered
Age: Adult
From south side Des Moines by McKinley Elementary School but was seen last in Copper Creek area
Des Moines - North
Lost: 4/29/2019
ID: 11186
Name: Dirk
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
9pm around nw 46th pl and 2nd ave, escaped with the dog after knocking the screen out of the window, the dog came back.
Des Moines - North
Lost: 4/29/2019
ID: 11185
Name:
Type: Cat
Color: White
Breed: Russian Blue
Gender: Unknown
Fixed: Unknown
Age: Adult
Cat came walking around in the yard, purring at me. I did offer it food. This cat didn’t seem scared at all, and loves to talk.
Des Moines - Central
Lost: 4/29/2019
ID: 11184
Name: Snooki
Type: Dog
Color: Cream
Breed: Poodle
Gender: Unknown
Fixed: Neutered
Age: Adult
By McKinley Elementary School
Des Moines - South
Lost: 4/29/2019
ID: 11182
Name: Snooki
Type: Dog
Color: White/cream
Breed: Poodle
Gender: Unknown
Fixed: Neutered
Age: Adult
By McKinley Elementary School
Ankeny
Lost: 4/29/2019
ID: 11179
Name: Pearl
Type: Cat
Color: Light gray with dark gray
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Baby
Pearl got out of the house 4/9/19 or possibly the morning of 4/10/19. She most likely got out when the dogs were being let out. She has never been our before. Has all claws. She got out on Snyder Blvd which is just off of Oralabor Rd in Ankeny. Please help us get our baby home and contact 515-720-5523 if you spot her.