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>='1568505600')) ORDER BY pm1.meta_value DESC, post_date DESC
Polk City
Lost: 7/19/2015
ID: 1035
Name: Jingles
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Senior
Took off just south of Jester Park campgrounds. Friendly but sometimes sciddish
Polk City
Lost: 7/17/2015
ID: 1032
Name: Callie Mae
Type: Cat
Color: Calico - markings on back and head
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen 2 am Friday on Grimes St. May be hard to pick up or get her to approach but in need of food, water or shelter she may be easier to approach.
Des Moines - North
Lost: 7/17/2015
ID: 1018
Name: Jack jack
Type: Dog
Color: White and brown
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Last seen on twana Dr des Moines ia, he was not wearing a collar
New Hampton
Lost: 7/16/2015
ID: 1009
Name: Emma
Type: Dog
Color: light tan / white
Breed: Jack Russell Terrier
Gender: Female
Fixed: Not Applicable
Age: Adult
Emma moved from Des Moines to New Hampton in January 2015. She has a black tip tail. She has a shock collar. Friendly. Loveable. Adores children. Spayed. Microchip. Runs like a grayhound. 50 pounds. Tan/white.
Des Moines - Central
Lost: 7/15/2015
ID: 2279
Name: kebe
Type: Dog
Color: brown / black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Bonaparte
Lost: 7/15/2015
ID: 1900
Name: Faye
Type: Dog
Color: Blonde. Dark color nose.
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
A visitor accidentally let her out of our home, then followed her on Highway J40 into a driveway, which led to a hayfield. Believed to have gone back to Hwy and picked up by a traveler passing through the area. She was unfamiliar with area outside of our new property. Please help her find her way back home. Very loved and missed by her family.
Ankeny
Lost: 7/15/2015
ID: 1005
Name: oscar
Type: Cat
Color: blackcalico with flecks of gold and white and a tan paw
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Young
live on sw oakmont cat got out with my older cat. cat is friendly but typically will laydown if you try to get her and she lets you pick her up, her tummy is shaved and she is supposed to get fixed on 21st and get her shots etc. i love her please help me find her
Elberon
Lost: 7/14/2015
ID: 1011
Name: Moonshine
Type: Cat
Color: Grey
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Very friendly cat. She is a long haired grey tabby. Comes to the named of Mooners and Shiners. She was last seen at our home when she went outside for the day. She is an indoor/outdoor cat and didn't come back in when I got home from work. It
Des Moines - North
Lost: 7/14/2015
ID: 988
Name: gizmo
Type: Dog
Color: black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
1605 Euclid
Ames
Lost: 7/13/2015
ID: 981
Name: Catnips Everdeen
Type: Cat
Color: black
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Copper Beech townhomes Ames. Not declawed but very nice
Nevada
Lost: 7/12/2015
ID: 992
Name: Brutus and Roxy
Type: Dog
Color: black and tan
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Adult
3 miles south of Nevada off the maxwell blacktop, usually free roam, but never came home that night and still haven't. ..
Des Moines - South
Lost: 7/12/2015
ID: 983
Name: Teacup
Type: Cat
Color: White with silver shaded hair on lower back
Breed: Persian
Gender: Female
Fixed: Neutered
Age: Young
Last seen at home... May have gotten out while grilling in the evening. Easter Lake area. She is white with green eyes. Her breed is Silver Shaded like the Fancy Feast cats. We will offer a reward if found. Thank you!
Cedar Falls
Lost: 7/11/2015
ID: 987
Name: Salem
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Salem is a Black cat. Our friend was bringing him to our apartment from chicago when he got out of the car and ran into a field behind the pointe west apartments on 18th street by the UNI dome. We saw him Saturday but he went back into the brush.
Des Moines - North
Lost: 7/11/2015
ID: 978
Name: Addie
Type: Dog
Color: Black with white chest and under eyes and tan/brown paws
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
We live on Morton Ave. in the Union Park / Grandview college area. Addie was last seen by a neighbor running towards E. 9th street at about 9:30 pm on Saturday night. She is a fast runner and gets scared of people. She was hit by a car last year so her neck is permanently cocked to the side due to her injury. We have had her for years and my 8 year old son is devastated that she is gone. REWARD IF FOUND! Please call 515-554-6823
Des Moines - South
Lost: 7/11/2015
ID: 976
Name: Unkown
Type: Dog
Color: Light brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
George Flagg parkway by grays lake and 32nd roaming around the streets almost getting hit by cars.
Newton
Lost: 7/10/2015
ID: 1207
Name: Sooka
Type: Dog
Color: Black,Tan,White
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
I'm missing my female husky mix she looks like a German shepherd she isn't very big. Her name is Sooka its pronounced Sue'ka She doesn't have her caller on. Here are a couple of pictures of her and if needed i have papers to prove ownership. Also she has seizures and needs to be on medication. The people that were watching her for me dropped her off on the side of the road somewhere not sure where they wont tell me where. Thank you so much.  My phone # text day or night on 6412758863 WE WILL NOT STOP LOOKING UNTIL SHE IS AT HOME SAFE AGAIN!!
Marion
Lost: 7/10/2015
ID: 1001
Name: hawkeye: mommies
Type: Cat
Color: black tortiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Not Neutered
Age: Adult
She is pregnant and very talkative. But super loveable and sociable with people and most other pets. She was last seen on 7th st. In marion.we miss her very much. 319-447-7197.
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