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>='1590710400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 5/3/2015
ID: 455
Name: winston
Type: Dog
Color: brown white and a little black
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Baby
in my backyard
Waukon
Lost: 5/2/2015
ID: 453
Name: Ruby
Type: Cat
Color: Black with with on stomach
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Ruby was take by a women with dark hair pulled back with bangs probably in her late 30's. She drove a grey/silver suv. Probably thought Ruby was a stray cat. She was taken Saturday between 2 and 3 p.m. a block north of Gus and Tony's Steakhouse. no collar. Ruby is black and has white fur on her stomach. missing a huge strip of fur because she had stickers caught on her fur and I had to cut them out.
Altoona
Lost: 5/1/2015
ID: 550
Name: tiger
Type: Cat
Color: calaco
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Council Bluffs
Lost: 5/1/2015
ID: 461
Name: Molly
Type: Dog
Color: Black with White tummy
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at the scene of a car accident on I-29 and exit 42. She ran west across the interstate. She is very shy and timid but never violent.
Johnston
Lost: 4/30/2015
ID: 497
Name: Pumba
Type: Cat
Color: orange and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Senior
Pumba was last seen in our house. He got out by accident. He is neutered and front declaw. He has medium length fur. He has allergies so his eyes are usually watery.
Woodburn
Lost: 4/30/2015
ID: 441
Name: patch
Type: Dog
Color: brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Patch has been found!!!!
Des Moines - East
Lost: 4/30/2015
ID: 434
Name: Mary
Type: Dog
Color: mostly black. some tan and white.
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Young
E29 th and Mahaska. Our front gate was accidentally left open and she wandered off around 7pm or 8pm. She is very friendly And gets along with other animlas. She has a curly tail.
Adel
Lost: 4/28/2015
ID: 510
Name: Ball
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
She's sweet but shy
Des Moines - South
Lost: 4/28/2015
ID: 425
Name: Diva
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last seen on Virginia Ave, south side of Des Moines. Shes very friendly. We've only lived in our home for 4 wks so shes familiar with the yard but not the area.
Des Moines - East
Lost: 4/28/2015
ID: 423
Name: Ollie B Collie
Type: Dog
Color: Black & White with Brown on the Legs
Breed: Border Collie
Gender: Male
Fixed: Not Neutered
Age: Young
There is a reward for his safe return, he was last seen at our house around 6pm on tuesday 4/28. He will respond to Ollie, if you have a treat he is extremely willing to come and play. If you find him, please call me at 515-650-7480.
Des Moines - East
Lost: 4/27/2015
ID: 727
Name: stash
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Stash is home!!!!!! I just got her today 6-10-15 she has lost doo much weight she went from 12 lbs to 3!!!! I'm just glad she's alive!!!!!
Des Moines - East
Lost: 4/27/2015
ID: 645
Name: stash
Type: Cat
Color: black and white tuxedo type
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
she has a hitler like moustache and black beauty mark on right side off face very friendly
Des Moines - East
Lost: 4/27/2015
ID: 569
Name: stash
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home she is an awesome cat and will come if u shake kitty treat bag she has a Hitler like moustache and a beauty mark please call 515-975-2587 if u see her we also have her daughter from a previous litter
Des Moines - East
Lost: 4/27/2015
ID: 529
Name: stash
Type: Cat
Color: black and white like a tuxedo
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Stash also has a Hitler like moustache!
Des Moines - East
Lost: 4/27/2015
ID: 528
Name: stash
Type: Cat
Color: black and white like a tuxedo
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home in garden with us she has a 1yr old daughter here with us and waiting for her return please come home stash we miss you and love you so very much we also think someone might have stolen her if you see her or have her please contact me PAtti at 515-306-9010 or 515-975-2587 thank you all so very much
Des Moines - East
Lost: 4/27/2015
ID: 475
Name: stash
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Here is a full front view of stash you can now see her Hitler like moustache she is still missing as of today she has been missing for 2 weeks now she is missed immensely please come home stash we love you!!!!
Des Moines - East
Lost: 4/27/2015
ID: 464
Name: stash
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home 2339e. 37Th ct she likes to lay in back Windows of cars to Sun herself she has a Hitler type moustache and she has a daughter here at home who misses her immensely and so do we please come home stash if you find her call Patti at 515-306-9010 thank you all so very much
Des Moines - East
Lost: 4/27/2015
ID: 447
Name: stash
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home on 37th ct. East side des Moines she has a black Hitler like moustache she is the bigger cat the other one is her daughter she misses her mama and so do we please come home stash!!!
Des Moines - East
Lost: 4/27/2015
ID: 446
Name: stash
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home on 37th ct. East side des Moines she has a black Hitler like moustache she is the bigger cat the other one is her daughter she misses her mama and so do we please come home stash!!!
Des Moines - East
Lost: 4/27/2015
ID: 445
Name: stash
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home on 37th ct. East side des Moines she has a black Hitler like moustache
Bondurant
Lost: 4/27/2015
ID: 414
Name: Winston
Type: Dog
Color: fawn
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Adult
Ames
Lost: 4/26/2015
ID: 435
Name:
Type: Dog
Color:
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Lost: 4/26/2015
ID: 421
Name: Ricardo
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Friendly but might be scared and cries a lot. Pointy ears and big eyes. Lost in Ankeny off of SE delaware
Dayton
Lost: 4/26/2015
ID: 412
Name: Maverick
Type: Dog
Color: rust
Breed: Dachshund-Miniature
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Burnside
Sergeant Bluff
Lost: 4/26/2015
ID: 410
Name: Beans
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Buchanan Avenue