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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Ankeny
Lost: 10/15/2018
ID: 9799
Name: Zoey
Type: Dog
Color: Gray
Breed: Schnauzer Miniature
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in our yard, shortly after noon
Des Moines - West
Lost: 10/14/2018
ID: 9794
Name: Business
Type: Cat
Color: Gray with white on chest and feet
Breed: Schnauzer Miniature
Gender: Female
Fixed: Unknown
Age: Adult
Lost on 10/02/2018. Her collar might be off since it is a breakaway.
Sioux City
Lost: 10/13/2018
ID: 9848
Name: Sadie
Type: Dog
Color: Reddish Brown with Some Black
Breed: Tibetan Spaniel
Gender: Female
Fixed: Unknown
Age: Adult
Missing since Saturday 10/13/18 Sadie is a Tibetan Spaniel. She looks similar to a Pekinese. Small – about 12 pounds. $100 reward for safe return Last seen Sioux City and North Sioux City Area. She went missing at 1250 W. Flurie Rd, Dakota Dunes, SD 57049 Please call Sandy at 712-490-3030 Sadie is lost and very scared. Please help us find her.
Des Moines - South
Lost: 10/13/2018
ID: 9793
Name: Red
Type: Dog
Color: Brown/red
Breed: Red Heeler
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on SW 16th street My 2 year old daughters misses her puppy!
Des Moines - Central
Lost: 10/12/2018
ID: 9798
Name: Maui
Type: Cat
Color: White with big black spots, black tail, black on head
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
A home body,a big scardy cat, always hung out in back yard. A really good boy.
Des Moines - East
Lost: 10/12/2018
ID: 9791
Name: Gizmo
Type: Dog
Color: White/ brownish Tan spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Young
I let him out potty on E University Ave towards Altoona and he hasn't returned. He should be wearing his blue sweater.