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>='1594080000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 3/28/2019
ID: 10850
Name: Dave
Type: Cat
Color: White Grey Brown
Breed:
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - West
Lost: 3/28/2019
ID: 10846
Name: Harley
Type: Dog
Color: Black white with Black and Tan spots
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Baby
Very timid just 12 weeks and not use to people but our family!
Des Moines - South
Lost: 3/27/2019
ID: 10859
Name: Cocoa
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen Thursday afternoon. She is very friendly. Is wearing a purple and gold University of Northern Iowa collar.
Corydon
Lost: 3/27/2019
ID: 10854
Name: Gizmo
Type: Dog
Color: Blonde and brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
Was in my parents yard and then gone. My mom older dog was left. I offering a reward for the safe return
Des Moines - Central
Lost: 3/27/2019
ID: 10851
Name: Bear
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
27th
Des Moines - South
Lost: 3/27/2019
ID: 10845
Name: Pete
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
My puppy got out last night and we can’t find find him. Golden retriever about 4 months old. South union by pleasant st. Please let me know if any one has him. His name is Pete. He has a black collar on with silver studs.
Mount Pleasant
Lost: 3/27/2019
ID: 10840
Name: Ruby
Type: Dog
Color: Black and brown
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
Mount Pleasant
Lost: 3/27/2019
ID: 10839
Name: Ruby
Type: Dog
Color: Black and brown
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Baby
Perry
Lost: 3/26/2019
ID: 10940
Name: Jasmine
Type: Cat
Color: Tiger stripes with white and brown
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Young
Last seen in Perry fleeing her home. She got out thru the garage and fled after the car started and scared her.
West Des Moines
Lost: 3/26/2019
ID: 10878
Name: Nikka
Type: Cat
Color: Tan
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Senior
By woodland avenue by valley high school
Hamilton
Lost: 3/26/2019
ID: 10857
Name: Azra
Type: Cat
Color: Grey and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Baby
Des Moines - South
Lost: 3/26/2019
ID: 10834
Name: Hunter lee
Type: Dog
Color: Mostly black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around south union and park ave.
Des Moines - South
Lost: 3/26/2019
ID: 10833
Name: Wallie
Type: Dog
Color: Brown/gray
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Got out at around 6pm.
Des Moines - South
Lost: 3/26/2019
ID: 10832
Name: Wallie
Type: Dog
Color: Brown/gray
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Pacific Junction
Lost: 3/25/2019
ID: 10925
Name: Lucy
Type: Cat
Color:
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
My friends dad was trying to get him before the food hit and he ran off
Ankeny
Lost: 3/25/2019
ID: 10887
Name: Verona
Type: Cat
Color: Charcoal Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Waukee
Lost: 3/25/2019
ID: 10844
Name: Violet
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Ankeny
Lost: 3/25/2019
ID: 10838
Name: Verona
Type: Cat
Color: Charcoal Gray
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Senior
Verona is mostly charcoal gray with small amount of tan on her feet and under her chin. She got out of our patio door Monday 3/26/19 evening. We live in NW Ankeny off of 1st street and need our baby home. Please let us know if you have seen her.
Ankeny
Lost: 3/25/2019
ID: 10829
Name: Lola
Type: Cat
Color: Tortoise shell
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She’s a very shy and timid kitty.
Des Moines - East
Lost: 3/25/2019
ID: 10826
Name: Binx
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 3/25/2019
ID: 10825
Name: Bella
Type: Dog
Color: Brown Black White
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Young
Seen around 1917 10th des moines, iowa 50314
Ankeny
Lost: 3/24/2019
ID: 10823
Name: Tank
Type: Cat
Color: Black/orange
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Adult
Nw pine road in ankeny
Des Moines - West
Lost: 3/24/2019
ID: 10819
Name: G-lee
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
31st and Woodland. She is very friendly.
Des Moines - East
Lost: 3/23/2019
ID: 10828
Name: Unknown
Type: Dog
Color: Light brown and white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 3/23/2019
ID: 10824
Name: Snowflake
Type: Cat
Color: White with brown tabby patches
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly large white cat with brown tabby spots on his back. He is an indoor only cat that escaped out the door on the corner of E. 33rd St & Indianapolis Ave.