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
Pleasant Hill
Lost: 5/30/2016
ID: 3048
Name: Milo
Type: Cat
Color: Multi dark brown light brown black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Milo is greatly missed he was just rescued from the arl about two months ago my niece is devastated any help would be greatly appreciated
Colfax
Lost: 5/30/2016
ID: 3037
Name: Diesel
Type: Dog
Color: Silver
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Near Valeria, Iowa
Des Moines - South
Lost: 5/30/2016
ID: 3034
Name: Sherman
Type: Dog
Color: Salt and pepper
Breed: Schnauzer Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
Sherman slipped his collar and wanted to check out the neighborhood. He is due for his summer cut and looks much more shaggy than in the pic. He is very friendly and loves to play with everyone.
West Liberty
Lost: 5/29/2016
ID: 3058
Name: Cowgirl
Type: Dog
Color: merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Baby
very friendly puppy, very socialized, will get in your vehicle if door was open. A Reward will be offered for her return, no questions asked. she is very missed by her family. she is also being shown in 4-h dog obedience by my 9 year old son.
West Liberty
Lost: 5/29/2016
ID: 3057
Name: cowgirl
Type: Dog
Color: merle
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
very friendly puppy, will get in your vehicle if door was open. was in 4-h obedience classes with my 9 year old son. has been VERY socialized. a reward will be offered for her return, no questions asked. very missed by my family
Des Moines - South
Lost: 5/29/2016
ID: 3033
Name:
Type: Dog
Color:
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
has dog licence tag on collar
Des Moines - South
Lost: 5/29/2016
ID: 3032
Name: kissy
Type: Dog
Color: black &white
Breed: Siberian Husky
Gender:
Fixed: Not Neutered
Age: Adult
has dog licence tag on collar
Des Moines - South
Lost: 5/29/2016
ID: 3031
Name: kissy
Type: Dog
Color: black &white
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
has dog licence tag on collar
Polk City
Lost: 5/29/2016
ID: 3030
Name: Diesel
Type: Dog
Color: Black with white stripe on chest
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 5/29/2016
ID: 3024
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Wandering in South Des Moines, German Shepherd and Border Collier mix dogs. Wasn't able to get close. Border Collier has tags.
Ankeny
Lost: 5/29/2016
ID: 3023
Name: Megan
Type: Dog
Color: Black and white
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Neutered
Age: Senior
2003 SE Clover Ridge Dr, Ankeny. Her home.
Ankeny
Lost: 5/28/2016
ID: 3016
Name: Princess
Type: Cat
Color: Mostly white with grey
Breed: Persian
Gender: Unknown
Fixed: Not Neutered
Age: Young
713 sw Springfield dr Ankeny Iowa 50023
Des Moines - South
Lost: 5/27/2016
ID: 3051
Name: Gizzie
Type: Dog
Color: Brown and tan
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
5
Des Moines - South
Lost: 5/27/2016
ID: 3006
Name: Gotti
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
At my house idk how or where he got out he's an indoor cat and has a eye problems
Des Moines - South
Lost: 5/27/2016
ID: 3005
Name: Patrick
Type: Cat
Color: Tigher
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
In May house I'm not sure when and how he got out but he's and indoor cat
Des Moines - East
Lost: 5/26/2016
ID: 3101
Name: Felix
Type: Cat
Color: Black, brown, and a little grey
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
He's very friendly and sweet, and he likes to bring me dead birds and bunnies, and he's very talkative. He loves the outdoors, but being gone longer than a day or two just isn't like him and I'm very worried.
Windsor Heights
Lost: 5/26/2016
ID: 2997
Name: Cheyenne
Type: Dog
Color: Black
Breed: Border Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
Off Euclid
Toledo
Lost: 5/25/2016
ID: 3102
Name: Harley
Type: Dog
Color: Tan/brown
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen at her home. She was wearing a black underground fence collar. The picture provided is a couple years old, now she has a little more grey on her face and is a bit chunkier. We haven't received any clues or sightings. We are very worried about her.
Des Moines - East
Lost: 5/25/2016
ID: 3000
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Last seen on East 30th at home in Douglas acres des moines
Muscatine
Lost: 5/25/2016
ID:
Name: Miju
Type: Cat
Color: Multicolor
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
This morning. She has krange eyes, she loves the chicken flavored temptations treats for cats, she is very talkative and friendly and has a "raccoon" tail with dark stripes.
Muscatine
Lost: 5/25/2016
ID: 2990
Name: Miju
Type: Cat
Color: Multicolor
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
This morning. She has krange eyes, she loves the chicken flavored temptations treats for cats, she is very talkative and friendly and has a "raccoon" tail with dark stripes.
Des Moines - East
Lost: 5/24/2016
ID: 3012
Name: Champion
Type: Dog
Color: Blue / town pitbull
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Champion is a blue pit. He is extremely kind and loving. He escaped from the east 14th two days ago. There is a $100 reward fit the safe return of our dig. Please help us we miss him. You can call at 515 639 8564
Des Moines - North
Lost: 5/24/2016
ID: 2987
Name: kitty
Type: Cat
Color: tiger stripped
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Adult
last seen at home on the northside by the house. She is very loving and can be shy at first. If you have a bag of food and shake it she will come a running.
Urbandale
Lost: 5/23/2016
ID: 2971
Name: Ghost and Atreyu
Type: Dog
Color: White husky and german shepherd
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Unknown
Age: Young
Missing german shepherd and white husky mix. Thebgerman shepherd's name is Atreyu and the husky's name is Ghost. If any info please call me at 5157241580
Des Moines - South
Lost: 5/22/2016
ID: 3018
Name: Junior
Type: Cat
Color: Yellow
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Disappeared from his yard south of County Line Rd. on SW 9th St. 3-legged cat, tame and very sweet.