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
Windsor Heights
Lost: 7/30/2021
ID: 17373
Name: Rosa
Type: Cat
Color: Tortoiseshell
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She has a checkerboard print on her chest and brown on the right side of her upper lip she was last seen on Forest street in Windsor Heights
Windsor Heights
Lost: 7/30/2021
ID: 17372
Name: Ralph
Type: Cat
Color: White and black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
He has a white ring around the tip of his tail and he was last seen on Forest street in Windsor Heights
Des Moines - West
Lost: 7/30/2021
ID: 17371
Name: Finnigan
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
Very timid.. microchipped but owner didn't want and he ended up with me. He snuck out an unlatched door and he's never been out of backyard before. He has a high pitched meow. He doesn't like water on him (rain). Lost near 46th and University in Des Moines.
Des Moines - South
Lost: 7/30/2021
ID: 17365
Name: Sadie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
812 Creston 5153336096
Des Moines - South
Lost: 7/29/2021
ID: 17385
Name: Little Baby
Type: Cat
Color: Tan and brown white tips of paws
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Last seen at our home on the corner of sw 8th and wall ave in des moines OFFERING A REWARD IF FOUND OR BROUGHT BACK HOME Please help our family find our furbaby!!Her name is little baby and about 16 months old! She is super sweet and loving and a HUGE part of our family!! She got out of the screen door (9-29-2021) She goes outside sometimes but has never been gone this long. We are MORE THEN WORRIED about her (especially with the storm, she hates getting her paws wet) We have flyers up, her food and litter box outside, posts on social media ect. She is also bonded with our other cat who just had kittens, and her and her lil ones just dont know what to do without thier best friend! We are asking if you have information on her or where she might be please use the contact info above!! Thank you so much and God bless!!
Earlham
Lost: 7/29/2021
ID: 17379
Name: Ki & Izzy
Type: Dog
Color: Black/Brown
Breed: Doberman Pinscher
Gender: Male
Fixed: Not Neutered
Age: Young
Male and Female Doberman missing from Earlham IA got out of fenced yard. Been gone since 7/29. Very friendly. Very missing. Reward offered.
Earlham
Lost: 7/29/2021
ID: 17369
Name: Izzy female Ki male
Type: Dog
Color: Brown Black
Breed: Doberman Pinscher
Gender: Male
Fixed: Not Neutered
Age: Young
Missing 2 Dobermans under a year old. Female is a big girl. Both a friendly. Reward. Other dog came back wondering if these two were taken? Last seen North of Earlham. Missing them….
Earlham
Lost: 7/29/2021
ID: 17368
Name: Izzy and Ki
Type: Dog
Color: Brown/Black not cropped ears
Breed: Doberman Pinscher
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen North side of Earlham other dog came home. Afraid these were taken. Reward 515-739-0076 There is a male and female both under a year old. Female is a big girl. Both very friendly.
Des Moines - Central
Lost: 7/29/2021
ID: 17363
Name: Sada
Type: Dog
Color: White with brown merle spots on the back and over right eye
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen on 21st and Clark near Drake Neighborhood. She has a very distinct look. She is a very friendly puppy only 8 months. I truly believe someone is trying to keep her. So please stay alert for the days to come.
Des Moines - North
Lost: 7/29/2021
ID: 17362
Name: Rocky
Type: Dog
Color: Grey and black
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen w Maya (female husky)
Des Moines - North
Lost: 7/29/2021
ID: 17361
Name: Maya
Type: Dog
Color: Reddish
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Lost w Rocky (male husky)
Des Moines - Central
Lost: 7/29/2021
ID: 17356
Name: Rocky
Type: Dog
Color: White
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Merle hay
Des Moines - Central
Lost: 7/29/2021
ID: 17354
Name: Rocky
Type: Dog
Color: White
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Back yard
Des Moines - North
Lost: 7/29/2021
ID: 17353
Name:
Type: Cat
Color: Yellow and white
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Very sweet and friendly. I'm taking to vet this afternoon to check for a microchip. Thanks!
Ankeny
Lost: 7/28/2021
ID: 17349
Name: Molly
Type: Dog
Color: White and tan
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Senior
Last seen at 9 pm
Des Moines - East
Lost: 7/28/2021
ID: 17348
Name: Lilly
Type: Dog
Color: Mostly
Breed: Pinscher-Miniature
Gender: Female
Fixed: Not Neutered
Age: Adult
This morning bout 8am she has a flea collar on and loves food
Norwalk
Lost: 7/28/2021
ID: 17347
Name: Tiki
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Crescent Lane Norwalk IA
Norwalk
Lost: 7/28/2021
ID: 17345
Name: Tiki
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Crescent Lane, Norwalk IA
Waterloo
Lost: 7/28/2021
ID: 17342
Name: Katie
Type: Dog
Color: Blonde
Breed: Cairn Terrier
Gender: Unknown
Fixed: Not Applicable
Age: Senior
1230 am at Muncy and Martin in Waterloo
Waterloo
Lost: 7/27/2021
ID: 17364
Name: Kit
Type: Cat
Color: grey and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
he is friendly will come up to you but might run if you go up to him and will come to mouse noises and if you say his name
Des Moines - East
Lost: 7/27/2021
ID: 17339
Name: Princess
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
E12th and mattern very friendly she’s a therapy dog to my daughter and our family dog she’s prissy and well taken care of!
Cedar Falls
Lost: 7/27/2021
ID: 17333
Name:
Type: Cat
Color: Grayish Brown
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Adult
Day and Night for about four days.
Orient
Lost: 7/26/2021
ID: 17396
Name: Molly
Type: Dog
Color: Black brown with white and tan markings
Breed: Shepherd
Gender: Female
Fixed: Unknown
Age: Young
Near Henry A Wallace Rd between orient and greenfield
Des Moines - Central
Lost: 7/26/2021
ID: 17341
Name: Miller
Type: Cat
Color: White and grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 7/26/2021
ID: 17334
Name: Ruby Flower
Type: Dog
Color: Brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Baby
Last seen near dominos on Douglas