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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Clinton
Lost: 6/22/2021
ID: 17019
Name: Jerikoh
Type: Cat
Color: Cream
Breed:
Gender: Male
Fixed: Not Neutered
Age: Baby
The night before.
Waterloo
Lost: 6/22/2021
ID: 17014
Name: nala
Type: Dog
Color: tan
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
by hardee’s , kwwl building
Des Moines - South
Lost: 6/22/2021
ID: 17013
Name: Bandit
Type: Dog
Color: Tan, white, black
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Please call 515-508-0166 if found. He was last seen around 9pm on wade street, near the zoo. He ran from my parents house. They are watching him while we are out of town.
Urbandale
Lost: 6/21/2021
ID: 17062
Name: Harry
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Waterloo
Lost: 6/21/2021
ID: 17048
Name: Uno
Type: Cat
Color: White with stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen monday night. He is front declawed 2 yrs old and sweet. He is shy to people he dont know and will run.
West Des Moines
Lost: 6/21/2021
ID: 17033
Name: Mini
Type: Cat
Color: Grey
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen in West Des Moines near Aspen Drive or Pommel Place. She is very antisocial, has very scraggly whiskers, big fluffy tail, and loves to chase bugs. She might run if approached, she loves to play tag.
Pleasantville
Lost: 6/21/2021
ID: 17029
Name: Pandora
Type: Cat
Color: Grey with stripes
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on Hayes Drive in Pleasantville on June 21st. She is very sweet and food motivated if you shake a bag of treats she will come running to you.
Des Moines - South
Lost: 6/21/2021
ID: 17017
Name: Peeka
Type: Cat
Color:
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Outside my house playing hide and make me chase him. The last time i seen him and I tried getting him to come. He ran again and couldn't find him after that. That was at 2 am Monday night Tuesday Morning
Spirit Lake
Lost: 6/21/2021
ID: 17015
Name: Chester
Type: Cat
Color: Black/brown/white
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Monday 21, 2021. Chester is front declawed and has two white spots on his back. He is an INDOOR CAT ONLY. Weighs 15 lbs.
Johnston
Lost: 6/21/2021
ID: 17009
Name: Ghosty
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
Escaped from yard off of Ne 97th st, Johnston Microchipped Black collar mistakenly embroidered phone number in black, but still readable
Des Moines - Central
Lost: 6/21/2021
ID: 17008
Name: Gemini
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on drake park and 22nd ran out of the door
Altoona
Lost: 6/21/2021
ID: 17007
Name: Itachi
Type: Cat
Color: Blavk
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at home. Roommate let him out in accident. Super friendly.
Ankeny
Lost: 6/21/2021
ID: 17003
Name: Pearl
Type: Bird
Color: Grey wings with white spots, yellow crest, grey/yellow breast, orange cheeks
Breed: Cockatiel
Gender: Female
Fixed: Unknown
Age: Young
She flew from Siena Hills in Ankeny. The wind was blowing hard towards the South/SouthEast, she tried to come down but got swept away by the wind.
Urbandale
Lost: 6/20/2021
ID: 16999
Name: Buddy
Type: Dog
Color: Light brown
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Adult
Near 86th and Meredith
Altoona
Lost: 6/19/2021
ID: 17564
Name: Bun Bun
Type: Rabbit
Color: Gray Dutch
Breed: Dutch
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen SE 15th ST
Bloomfield
Lost: 6/19/2021
ID: 17000
Name: Roxy
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
Pine street in Bloomfield
Des Moines - North
Lost: 6/19/2021
ID: 16993
Name: Ted
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Last seen near Madison elementary at 5-6pm Will come when called by name. Very friendly.
Des Moines - North
Lost: 6/19/2021
ID: 16992
Name: Ted
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Young
Last seen near Madison elementary at 5-6pm Will come when called by name. Very friendly.
Des Moines - East
Lost: 6/19/2021
ID: 16986
Name: Tank
Type: Dog
Color: Black
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Senior
Area of East 25th and Douglas 10:30 am. Elderly and very hard of hearing. Is friendly and will go with people. Microchip is outdated!
Des Moines - West
Lost: 6/18/2021
ID: 17242
Name: Kaiser
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Adult
Got loose at owners place of business in Clive. Near 86th and University. He's very friendly. Loves Kids and other dogs. Will jump to say hello and has lots of energy. Our little girl misses her buddy. Please help us bring him home. Also can call Zach 515-710-7141. We live in Des Moines but he was lost in Clive/Windsor Heights.
Des Moines - South
Lost: 6/18/2021
ID: 17038
Name: Blaze
Type: Cat
Color: mix
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Waterloo
Lost: 6/18/2021
ID: 17010
Name: Leonard
Type: Cat
Color: White with dark grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Will hide when approached outside.
Des Moines - East
Lost: 6/18/2021
ID: 16998
Name: Idris
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
This is my daughter kitten his name is idris he is a outside cat we haven’t seen him for 3 days normally he comes back but he’s made cat friends outside in our neighborhood we just want him back safely
Des Moines - East
Lost: 6/18/2021
ID: 16997
Name: Idris
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Outside sitting at our porch
Johnston
Lost: 6/18/2021
ID: 16991
Name: JoJo
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Last Seen in North Johnston west of camp dodge. He tends to hang out in and under home landscaping. He is very friendly.