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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 1/11/2017
ID: 4715
Name: marley
Type: Cat
Color: smoke gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
very loveable cat all gray long hair lost over by fairgrounds north side of unviersity. he just turned 1 and is misssed by my son after having to but his dog down around christmas.
Des Moines - East
Lost: 1/11/2017
ID: 4700
Name: Molly
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Adult
She is very friendly and loves kids. She has a very weak stomach and can only eat certain food without getting sick!! Also she is spayed however that option not coming up on the fixed drop down
Worthington
Lost: 1/10/2017
ID: 4727
Name: Macy
Type: Dog
Color: white
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Young
Ran from a farm in Worthington, IA. Last seen running west on X47. May be headed home to Cedar Rapids, IA. 5 pounds, 5 years old, spayed female. Hair is around 3-5 inches long. Docked tail. Brown eyes.
Kalona
Lost: 1/10/2017
ID: 4725
Name: Copper
Type: Dog
Color: Tan
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Redfield
Lost: 1/10/2017
ID: 4689
Name: Beans
Type: Cat
Color: Brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Senior
I posted one of these but I wasn't logged in a can't edit it sorry :( He was last seen inside, no one is sure if they let him out. He likes to hang around the Sewer Drains, and it rained the night before so we can't be sure what happened.
Redfield
Lost: 1/10/2017
ID:
Name: Beans
Type: Cat
Color: Brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Senior
Seen inside the house, unsure if someone let him out. He likes to sit in the sewer drain
Indianola
Lost: 1/9/2017
ID: 4695
Name: Brady
Type: Dog
Color: Mable
Breed: Collie Rough
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in his normal spot in front of our house in between Indianola and Carlisle, out by the Summerset Winery.
Ankeny
Lost: 1/9/2017
ID: 4685
Name: Abby
Type: Dog
Color: Black
Breed: Poodle
Gender: Female
Fixed: Unknown
Age: Adult
SE Deleware Ave
Ankeny
Lost: 1/6/2017
ID: 4671
Name: Max
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Adult
Around nw 70th place
Des Moines - North
Lost: 1/6/2017
ID: 4668
Name: Harley
Type: Dog
Color: Tan/white
Breed: Great Pyrenees
Gender: Unknown
Fixed: Neutered
Age: Young
Douglas and wright area. She jumped our fence. She doesn't like to be scruffed.
Des Moines - South
Lost: 1/6/2017
ID: 4667
Name: Daisy
Type: Dog
Color: Brown,white,black
Breed: Beagle
Gender: Unknown
Fixed: Unknown
Age: Baby
Lost near a school near SW14th and Geil.
Adel
Lost: 1/4/2017
ID: 4664
Name: PANCAKES
Type: Dog
Color: WHITE WITH LIVER SPOTS & TICKING
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at Doc's Hunt Club (Prospect Circle Adel, IA). He is a social dog, but slightly unsure of new situations but can be coaxed by using his name.
Panora
Lost: 1/4/2017
ID: 4662
Name: Hercules
Type: Dog
Color: Black white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
10:30 pm he is very friendly and we miss him very much
Des Moines - North
Lost: 1/3/2017
ID: 4813
Name: Hercules
Type: Dog
Color: Black and white with a diamond shape on his back of his neck
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on forest ave on 4 street. He's can get scared with new people so he'll bark at you and if you come toward him might run. If you seen him text me if you seen him. Number is 515-444-6675
Des Moines - Central
Lost: 1/3/2017
ID: 4810
Name: Hercules
Type: Dog
Color: Black and white with Diamond shape on his back of his neck
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
If yiur not scared of pitbull then he'll bit a bit scared and start backing up but you are call me or text me where you lat seen him 515-444-6675
Des Moines - Central
Lost: 1/3/2017
ID: 4809
Name: Hercules
Type: Dog
Color: Black and white with a diamond shape on his back of his neck
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Don't be afraid to come up to him if you are he'll jump on you,he barks when he's scared
Des Moines - South
Lost: 1/3/2017
ID: 4669
Name: Baby
Type: Cat
Color: Grey and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
he has a tear on his right ear
Malvern
Lost: 1/2/2017
ID: 4658
Name: Norman
Type: Dog
Color: Caramel brown/white
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
We live in the 7th and Wilson area
Des Moines - East
Lost: 1/2/2017
ID: 4651
Name: Bruce
Type: Dog
Color: Black\Brown
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on 24th and Capitol. He ran out the door and we couldn't catch him. He is Microchipped and has a collar with tags. He does not like men. Please call 515-556-1239 or 515-554-1489 if you see him.
Des Moines - South
Lost: 1/2/2017
ID: 4641
Name: Otis
Type: Dog
Color: black and white Teddy Bear/ looks like a Shih tzu
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
no collar because i have been grooming him this weekend. his belly was just shaved 1/1/17, he has a snaggletooth/underbite, he does not like other dogs (he was under socialized when we got him), he loves people. he ran away because the smoke/heat/"cooking" alarm went off.
Des Moines - North
Lost: 1/2/2017
ID: 4640
Name: Rocky Balboa Fujita
Type: Dog
Color: Brown/ beige
Breed: English Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Rocky suffers from breathing problems and exhaustion when takes long walks. Allergic to food made out of corn. Restrictions apply when comes to snacks and foods.
Des Moines - Central
Lost: 1/1/2017
ID: 4707
Name: Hercules
Type: Dog
Color: Black and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 1/1/2017
ID: 4693
Name: oscar
Type: Cat
Color: black and grey
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
declawed in front not back.
Des Moines - North
Lost: 1/1/2017
ID: 4659
Name: PIP
Type: Cat
Color: orange and white tabby
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Young
My parents were pet sitting when she got out at their house. They live just north of Hoover high school. She is very distinct circle markings on her side.
Granger
Lost: 1/1/2017
ID: 4634
Name:
Type: Dog
Color: Tan and white
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Baby