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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 5/1/2021
ID: 16605
Name: Trix
Type: Cat
Color: Tortie
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 5/1/2021
ID: 16603
Name: Unknown
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
In Westchester Square Apartments
Ankeny
Lost: 5/1/2021
ID: 16602
Name: Ace
Type: Dog
Color: Red
Breed: Red Heeler
Gender: Male
Fixed: Not Neutered
Age: Young
Around the Autumn Ridge Mobile Home Park
Ackworth
Lost: 4/30/2021
ID: 17089
Name: golden retriever puppies for adoption
Type: Dog
Color:
Breed: Golden Retriever
Gender: Unknown
Fixed: Unknown
Age: Young
they are up to date in all their shots and love playing with kids and other home pets
Des Moines - South
Lost: 4/30/2021
ID: 16659
Name: Benny
Type: Cat
Color: White, grey, tan
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Adult
Ankeny
Lost: 4/30/2021
ID: 16630
Name: Mac
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Prairie Trail. He has a really long tail with white ring towards the end.
Des Moines - West
Lost: 4/30/2021
ID: 16610
Name: Manny
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 4/30/2021
ID: 16598
Name: Captain
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
He was last seen around 4pm yesterday, friendly.
Carlisle
Lost: 4/30/2021
ID: 16597
Name: Wiley
Type: Dog
Color: Black, white, grey
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Carlisle on Lindhardt street this morning around 7:30-8:00am
Altoona
Lost: 4/30/2021
ID: 16591
Name: Mason
Type: Dog
Color: Black/tan
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen off Adventureland Drive near Greenway trail/Kum&Go/Kwik Star area. Very treat motivated. Very friendly. Prefers females. Do not chase! My number: 715-207-3777; wife’s number: 715-697-3196
Des Moines - South
Lost: 4/30/2021
ID: 16588
Name: Hawkeye
Type: Dog
Color: Black and Tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Live by Easter Lake, seen on bike trail and seen in our neighborhood north of there
Winterset
Lost: 4/30/2021
ID: 16587
Name: Tank
Type: Dog
Color: Brown
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen by the Winterset airport at 8:30 in the morning. No one has seen them since. There's a walker coonhound with him as well.
Des Moines - East
Lost: 4/30/2021
ID: 16585
Name: Cookie
Type: Cat
Color: White with big black spote
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Some one broke into house and cat was gone hope they didn't hurt her she has a loving little girl who loves her cookie. Please help us
Des Moines - South
Lost: 4/29/2021
ID: 16592
Name: Omen
Type: Cat
Color: Orange brown white
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Young
He is a loving cat he responds to omen fluffy tail
Waterloo
Lost: 4/29/2021
ID: 16580
Name: Hoss
Type: Dog
Color: Red/ tan
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen headed towards Washburn Iowa. He has a limp on his back leg. He’s on meds twice daily. He loves treats and is a registered Emotional Support animal. He is a red nose pit , friendly. Loves treats and car rides.
Waterloo
Lost: 4/29/2021
ID: 16579
Name: Hoss
Type: Dog
Color: Red/tan
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen headed towards Washburn Iowa. He is a little skiddish but loves treats and car rides! He is an registered emotional support animal.
Polk City
Lost: 4/29/2021
ID: 16578
Name: Kyle
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
In my apartment at S 5th and Bridge Ave Polk city
Des Moines - North
Lost: 4/29/2021
ID: 16571
Name: Charlie
Type: Dog
Color: Black
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
East Sheridan by grand view college
Des Moines - South
Lost: 4/28/2021
ID: 16642
Name: Bella
Type: Cat
Color:
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Winterset
Lost: 4/28/2021
ID: 16593
Name: Tank
Type: Dog
Color: Brown
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
By the Winterset Airport on 4/30.
Des Moines - Central
Lost: 4/28/2021
ID: 16581
Name: Athena
Type: Dog
Color: White with reddish brown spots
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
Over by Phillip's elementary school by Hubble and Easton
West Des Moines
Lost: 4/27/2021
ID: 16589
Name: Snowflake
Type: Cat
Color: Orange and white
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen near wistful vista dr and coachlight dr
Altoona
Lost: 4/27/2021
ID: 16560
Name: Leo
Type: Cat
Color: Brown Tiger
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Ran out the back door/deck and to the front. Lost sight of him ever since. He is a shy cat with claws and very nice. Answers to Leo.
Waterloo
Lost: 4/27/2021
ID: 16558
Name: Theo
Type: Cat
Color: Buff/white
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
He is declawed! He is friendly but leery of strangers!
Des Moines - East
Lost: 4/27/2021
ID: 16557
Name: Kairi
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last night. She broke the screen and slipped out of one of our windows.