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>='1555113600')) ORDER BY pm1.meta_value DESC, post_date DESC
Huxley
Lost: 7/2/2018
ID: 9019
Name: Nigel
Type: Cat
Color: Grey and Brown
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
3 year old, male, grey and brown cat, about 14-15 pounds. Last seen Monday July 2nd in Huxley, Iowa. Very friendly and loves people.
Cedar Rapids
Lost: 7/2/2018
ID: 9018
Name: Taco Paco
Type: Dog
Color: Tanish cream
Breed: American Eskimo Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
It was around Wendy’s near the H ave exit .
Des Moines - South
Lost: 7/2/2018
ID: 9016
Name: Tom
Type: Cat
Color: Grey and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at bedtime Sun. By 2000 meadow ct. Near the meadows apts. 50320
Des Moines - Central
Lost: 7/2/2018
ID: 9015
Name: ROO
Type: Dog
Color: Black/white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
ROO ran out when the kids left for summer camp at 7:30am
Des Moines - East
Lost: 7/2/2018
ID: 9014
Name: Zeus
Type: Dog
Color: Light brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on the east side of Des Moines by dairy zone
Des Moines - Central
Lost: 7/2/2018
ID: 9013
Name: George
Type: Cat
Color: Gray
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young
George or Georgie, super friendly and talkative. Approx 16-17 pounds No collar, not declawed, not neutered. Small bald patch on his back.
Des Moines - North
Lost: 7/1/2018
ID: 10415
Name: Little girl aka little
Type: Dog
Color: Light brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
She will come to her name little and she loves treats. She is missed here and we would love to have her back in are home. Please keep an eye out for her or if you have her text me at 515-994-8521.
New London
Lost: 7/1/2018
ID: 9115
Name: Ozzy
Type: Dog
Color: Solid Black with white spots on back toes
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in New London area with sitter
Des Moines - North
Lost: 7/1/2018
ID: 9008
Name: Magi
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
Magi was last seen between NE 52nd St and NE 54th St in Saylor township in the meadows and wooded area. She is very scared of cars and fireworks. Very friendly dog about 20 lbs, black with a red collar and no tag. She's friendly. Last seen by my kids and husband, but ran. She's never been out of our privacy fence except for going in the car. She escaped after flood damage to our house and fence. Please contact me by phone or text me. 515-494-6982. We are worried sick.
Des Moines - South
Lost: 7/1/2018
ID: 9005
Name: Wally
Type: Dog
Color: Black
Breed: Poodle Toy
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Sunday morning, got out of the yard. Lost near se 20th st and park ave in Des Moines.
Dexter
Lost: 7/1/2018
ID: 9002
Name: Koda
Type: Dog
Color: Chocolate lab
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen playing in the yard with two other dogs. Very friendly 5 month old lab.
Perry
Lost: 7/1/2018
ID: 8998
Name: Bob
Type: Dog
Color: White with light brown on back an near ears
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
In back yard on chain at 2301 1st Avenue Pery. Call 515-556-6395 if found
Des Moines - East
Lost: 7/1/2018
ID: 8995
Name: Olive
Type: Dog
Color: Black, White, tan
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen 4am, ran off when using bathroom. Olive is very timid and super quick. She’s super nice just very unsure of people still. She’s a mini Aussie
Stuart
Lost: 6/30/2018
ID: 9195
Name: Max
Type: Dog
Color: Black tri color
Breed: Collie
Gender: Male
Fixed: Neutered
Age: Baby
Max never leaves the property. If spotted or found, please call. His family misses him
Jefferson
Lost: 6/30/2018
ID: 9092
Name: Storm
Type: Dog
Color: Dilute Chocolate (silver)
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Storm spent the night at my brother-in-law's farm in Jefferson on Jun 29th and was gone the next morning. She has stayed there many times, even stayed many times and never ever ran off. Storm was bread twice and has a scare on her belly from a cesarean emergency last year and an odd piece of hair that looks like an eye lash above her left eye, sticks up funny. She is not spade but never went back into heat after the cesarean. Storm is very spoiled. She is an inside dog and will cry if left outside. She weighs approx. 100 lbs, knows several commands, is house trained, and loves to eat. She does not hunt, gun shy, and is not the best at fetching. She was actively being treated for on ear infection.
Nevada
Lost: 6/30/2018
ID: 9012
Name: Moly
Type: Dog
Color: black with a white face
Breed: Great Dane
Gender: Female
Fixed: Neutered
Age: Senior
Molly was last seen near the golf course in Nevada. She bolted during a thunderstorm. She is a sweet girl and will most likely come to you if you call her. She is 108 lbs. Please call Nancy or Dan Newman 515-450-8519.
Nevada
Lost: 6/30/2018
ID: 9011
Name: Molly
Type: Dog
Color: Black with grey face
Breed: Great Dane
Gender: Female
Fixed: Neutered
Age: Senior
Pella
Lost: 6/30/2018
ID: 9004
Name: Crystal
Type: Dog
Color: Black with white collar and tan markings 1 blue eye
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Adult
South of Pella Iowa, just off the highway, may still be with another female very similar in height and same color. Mini Aussie. Do not chase, please contact me via email, will update phone number tomorrow. Picture at 8 weeks. Now 1 year old. Crystal is microchipped. I have the number.
Pella
Lost: 6/30/2018
ID: 9003
Name: Crystal
Type: Dog
Color: Black with white collar and tan markings 1 blue eye
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Young
South of Pella Iowa, just off the highway, may still be with another female very similar in height and same color. Mini Aussie. Do not chase, please contact me via email, will update phone number tomorrow. Picture at 8 weeks. Crystal is microchipped. I have the number.
West Des Moines
Lost: 6/30/2018
ID: 8990
Name: Braxton
Type: Cat
Color: Gray
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in boulder ridge apartment West Des Moines. He’s a big but a very shy cat and harmless
West Des Moines
Lost: 6/30/2018
ID: 8989
Name: Braxton
Type: Cat
Color: Gray
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in boulder ridge apartment West Des Moines. He’s a big but a very shy cat and harmless
Des Moines - Central
Lost: 6/29/2018
ID: 9036
Name:
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
Nice friendly. But he will protecte you if some one is being loud or aggressive to you. He has a indent in his head and back legs are stiff he was hurt befor we got him.
Altoona
Lost: 6/27/2018
ID: 8982
Name: Garfield
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Garfield is a quick purr, he likes attention will probably come to anyone
Ankeny
Lost: 6/27/2018
ID: 8972
Name: Buddha
Type: Cat
Color: Brown and black
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
We live around Prairie Ridge middle school. He’s and indoor cat and hates the outside. He also has the tip of one ear missing.
Ankeny
Lost: 6/27/2018
ID: 8971
Name: Sophie
Type: Cat
Color: grey/brown
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young