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
Grimes
Lost: 11/13/2018
ID: 9997
Name: Gilbert
Type: Dog
Color: Golden brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Grimes area
Des Moines - Central
Lost: 11/13/2018
ID: 9992
Name: Bella
Type: Dog
Color: Blonde
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Young
Very friendly. Does not bite. Will be with our other dog, Harvey, who also got out. He is a black lab with white paws. He does have a collar. Last seen in Beaverdale on Valdez Drive, near woodlawn Park.
Des Moines - Central
Lost: 11/13/2018
ID: 9991
Name: Harvey
Type: Dog
Color: Black, tiny bit of white on paws and chest
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, knows his name. Will be with our other dog, Bella, who also got out. She is a golden retriever/Malamute mix. Blonde with a curly tail. He was last seen in Beaverdale on Valdez Drive, near Woodlawn Park.
Des Moines - Central
Lost: 11/12/2018
ID: 10001
Name: Milo
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Monday midday early evening. He is an indoor/outdoor cat. So he loves being inside and outside. He doesn't have his collar cause he keeps chewing it off.. Not microchipped. Not declawed because he does go outside and he isnt neuter. Please help bring him home. My six year old is devastated..
Des Moines - South
Lost: 11/12/2018
ID: 9995
Name: Pepper
Type: Cat
Color: Black and gray
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 11/12/2018
ID: 9994
Name: Pepper
Type: Cat
Color: Black and gray
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - South
Lost: 11/12/2018
ID: 9993
Name:
Type: Cat
Color: Black and gray
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - South
Lost: 11/11/2018
ID: 10045
Name: Katniss (Catniss)
Type: Cat
Color: Dawn and white. Orange
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Got out on SE 18th CT north of Park. ( king)
Springbrook
Lost: 11/11/2018
ID: 9990
Name: Josey
Type: Dog
Color: charcoal/black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Adult
Missing between 9:30am-2pm. She takes medication and always returns home after chasing rabbits and squirrels. Suspect she was picked up near our home on the E17 highway. She needs to be returned home so she can have her medicine.
Le Mars
Lost: 11/11/2018
ID: 9988
Name: (4) Seven (female)- Trouble (male) Crook (male) Cracker (male)
Type: Dog
Color: 2 blond, 1 brown, 1 black/brown
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
4th Ave NW please, please call me at 515-835-7139 my name is Kimberley
Ankeny
Lost: 11/11/2018
ID: 9985
Name: Charlie
Type: Dog
Color:
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Hospers
Lost: 11/10/2018
ID: 9999
Name: Zara
Type: Dog
Color:
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Clive
Lost: 11/10/2018
ID: 9987
Name: slash
Type: Cat
Color: orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
4402 nw 165th st Clive, Ia 515-205-0816
West Des Moines
Lost: 11/10/2018
ID: 9976
Name: Luna
Type: Dog
Color: Blonde
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Adult
50th street
Colesburg
Lost: 11/9/2018
ID: 9984
Name: Milo
Type: Dog
Color: Brown
Breed: Dachshund
Gender: Male
Fixed: Unknown
Age: Adult
Last Seen at Shell Ultra City Colesberg around 08H30
Ankeny
Lost: 11/9/2018
ID: 9979
Name: Luke
Type: Cat
Color: Dark Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Luke is an extremely sweet and friendly cat. He will let you pick him up and snuggle him and pet him. When we adopted him from the ARL he had no front claws but did have his back claws. He also gets along with friendly dogs since his best bud at home is a dog.
Des Moines - West
Lost: 11/8/2018
ID: 9971
Name: Honey
Type: Dog
Color: Sable/Black/White
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Neutered
Age: Adult
10:30p.m. let her out for last potty before bedtime and she never returned....totally out of character. She may bark at first, but then morphs into friendly tail wagging. Loves treats.
Des Moines - Central
Lost: 11/8/2018
ID: 9969
Name: Honey
Type: Dog
Color: Sheltie
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Unknown
Age: Adult
Cedar Rapids
Lost: 11/8/2018
ID: 9965
Name: Mozzie
Type: Dog
Color:
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
1068 27th Street NE, Cedar Rapids, Iowa
Des Moines - East
Lost: 11/7/2018
ID: 10005
Name: PC
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen outside by sidewalk. He's an indoor and outdoor cat. He looks just like that cat pictured above and is a male not a female. The picture above thought was my cat turns out that cat is a female :(
Ankeny
Lost: 11/7/2018
ID: 9957
Name: Rajah
Type: Cat
Color: Black/brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Super friendly
Des Moines - East
Lost: 11/7/2018
ID: 9953
Name: Rex
Type: Dog
Color: Light beige
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen near Sheridan park
Des Moines - East
Lost: 11/6/2018
ID: 9947
Name: Bandit
Type: Dog
Color: White with black spots
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Bandit got out of the fence in our backyard when I let him and his brother out to go to the bathroom. We back up to a bunch of corn fields along Douglas/Hubbell Ave.
Ames
Lost: 11/5/2018
ID: 9941
Name: Mercy
Type: Dog
Color: Back is black and chest and part face is white.
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
Last seen at near 245 North Hyland. She is very scared and does not have a collar on. Please notify us if you have seen her or know where she is. Thank you.
Graf
Lost: 11/4/2018
ID: 9933
Name: Ebenezer the Sneezer… Ebby
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
When the creeks were flooding from all the rains.. Has golden eyes and long fangs-but has a hairlip, so his front teeth are usually all broken looking.