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>='1560384000')) ORDER BY pm1.meta_value DESC, post_date DESC
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!
Des Moines - North
Lost: 10/20/2018
ID: 9838
Name: Brutus
Type: Dog
Color:
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
34 street off of Hickman. Des Moines IA
Dubuque
Lost: 10/20/2018
ID: 9825
Name: ??
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
She was spayed very recently. No hair grown back on site.
Indianola
Lost: 10/18/2018
ID: 9931
Name: Marvin
Type: Dog
Color: White/ cream
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 10/18/2018
ID: 9840
Name: Jazlynn
Type: Cat
Color: orange tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen outside our house on the corner of 19th and Woodland, in Sherman Hill, on the morning of October 19th by our neighbor. She currently has a small scratch on her nose that is healed but still visible
Des Moines - South
Lost: 10/18/2018
ID: 9823
Name: Sammie (SammieSam)
Type: Cat
Color: Orange and White
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
6pm He has just been neutered,his stitches are probably still there! He just had his nails trimmed as well. He likes people.
Des Moines - South
Lost: 10/18/2018
ID: 9822
Name: Sammie (SammieSam)
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He has just been neutered,his stitches are probably still there! He just had his nails trimmed as well. He likes people.