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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Pleasant Hill
Lost: 10/18/2018
ID: 9815
Name: Taz
Type: Dog
Color: White
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Approximately went missing around 4 pm. Broke through the electric fence, very friendly and will even jump in your car.
Mitchellville
Lost: 10/17/2018
ID: 9812
Name: Scarlett
Type: Dog
Color: Black/tan
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Baby
Mitchellville area
Des Moines - East
Lost: 10/16/2018
ID: 9827
Name: Twizzler
Type: Cat
Color: black, brown, gold
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
indoor outdoor cat, 5 months old,
Des Moines - Central
Lost: 10/16/2018
ID: 9811
Name: Emilio Rodriquez
Type: Cat
Color: White with dark gray Siamese markings
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
By six Avenue and Franklin in Des Moines
Cumming
Lost: 10/15/2018
ID: 9829
Name: Harvey
Type: Cat
Color: Tan
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 10/15/2018
ID: 9816
Name: Oliver
Type: Cat
Color: orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Live over by the fairgrounds . He is a very mellow cat and very loving .
Des Moines - Central
Lost: 10/15/2018
ID: 9802
Name: Missy B
Type: Cat
Color: Black with white paws and underside
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
last seen in the drake neighborhood, Missy B is older and may be confused. She has been a housecat for 14 years and is not used to being outdoors.