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/18/2021
ID: 16725
Name: Britta
Type: Dog
Color: Teal with camo
Breed: Blue Heeler
Gender: Female
Fixed: Not Neutered
Age: Adult
On Colfax and shawnee. She’s very timid but friendly.
Cresco
Lost: 5/17/2021
ID: 17295
Name: Lovey
Type: Cat
Color: Tabby with white
Breed: Blue Heeler
Gender: Unknown
Fixed: Not Neutered
Age: Young
Not wearing a collar. Her nose has a little bit of white around it. White paws and belly.
Tiffin
Lost: 5/17/2021
ID: 16766
Name: Skyler
Type: Cat
Color: White, Gray
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Adult
He is from Tiffin, IA. He went out on Monday night for patrol and started to rain, and it has been raining for a few days. He never returned. We went out to look for him by calling name, tapping his favorite can food, no response. Went out to give out information to our neighbors. We have trees and open field in our backyard but close to neighborhood.
Des Moines - South
Lost: 5/17/2021
ID: 16721
Name: Blu
Type: Dog
Color: Grey
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 5/17/2021
ID: 16720
Name: Blu
Type: Dog
Color: Grey
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
5 miles south of Des Moines in between Indianola
Monroe
Lost: 5/16/2021
ID: 16959
Name: Angel
Type: Dog
Color: White
Breed: Poodle Toy
Gender: Unknown
Fixed: Neutered
Age: Senior
Angel was last seen out in the country with my parents and once they went inside she never came back. They have checked every ditch and road and have asked all neighbors and made post but still have not found her alive or dead. If anyone knows who could have her or if they have seen her please please please let me know, I love that dog with all of my heart and it’s really hurt our family to see her gone just as she was starting to get used to our new home..
Cascade
Lost: 5/16/2021
ID: 16809
Name: Olaf
Type: Dog
Color: White with cream ears
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Young
Berwick
Lost: 5/16/2021
ID: 16716
Name: FIRE STONE
Type: Cat
Color: Black and white
Breed: Great Pyrenees
Gender: Male
Fixed: Neutered
Age: Young
On Jeff St In Berwick Iowa. He really don't care to much for people. He crys if he don't know you when being picked up. He love kitty threats.
Polk City
Lost: 5/16/2021
ID: 16714
Name: Lana
Type: Dog
Color: Red and white
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Young
Polk city off of E Madison dr.
Des Moines - South
Lost: 5/16/2021
ID: 16711
Name: Karma
Type: Dog
Color: Blonde
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Baby
1851 Evergreen Ave
Waterloo
Lost: 5/15/2021
ID: 16745
Name: Titan
Type: Cat
Color: Brown and black
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 5/15/2021
ID: 16717
Name: Sasha
Type: Dog
Color: Brown
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
15th street and alpha Avenue
Urbandale
Lost: 5/15/2021
ID: 16715
Name: Zulu
Type: Cat
Color:
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 5/15/2021
ID: 16709
Name: Thelma
Type: Dog
Color: Black with brown
Breed: Rat Terrier
Gender: Unknown
Fixed: Not Applicable
Age: Young
Last seen by Easter Lake, East Titus and Easter Lake Drive
Des Moines - Central
Lost: 5/15/2021
ID: 16707
Name: Norma
Type: Dog
Color: Brown
Breed: Boston Terrier
Gender: Female
Fixed: Not Applicable
Age: Young
She’s very friendly, will come for treats. She escaped out of a missing piece of board in our fence.
West Des Moines
Lost: 5/15/2021
ID: 16706
Name: Archie
Type: Cat
Color: Orange
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 5/14/2021
ID: 16700
Name: Bobbin
Type: Dog
Color: Dark Brown & Light Brown
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Darts away quickly, so if you see but can't catch, please call (515)473-2693
Altoona
Lost: 5/14/2021
ID: 16699
Name: Holly
Type: Cat
Color: Grey
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around Adventureland Estates area in Altoona
Des Moines - North
Lost: 5/14/2021
ID: 16698
Name: Zeus
Type: Dog
Color: Black and white
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Adult
East 29th St.
Decorah
Lost: 5/13/2021
ID: 16730
Name: Elwood
Type: Dog
Color: Black and white
Breed: Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Missing off of 185th st Decorah off of centennial rd
Decorah
Lost: 5/13/2021
ID: 16729
Name: Elwood
Type: Dog
Color: Black and white
Breed: Spaniel
Gender: Male
Fixed: Unknown
Age: Adult
Missing from 185th st off of centennial rd.
Decorah
Lost: 5/13/2021
ID: 16728
Name: Elwood
Type: Dog
Color: Black and white
Breed: Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on 185th st off of centennial road.
Colfax
Lost: 5/13/2021
ID: 16722
Name: Francie
Type: Cat
Color: white & black/grey
Breed: Tuxedo
Gender: Female
Fixed: Not Neutered
Age: Baby
She knows her name, she’s only a month and half old, she was last seen in our barn (she is an outdoor cat)
Des Moines - South
Lost: 5/13/2021
ID: 16701
Name: Onyx
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Black cat with green eyes.
Altoona
Lost: 5/12/2021
ID: 16694
Name: Wyatt
Type: Dog
Color: Black/gray
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on southeast side of Altoona near Haines park