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
Altoona
Lost: 6/16/2021
ID: 16978
Name: Milly
Type: Cat
Color: Grey/white tiger stripes
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Baby
Lost from Ironwood Dr./1st Ave-Barclay apartments
Grimes
Lost: 6/16/2021
ID: 16976
Name: Sage
Type: Cat
Color: dark striped tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen Wednesday morning 6/16, apartment complex just north of Cutty's. Glenstone Drive - Grimes/Johnston
Des Moines - South
Lost: 6/16/2021
ID: 16964
Name: Maze
Type: Dog
Color: Brown tan
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Baby
Seen at 330 am
Cedar Falls
Lost: 6/15/2021
ID: 16966
Name: Cash
Type: Cat
Color: black, with white "bowtie"
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Cash is a medium hair shiny black coat, all black except a white bow tie and white whispy hairs in his ears. He is neutered and has all of his claws. He is friendly but nervous around loud noises.
West Des Moines
Lost: 6/14/2021
ID: 16972
Name: Eve
Type: Cat
Color: Black, Reddish Tan - With Lion Cut
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
End of Green Branch Circle, WDM. Eve is cat on right in photo. With Lion Cut.
Des Moines - East
Lost: 6/14/2021
ID: 16949
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Baby
Poe, and very friendly, doesn’t know the neighborhood, if he’s scared he will meow but not hurt you.
Epworth
Lost: 6/14/2021
ID: 16947
Name: Scout
Type: Cat
Color: Tiger
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Tore hole in screen & jumped out. Her collar was found right outside of our place. She’s very shy, but if you see her please message me at (563) 495-4788. Thank you.
Milo
Lost: 6/13/2021
ID: 17006
Name: Fannie Mae
Type: Cat
Color: Has stripes in charcoal and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
She slipped out the back door and usually stays around home, but is extremely friendly. That's the way I raised her. I litterally pulled her from her mother as she was born from a rescued female in the cold winter months. I would like her returned to me as she is like family to me and the other cats that love her. Thanks for looking at my post and may please...any information you may have would be much appreciated!
Des Moines - South
Lost: 6/13/2021
ID: 16961
Name: Frankie
Type: Cat
Color: Dark and light gray striped
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Sunday night. Very shy and skittish. His right ear is crinkled.
Ankeny
Lost: 6/13/2021
ID: 16953
Name: Whisky
Type: Cat
Color: Mixed colors, black stipes
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Last seen at our backyard on Reunion Circle in the White Birch Neighborhood. We've had him since he was baby and has always been an indoor cat.
Des Moines - North
Lost: 6/13/2021
ID: 16951
Name: Cesar or CC
Type: Cat
Color: Dark Tabby striped.
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Was taken from home without permission to an unknown location and abandoned l
Des Moines - East
Lost: 6/13/2021
ID: 16950
Name: Maxximo
Type: Cat
Color: Black with white underside and paws
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Max got out in the evening and when i went to call/look for hin he was no where to be found. Around east high school.
Urbandale
Lost: 6/13/2021
ID: 16941
Name:
Type: Cat
Color: Orange Tabby
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
His eyes are a little purple almosr iridescent looking. Very friendly. Found just north of Waterford road and 151st in Urbandale.
Clive
Lost: 6/12/2021
ID: 17110
Name: Poe
Type: Cat
Color: Black and white belly
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen by the fire station in Clive. He also has a health condition and needs a special diet.
Waterloo
Lost: 6/12/2021
ID: 16980
Name: Me. Whiskers
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
He has green eyes and declawed front paws. He is not an outside cat so is probably scared.
Altoona
Lost: 6/12/2021
ID: 16940
Name: Annie
Type: Dog
Color: Brown/white
Breed: English Springer Spaniel
Gender: Unknown
Fixed: Not Applicable
Age: Adult
She’s scared and will run. Last spotted near summit products in Altoona
Altoona
Lost: 6/12/2021
ID: 16939
Name: Annie
Type: Dog
Color: Brown/white
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Applicable
Age: Adult
Spotted in Altoona around summit products. Very scared and will run
Des Moines - South
Lost: 6/12/2021
ID: 16936
Name: Karma
Type: Dog
Color: Blonde
Breed: Shepherd
Gender: Unknown
Fixed: Unknown
Age: Young
On Emma..please help find Karma. If you see her please call 5156032090
Urbandale
Lost: 6/12/2021
ID: 16935
Name: Unknown
Type: Dog
Color: Tan
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
9600 block of Horton and then one hour later in the backyard of Greenview Drive around 9:00 pm in Urbandale. The dog was scared and wouldn’t let anyone by them.
Des Moines - East
Lost: 6/12/2021
ID: 16929
Name: Bambi
Type: Cat
Color: Grey, white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Running into neighbors yard, searched but think she ran off
Des Moines - North
Lost: 6/11/2021
ID: 16927
Name: Kane/kylo
Type: Dog
Color: White and grey
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
3842 57th st
Blairstown
Lost: 6/10/2021
ID: 16942
Name: Zoe
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Senior
Normally indoor cat, very timid.
Adair
Lost: 6/10/2021
ID: 16926
Name: Lucky
Type: Dog
Color: White and brown
Breed: Brittany Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
My brother's male Brittany spaniel unknowingly escaped at a truck stop in Adair, Iowa. We know he was picked up by a lady, but no information was left with the truck stop. He has a collar with Colorado rabies tag on it. His name tag and phone number was lost. If you have seen the tri-colored dog pictured, please message me. His name is Lucky and I'm hoping his name holds true. Praying he is safe. His family and his girl miss him terribly.
Des Moines - East
Lost: 6/10/2021
ID: 16924
Name: Gizmo
Type: Small or Furry
Color: Brown and white
Breed: Ferret
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 6/10/2021
ID: 16923
Name: Gizmo
Type: Small or Furry
Color: Brown, white
Breed: Ferret
Gender: Male
Fixed: Neutered
Age: Young