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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 10/29/2018
ID: 9939
Name: Maui
Type: Cat
Color: Bengal
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen on 13th and Madison she is a senior cat who has cancer THERE IS A REWARD
Des Moines - Central
Lost: 10/29/2018
ID: 9896
Name: Maui
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Senior
Was last seen by Madison Ave on 13th street.. let her out to go potty and she never came back
Waukee
Lost: 10/29/2018
ID: 9891
Name: Walter “Nuggy”
Type: Cat
Color: Black w/white patch on chest
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Senior
Not an outdoor cat. Declawed. Top part of left ear froze off when he was a kitten. Has bald spots on belly and hind legs. Goes by the nickname Nuggy.
Des Moines - North
Lost: 10/29/2018
ID: 9887
Name: Maui
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
She was seen on the north side of desmoines on Madison street
Ankeny
Lost: 10/28/2018
ID: 9946
Name: Tiger Cat
Type: Cat
Color: Dark Brown/Black striped with white feet.
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is front declawed. He only has a few back claws remaining, from a previous accident. He is 3 years old.
Des Moines - South
Lost: 10/28/2018
ID: 9893
Name: Mellow
Type: Dog
Color: Brown/Black (brindle) & White
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
Mellow was wearing a hot pink collar and was last seen October 28th around 1pm on Army Post Road & SE 3rd Streets.
Collins
Lost: 10/28/2018
ID: 9882
Name: Rupert
Type: Dog
Color: Black with white with small amount of brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Collins Iowa near Hwy 65 and 330th St. Rupert can be skittish and shy but is very friendly and loving. He knows his name. If you see or find Rup please call or text me at 515-661-3974.
Des Moines - North
Lost: 10/27/2018
ID: 9934
Name: Blue
Type: Cat
Color: Grey
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
We rescued him this summer at Union Park from a car of homeless people. He has a deformed nose but is overall healthy He would explore our yard but this time never returned. He is my 4 year olds baby so please help us get him back. May be infested with fleas. He received a treatment that day. He is very quiet and loving.
Urbandale
Lost: 10/27/2018
ID: 9911
Name: susan
Type: Cat
Color: Grey tiger
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Has white belly with hernia Declawed
Urbandale
Lost: 10/27/2018
ID: 9910
Name: susan
Type: Cat
Color: Grey tiger
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Has white under belly and a hernia Declawed
Des Moines - West
Lost: 10/27/2018
ID: 9868
Name: Hazel
Type: Dog
Color: Black/brown/white
Breed: Chiweenie
Gender: Female
Fixed: Neutered
Age: Adult
Merle Hay. Very friendly but barks if being approached timidly.
Grimes
Lost: 10/26/2018
ID: 9875
Name: Athena
Type: Dog
Color: Black
Breed: Poodle Standard
Gender: Unknown
Fixed: Neutered
Age: Young
Ran away from Dogwood boarding
Cumming
Lost: 10/26/2018
ID: 9865
Name: JEHR / Jehr-Bo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Will answer to Jehr or Jehr-Bo. About 10 yrs old and super sweet. Last seen west of i35, west of Woodland Ave around 6 pm on 10/26/2018
Cumming
Lost: 10/26/2018
ID: 9864
Name: JEHR / Jehr-Bo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Will answer to Jehr or Jehr-Bo. About 10 yrs old and super sweet. Last seen west of i35, west of Woodland Ave around 6 pm on 10/26/2018
Des Moines - Central
Lost: 10/25/2018
ID: 9877
Name: Coco
Type: Dog
Color: White with brown spots
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Last seen was in Des Moines central area
Des Moines - Central
Lost: 10/25/2018
ID: 9876
Name: Coco
Type: Dog
Color: White with brown spots
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Last seen was in Des Moines central area
Des Moines - East
Lost: 10/24/2018
ID: 9940
Name:
Type: Cat
Color: White, Black, Gray and Tan. With Marking on Nose.
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
E. 29th & Dean Ave. He is an Indoor cat and is Most likely Scared of being Outside. LARGE REWARD IF FOUND!!!!!
Maquoketa
Lost: 10/23/2018
ID: 9854
Name: Spook
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Maquoketa Vet Clinic
Redfield
Lost: 10/23/2018
ID: 9853
Name: Sylvester
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
We just adopted this cat from the ARL on the 13th. He ran out my back door and disappeared behind the Christian Church.
Fort Madison
Lost: 10/22/2018
ID: 9861
Name: Max
Type: Cat
Color: Light cream with gray tabby markings
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Max is a Lynx Point Siamese. He was last seen on our back porch. He has a high prey drive and loves to hunt. He comes back multiple times a day for food, sleep, and affection. He is extremely friendly and confident. The longest he's ever been gone is 24 hours.
West Des Moines
Lost: 10/22/2018
ID: 9837
Name: Boomer
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Young
Last seen in WDM of ashworth/60th. Responds well to wet food and bagged treats fairly cautious of new people; hates pet carriers; declawed in front- not in back.
Windsor Heights
Lost: 10/21/2018
ID: 9833
Name: Mia
Type: Cat
Color: Brown stripes
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen 66th and Elm Crest in Windsor Heights, IA.
Windsor Heights
Lost: 10/21/2018
ID: 9832
Name: Mia
Type: Cat
Color: Brown stripes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near 66th and Elm Crest, Windsor Heights.
Des Moines - South
Lost: 10/21/2018
ID: 9831
Name: Precious
Type: Cat
Color: Black/grey/brown
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
She's never been outside before - she was chasing a bird and got out. She isn't a cuddly cat but loves treats.
Des Moines - South
Lost: 10/20/2018
ID: 10100
Name: Precious
Type: Cat
Color: Tabby with a hint of calico
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen on Johnson and 11th. This is a repost, she's still missing and we miss her!