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>='1596240000')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Lost: 8/7/2020
ID: 14641
Name:
Type: Dog
Color: brown
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
17000 block Baxter Drive
Central City
Lost: 8/7/2020
ID: 14640
Name:
Type: Cat
Color: Calico
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Young
Urbandale
Lost: 8/7/2020
ID: 14639
Name:
Type: Bird
Color: white
Breed: Chicken
Gender: Male
Fixed: Unknown
Age: Adult
600 Block Twana Drive
Des Moines - East
Lost: 8/7/2020
ID: 14637
Name: Quinn
Type: Cat
Color: Black, tan, orange
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Young
2000 block of Williams St
Johnston
Lost: 8/6/2020
ID: 14629
Name: Blue
Type: Bird
Color: blue
Breed: Parakeet
Gender: Male
Fixed: Unknown
Age: Young
Last seen around the Johnston fire department. Very friendly. cold rain and thunderstorms through the midday probably scared him, and may just be being very quiet.
Des Moines - South
Lost: 8/6/2020
ID: 14625
Name: Gidget
Type: Dog
Color: Tan/White
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Senior
She got out of the backyard off of SW 5th Street and Leach. She is a senior puggle and has never been out alone. Please help us find her
Des Moines - North
Lost: 8/5/2020
ID: 14630
Name: Princess Isabella “Izzy” or “Princess”
Type: Dog
Color: Reddish brown
Breed: Redbone Coonhound
Gender: Female
Fixed: Unknown
Age: Young
She was last known to be near Merle hay. If you do a hound dog howl she comes to it. She is very friendly and shows teeth when happy to smile.
Des Moines - West
Lost: 8/5/2020
ID: 14627
Name: Rotundus
Type: Cat
Color: Cream
Breed: Redbone Coonhound
Gender: Male
Fixed: Unknown
Age: Senior
Near Kingman and 42nd. Probably wouldn’t have gone far.
Mason City
Lost: 8/5/2020
ID: 14622
Name: Zoe
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Neutered
Age: Senior
Zoe ran off after getting her leash tangled while walking with my son. She had her halter and leash on the last time she was seen. No tags or chip.
Urbandale
Lost: 8/5/2020
ID: 14621
Name: Miss Kitty
Type: Cat
Color: Grey/tiger
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen 8/5/2020 before 9:45 am at Timberland Apartments on Iltis Dr. Family member accidentally left the screen door open to the balcony. She likes to hunt mice, ground squirrels, and baby bunnies. She has her claws and can climb trees. She is also a good jumper and can jump on tall furniture. We walked around the neighborhood, calling her name with no response. Please keep your eyes open for our dear cat. Thanks!
Bondurant
Lost: 8/4/2020
ID: 14623
Name: Olive
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Olive managed to jump off our back deck. She will most likely be hiding in a garage or back yard. We miss her!
Des Moines - North
Lost: 8/4/2020
ID: 14618
Name: Link
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
He has 3 legs. One paw on the front is bent up at an angle so it looks like he is hurt but he isn't. This is how he came to us.
West Des Moines
Lost: 8/4/2020
ID: 14614
Name: Tyton
Type: Cat
Color: orange with brown spots looks like mini lepard
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Adult
sumersby ct west des moines, the cat is indoor, looks like4 like mini leopard, very scared of strangers, may look intimidated from outside but very nice, attached to an owner, would not be readapted by others will rather die, special diet and vitamins, has a cheep ' if you will see him try to not approach if he is in your garage just keep him there and call an owner.
Ankeny
Lost: 8/3/2020
ID: 14626
Name: Calvin
Type: Cat
Color: Orange tabby with white and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in our yard at home. He is usually very friendly.
Ankeny
Lost: 8/3/2020
ID: 14612
Name: Lily
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Senior
Last seen in Ankeny between Magazine and Trilein Dr. Very friendly, does not have a collar on. She is a long haired cat, 2 back paws are white.
Altoona
Lost: 8/3/2020
ID: 14610
Name: cali
Type: Cat
Color: White and grey
Breed: Ragdoll
Gender: Female
Fixed: Neutered
Age: Adult
Last see in Altoona near Pinewood Ct SW in Venbury neighborhood.
Ankeny
Lost: 8/3/2020
ID: 14609
Name: Lily
Type: Cat
Color: Calico
Breed: Ragdoll
Gender: Unknown
Fixed: Unknown
Age: Senior
Last seen in Ankeny between Magazine and Trilein Dr.
West Des Moines
Lost: 8/3/2020
ID: 14608
Name: Lucy
Type: Dog
Color: White and red/brown
Breed: Dachshund-Miniature
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - West
Lost: 8/3/2020
ID: 14607
Name: Lucy
Type: Dog
Color: Red/Orange and White
Breed: Dachshund-Miniature
Gender: Female
Fixed: Neutered
Age: Young
She was last seen near Aspen Dr and 50th St in WDM, IA
Winterset
Lost: 8/2/2020
ID: 14635
Name: Smokey
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
On west North Street in Winterset
Lucas
Lost: 8/2/2020
ID: 14615
Name:
Type: Cat
Color: Black and brown
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Adult
Windsor Heights
Lost: 8/2/2020
ID: 14613
Name: Mona
Type: Cat
Color: Gray
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on 63rd St in Windsor Heights. She has a very soft meow.
Ankeny
Lost: 8/2/2020
ID: 14604
Name: Milkyway
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Front declawed Long hair
Ankeny
Lost: 8/1/2020
ID: 14598
Name: Merley
Type: Dog
Color: black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Baby
Everly
Lost: 7/31/2020
ID: 14611
Name: Bonnie
Type: Dog
Color: Black and brown
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Young