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' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1590796800')) ORDER BY pm1.meta_value DESC, post_date DESC
Pleasant Hill
Found: 7/17/2016
ID: 3446
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Young
Found on onramp to bypass off Univerity in PH. Altoona police are taking custody tonight. Pink color with a black cat charm and heart charm
Des Moines - Central
Lost: 7/16/2016
ID: 3452
Name: Chewy
Type: Dog
Color: black and brown
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
He got out of my yard. Hes not very active likes to be lazy. Hes is our family dog and he has a dog best friend who misses him dearly.
Winterset
Lost: 7/15/2016
ID: 3501
Name: RJ
Type: Dog
Color: Brown and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen running thru alley. RJ has been with me since he was 6 weeks old. He is now 4 years old. If anyone knows who has him, please return him to me. He is very friendly.
Onawa
Lost: 7/15/2016
ID: 3473
Name: Clare
Type: Dog
Color: Black
Breed: Pug
Gender: Female
Fixed: Unknown
Age: Young
Missing from Onawa, IA
Johnston
Lost: 7/14/2016
ID: 3445
Name: Sammie
Type: Cat
Color: Black/Orange/White
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
NW 95th Ct, Johnston
Des Moines - West
Lost: 7/13/2016
ID: 3515
Name: Hope
Type: Dog
Color: White
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Adult
She is very friendly and loves attention. She has a small scar on top of her head from when she was born.
Norwalk
Lost: 7/13/2016
ID: 3427
Name: Tinka
Type: Cat
Color: Brown
Breed: Maine Coon
Gender: Female
Fixed: Unknown
Age: Adult
PLEASE HELP!!!! Our amazing family member ran out the patio door tonight at about 6:15pm. Her name is Tinka, she is 20-25lbs and long haired. She is a Maine Coon and we love her dearly.
Des Moines - South
Lost: 7/13/2016
ID: 3421
Name: Besos
Type: Dog
Color: White
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
At water works park someone pick him up and those of on a bike
Des Moines - South
Lost: 7/13/2016
ID: 3420
Name: Besos
Type: Dog
Color: White
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
At water works park someone pick him up and those of on a bike
Des Moines - Central
Lost: 7/11/2016
ID: 3419
Name: face or bubba
Type: Dog
Color: white now brown red nose
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Baby
He was last seen outside in back yard if u have any treats near call him now ask for a high five if he give u a high five walks sideways with his butt to the left
Indianola
Lost: 7/11/2016
ID: 3413
Name: Suzie
Type: Dog
Color: Brownish
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Lost in indianola. Suzie is very shy
Indianola
Lost: 7/11/2016
ID: 3412
Name: Suzie
Type: Dog
Color: Brownish
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Last seen in indianola. Suzie is very shy
Winterset
Lost: 7/10/2016
ID: 7439
Name: Blue
Type: Dog
Color: Blue Merle
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Was last seen South of Winterset Iowa
Woodburn
Lost: 7/10/2016
ID: 3407
Name: Zelda and Kiki
Type: Dog
Color: Brown/Red
Breed: GoldenDoodle
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 8:30pm 7/9/16 Dogs kept outside in kennel in rural Woodburn IA Dogs appear to have been stolen. Zelda is about 45lbs and Kiki is about 25. Both girls are 1 year old. Both had collars with tags on them with my phone number 515-556-0291 Dogs were being kept at grandparents in Woodburn temporarily.
Des Moines - Central
Lost: 7/10/2016
ID: 3404
Name: popcorn
Type: Dog
Color: white
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
he's a little white fluffy dog. he is very friendly and love chew toys, if there any info please contact its also a therapy dog..
Underwood
Lost: 7/9/2016
ID: 3394
Name: Ginger
Type: Dog
Color: Red and white
Breed: Siberian Husky
Gender: Female
Fixed: Not Applicable
Age: Baby
Slipped her collar and escaped the fence. She likely ran towards the I-80 interstate in Underwood. She was traveling with her sister, a red husky named Rose.
Underwood
Lost: 7/9/2016
ID: 3393
Name: Rose
Type: Dog
Color: Red, white
Breed: Siberian Husky
Gender: Female
Fixed: Not Applicable
Age: Adult
Escaped the fence and possibly ran towards the I-80 interstate near Underwood, IA. She has one brown/blue eye and is with her sister, a red, long haired husky named Ginger.
Des Moines - North
Lost: 7/8/2016
ID: 3385
Name: Armani
Type: Dog
Color: Grey, Blonde, White
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Very small 3lb dog, only has half of his teeth, 9 years old, very friendly.
Des Moines - East
Lost: 7/8/2016
ID: 3382
Name: Chief
Type: Cat
Color: Black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around Copper Creek in Pleasant Hill/Des Moines area 50317
Des Moines - Central
Lost: 7/8/2016
ID: 3378
Name: Sugar
Type: Dog
Color: White
Breed: French Bulldog
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - West
Found: 7/7/2016
ID: 3430
Name:
Type: Cat
Color: Orange
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
We have an adult orange cat stuck up in our large oak tree. We have tried everything to get it down, food, begging, a bucket truck, no luck. I'm hoping to find it's owner and possibly they can coax it down. If you are missing an orange cat, please contact me right away.
Des Moines - South
Found: 7/7/2016
ID: 3402
Name:
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Young
Found around Park Ave and SW 9th
Des Moines - North
Lost: 7/7/2016
ID: 3387
Name: SUGAR
Type: Dog
Color: WHITE "FRENCH BULLDOG"
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Young
THIS IS MY NEIGHBORS DOG.. THERE IS A REWARD - THEIR NUMBER IS 515 201 2631 -LAST SEEN BEAVERDALE, 47TH OVID -- NOT SURE HOW TO GET PICTURES FROM OTHER DEVICE.. I HAVE PICS ON FB - HERE IS LINK https://www.facebook.com/photo.php?fbid=10206927663326164&set=pcb.10206927664526194&type=3&theater OR https://scontent-ord1-1.xx.fbcdn.net/v/t1.0-9/13620913_10206927663526169_6356807938913737823_n.jpg?oh=8e191710c443c167f37aa0cbf008e35b&oe=57F1C6BE
Des Moines - Central
Found: 7/7/2016
ID: 3371
Name: N/A
Type: Dog
Color:
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Young
found on bike trail between Mullets and Greys Lake. Very friendly little girl.
Des Moines - Central
Spotted: 7/7/2016
ID: 3370
Name:
Type: Dog
Color: White, maybe some browm
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Adult
A little white dog like a jack Russell (short haired) was running around near the DMU parking lot around 7:30 in the evening. It seemed very skittish and wouldn't let us near it. I think it had a red collar. I'll post if I see it again,