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
Lacona
Lost: 7/10/2015
ID: 1000
Name: Skamp
Type: Dog
Color: Black whita an a few brown
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Adult
He is our Baby Skamp an we are Very Sad an Want him back Terribly. Reward 50.00 If You Have Him. Please call Sandy 515-238-9436 or Jack 515-689-7203. Please Call !!!
Baxter
Lost: 7/9/2015
ID: 1092
Name: Punkin’
Type: Cat
Color: Orange Tiger Striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen around July 19th/20th near Bucklin Auto Glass sign off Highway S52 outside of Baxter/Colfax area.....
Baxter
Lost: 7/9/2015
ID: 1029
Name: Punkin’
Type: Cat
Color: Orange Tiger Striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 5 days ago heading west south of Baxter, west of newton, and east of colfax/mingo
Des Moines - North
Lost: 7/9/2015
ID: 971
Name: Baby
Type: Dog
Color: Brindle
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen at E.7th and Douglas (Hiland Park Area) we have had her for 8 yrs and she's part of the family. We miss her so much!! If u see her or know where she is please call us at 515-210-8657 or 515-210-0506. Thank you.
Des Moines - North
Lost: 7/9/2015
ID: 965
Name: Kloie
Type: Dog
Color: Grey with white spot on her chest
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen on NE 10th St. She's a very friendly dog. Easliy startled. Shes a very fast dog and will run if approached. She's good with other dogs and children. We really love her and want her home we miss her.
Ankeny
Lost: 7/7/2015
ID: 945
Name: Foxy
Type: Dog
Color: Black
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Baby
Very playful not mean, not sure how they got out we have been everywhere. Please help find my babies.
Ankeny
Lost: 7/7/2015
ID: 944
Name: Paws
Type: Dog
Color: Blonde
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Young
Not sure how they got out, but we have looked all around us. Look mean BUT THEY ARE NOT! Very playful and love able
Muscatine
Lost: 7/4/2015
ID: 1030
Name: Rosie
Type: Cat
Color: White and black
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on mulberry avenue in Muscatine. Rosie is very friendly
Des Moines - East
Lost: 7/4/2015
ID: 950
Name: Maximums (Max)
Type: Dog
Color: grey
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by Walgreen and then the subway by the old dahls. He broke his collar off. if you so much as just see him please call or text me! He might be hungry oe thirsty.
Des Moines - East
Lost: 7/4/2015
ID: 938
Name: Buster
Type: Dog
Color: Black, White, Tan
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Trotting North on 3316 E. 52nd Street, Des Moines, 50317
Johnston
Lost: 7/4/2015
ID: 936
Name: Dipper
Type: Cat
Color: black with white paws/belly
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 11 p.m. on July 4. He is friendly and he's used to being outside. He might have been scared by fireworks.
Redfield
Lost: 7/4/2015
ID: 931
Name: Duke
Type: Dog
Color: white/yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 6 miles west of Redfield, someone said spotted near Dexter but not positive.
Des Moines - East
Lost: 7/4/2015
ID: 926
Name: Honey
Type: Dog
Color: Light brown with white belly
Breed: English Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
Escaped fenced yard with other dog pictured. At around 4:00 pm around east 39th street in Des Moines. Extremely missed and loved please help
Pleasant Hill
Lost: 7/4/2015
ID: 920
Name: Coco
Type: Dog
Color: Blonde with Black in beard
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Young
She was scared by fireworks and ran off. No collar on.
Des Moines - South
Lost: 7/4/2015
ID: 916
Name: Bear
Type: Dog
Color: Brown
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Bear was last seen in our backyard around 6:30pm on the 4th of July. He was not wearing a collar.
Des Moines - East
Lost: 7/3/2015
ID: 914
Name:
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 7/1/2015
ID: 967
Name: Toby
Type: Dog
Color: Light brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Toby is an adult male puggle. He got loose from a house that is back behind the QT on 2nd Avenue. He is very friendly and probably does not have his collar on.
Adair
Lost: 7/1/2015
ID: 941
Name: Boshi
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
****Western Iowa***** lost at second rest area if heading east on 80 through the state. Name is boshi but no collar. Very deep Amber eyes. Please share this. He is the world to my daughter and I. If you have him or find him let me know here. Thank you so much.
Des Moines - East
Lost: 7/1/2015
ID: 891
Name: gizzie
Type: Dog
Color: black with some white around nose and mouth
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Senior
hes half pomerainon,half poodle hes got on a black tshirt with lil paw prints on the back
Des Moines - East
Lost: 6/29/2015
ID: 901
Name: Mija Vazquez
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
Des Moines - North
Lost: 6/29/2015
ID: 868
Name: Bonnie
Type: Dog
Color: light brown with just a little black on her back
Breed: Hound
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 6/28/2015
ID: 856
Name:
Type: Dog
Color: Dark Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 6/28/2015
ID: 855
Name: Boots
Type: Cat
Color: Gray
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on the morning of 6/28. Gray body with white tuxedo. Responds to boots. He is very large, and very friendly. Declawed in the front. Missed terribly. If found, please call or text 515/664-0374
Des Moines - North
Lost: 6/28/2015
ID: 852
Name: kazi
Type: Dog
Color: brown
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Young
She weighs 20 pounds and won't bite. She is still puppy. She is fast at getting away so grab her if you can.
Des Moines - South
Lost: 6/27/2015
ID: 848
Name: Tiny
Type: Dog
Color: Greyish
Breed: Poodle
Gender: Female
Fixed: Unknown
Age: Adult
She got out of back yard. She's a very nervous dog. Please call if you seen her.