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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 10/18/2019
ID: 12637
Name: Molly
Type: Cat
Color: White black grey
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Greys lake apartment
Des Moines - South
Lost: 10/18/2019
ID: 12636
Name: Molly
Type: Cat
Color: White grey black
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at greys lake apartments
Des Moines - South
Lost: 10/18/2019
ID: 12630
Name: Zack
Type: Dog
Color: Black and brown
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Senior
Last seen running after a car. He is very friendly and won't bite. Please help us find him! He is the one in pink...
Des Moines - East
Lost: 10/18/2019
ID: 12629
Name: Chief
Type: Dog
Color: Brown and black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
Out in the backyard with max a yellow mixed lab
Des Moines - East
Lost: 10/18/2019
ID: 12628
Name: Max
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Was out in the back with my roommates dog Chief who is a German Shepard
Swisher
Lost: 10/17/2019
ID: 12657
Name: Louis
Type: Cat
Color: grey and white with stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
last seen between 140th st NE and James Ave. in Swisher IA
Des Moines - West
Lost: 10/16/2019
ID: 12626
Name: Simba
Type: Cat
Color: orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
shy
Des Moines - West
Lost: 10/16/2019
ID: 12625
Name: Simba
Type: Cat
Color: orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
shy
Grand Junction
Lost: 10/16/2019
ID: 12616
Name: Isabel (Izzy)
Type: Dog
Color: Augoti or Brownish with a white tipped tail
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
At the corner of 14th and Hager St. E. She does not bite but she is shy.
Des Moines - Central
Lost: 10/15/2019
ID: 12607
Name: Mac
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
26th and School Street. Mac is blind. He has no eyes, so he cannot find his way home. Snuck out while we were letting the dogs out. He is an indoor cat.
Hampton
Lost: 10/14/2019
ID: 12656
Name: Chester
Type: Cat
Color: Mostly Orange with white paws
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen last Monday early in the morning around the Coonley apartments. He's mostly Orange with darker Orange Tiger strips, with white paws. He's a m├ędium haired cat with kind of a puffier tail if that makes any sense lol.. I really need to find him..
Des Moines - West
Lost: 10/14/2019
ID: 12613
Name: Lulu
Type: Dog
Color: White brown spots
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Baby
Last seen in valley junction might have gone across the street into Des Moines
Des Moines - East
Lost: 10/14/2019
ID: 12612
Name: Suki
Type: Dog
Color: White/tan
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Senior
She was last seen in the backyard and escaped through the gate. She is very friendly and will come up to you if u have food.
Des Moines - South
Lost: 10/13/2019
ID: 12689
Name: Polo
Type: Cat
Color: Orange Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Very friendly cat! He is ALWAYS hungry! +
Ankeny
Lost: 10/13/2019
ID: 12659
Name: Baby
Type: Cat
Color: Brown with some black
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Young
Lost in northwest Ankeny. She has little tufts in her ears like a bobcat. Tortoiseshell coloring.
Des Moines - West
Lost: 10/13/2019
ID: 12606
Name: Luscious
Type: Dog
Color: White fur with brown feet if hair gets long.. you will see some brown in the fur on his back as well if the fur gets long
Breed: Poodle
Gender: Male
Fixed: Unknown
Age: Adult
He was last seen on the west side of Des Moines Iowa.. MLK pwky, ZIP Code 50314... he is very spoiled and he is very shy... but if you say his name he will know he close to home...
West Des Moines
Lost: 10/13/2019
ID: 12601
Name: Dipper
Type: Cat
Color: Brown and Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around 4916 EP True Pkwy in WDM. We are at 4632 EP True Pkwy 515-346-9984 Alissa 515-587-8553- Gary Dipper helps us with our anxiety and has no front or back claws. She is not microchipped. Please help us bring our kitty home!
Des Moines - East
Lost: 10/13/2019
ID: 12598
Name: Charles Walker Texas Ranger (Charley)
Type: Dog
Color: Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
My son left the back door open this evening. Charley is scared of EVERYTHING. He is very friendly. He is very large.
Indianola
Lost: 10/13/2019
ID: 12593
Name: Willie
Type: Dog
Color: Black & tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Last seen at R57 river bridge with female schnauzer named Sophie... Tammy from St. Mary's posted as missing... Trying to contact Tammy... Her phone number listed does not work
St. Marys
Lost: 10/13/2019
ID: 12592
Name:
Type: Dog
Color:
Breed: Schnauzer
Gender: Unknown
Fixed: Unknown
Age: Adult
County road r57 by iron bridge
Ankeny
Lost: 10/13/2019
ID: 12590
Name: Major
Type: Dog
Color: Black and Tan/red
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in northwest Ankeny.
Collins
Lost: 10/12/2019
ID: 12604
Name: Shadow
Type: Dog
Color: Tan and black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen late evening 10/12/19- very sweet dog
Ankeny
Lost: 10/12/2019
ID: 12597
Name: Windy
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
At home near sunset park in Ankeny around 9:30 pm Saturday night. He has a fatty tumor off center on his head as a defining mark.
Des Moines - South
Lost: 10/12/2019
ID: 12595
Name:
Type: Bird
Color: Cinnamon/gray
Breed: Cockatiel
Gender: Male
Fixed: Unknown
Age: Baby
Flew off of s union west by titus Will land on head or shoulder Name peanut
Winfield
Lost: 10/12/2019
ID: 12589
Name: Charlie
Type: Dog
Color: White with black spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Senior
He is very shy and scared. He had black spots all over his body. He weighs approximately 35 pounds, and he is always friendly.