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>='1571184000')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Lost: 5/2/2019
ID: 11235
Name: Bean
Type: Cat
Color: Tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Baby
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