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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Indianola
Lost: 6/10/2018
ID: 8955
Name: Eli
Type: Dog
Color: Blue and White
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Eli was last seen 5 miles south of Indianola by Lake Aquahbi, at his house. He is a big dog and can look intimidating, but very friendly with people and kids. He has taken to running off in the last two months, (will be neutered when he comes back home). He has some health issues and was on medication when he ran off, he might look or act sick but is not mean. He has a white chest and his feet are white with blue spots. His family loves him very much, please post if you spot or find him! Thank you
Des Moines - North
Lost: 6/10/2018
ID: 8875
Name: Boots
Type: Cat
Color: All Black long haired with some white and white paws
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Our cat boots was last seen in our home on aurora ave, right across the street from Hoover high school. He got out out of the window screen. He has never been outside so we are worried about him dearly, he has white paws and green eyes. His neck area is white and also on chin area.
West Des Moines
Lost: 6/10/2018
ID: 8828
Name: Arya
Type: Cat
Color: Grey/Brown
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at Wellington Apartments on 50th and EP True
Des Moines - Central
Lost: 6/10/2018
ID: 8805
Name: Rapunzel
Type: Cat
Color: Tan
Breed: Siamese
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 8 am. Maintenance left door open and she got out. She’s VERY sweet but shy.
Des Moines - East
Lost: 6/10/2018
ID: 8803
Name: Swisher
Type: Dog
Color: Tan and brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
In east end on 29th st
Des Moines - South
Lost: 6/9/2018
ID: 8796
Name: Toby
Type: Dog
Color: Tan black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
On front porch balcony fenced in
Huxley
Lost: 6/8/2018
ID: 8838
Name: Bubbles
Type: Cat
Color: White with Orange face back and tail.
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Last Seen at Home on W 1st St in Huxley
Des Moines - East
Lost: 6/8/2018
ID: 8798
Name: Diesel
Type: Dog
Color: Black/tan
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
June 8th 2018 around noon Diesel was stolen he’s a 7 month old German Shepherd he was unclipped from his leash he is wearing a red collar and a sliver chain. This happened on the east side of Des Moines near haitt middle school.He is chipped and the alert has been sent out. If you have any information olease contact me at (515)-865-4684
Ames
Lost: 6/8/2018
ID: 8797
Name: Resse Woolery
Type: Cat
Color: Golden
Breed: Somali
Gender: Male
Fixed: Neutered
Age: Senior
He’s a frenidly cat and has noddely fur on stomach plus has a fluffy tale
Des Moines - East
Lost: 6/8/2018
ID: 8794
Name: Sol
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Got lost on Buchanan St east side, has the collar in the picture. Got out in the night when I open the door.
Fort Dodge
Lost: 6/8/2018
ID: 8791
Name: Silvia
Type: Dog
Color: Brown
Breed: Dachshund
Gender: Female
Fixed: Neutered
Age: Young
Johnson Ave and 260th St south of new Hwy 20
Story City
Lost: 6/8/2018
ID: 8789
Name: Misty
Type: Dog
Color: Brown/red merle
Breed: Dachshund
Gender: Female
Fixed: Not Neutered
Age: Adult
Misty.. 8 yrs old .. Female Tied outside of house at 11891 George W. Carver Pulled out of collar sometime after 7am and before 12:30pm..She's a wonderer but usually stays in yard.. Call Mike 515-290-9509 or Brooke 515-577-0940
Des Moines - North
Lost: 6/8/2018
ID: 8786
Name: Milo
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
I last seen Milo at 7:30 this morning, I opened up the back door to try and get him leeshed and he chased a squirrel.
Des Moines - North
Lost: 6/7/2018
ID: 8785
Name: Mila
Type: Dog
Color: White with tan spots
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Cambridge
Lost: 6/7/2018
ID: 8781
Name: Minnie
Type: Dog
Color: White and brown
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen at 2pm around 570th ave area of Cambridge.
Cambridge
Lost: 6/7/2018
ID: 8780
Name: Minnie
Type: Dog
Color: White and brown
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen at 2pm. 570th ave area of Cambridge.
Des Moines - West
Lost: 6/7/2018
ID: 8779
Name: Babay
Type: Dog
Color: White/Tan ish
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Baby
She was last seen the Drake area If you find her please call (515) 339-2979‬ or email mikaylacarey22@yahoo.com
Des Moines - South
Lost: 6/6/2018
ID: 8782
Name: Frankie
Type: Cat
Color: TANISH/very light orange
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen by either the sw 9th and Park Ave area or se 9th Street Southside Des Moines. His name is Frankie and does not have his collar or tags on!! Please help me find him!! He is just a kitten and needs to be taken care of!!
Ankeny
Lost: 6/5/2018
ID: 8807
Name: Vicente
Type: Cat
Color: White
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
If he lets you check my kitty has a broken canine tooth (his right one)
Ames
Lost: 6/4/2018
ID: 8845
Name: Lou
Type: Cat
Color: Light orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in West Ames around Sawyer Elementary area. Easily scared by strangers.
Des Moines - South
Lost: 6/4/2018
ID: 8792
Name: Robbie
Type: Cat
Color: Grey tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Easter Lake south Des Moines. Easter Lake park on the south side near the playground. Very friendly, would let anyone pick him up. I live right by EasterLake and my cat would often go over there.
Des Moines - North
Lost: 6/4/2018
ID: 8778
Name: Mia
Type: Cat
Color: Black and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Lost at the QT at 2nd Avenue and Broadway across from Firestone
Grimes
Lost: 6/4/2018
ID: 8769
Name: Snow
Type: Dog
Color: White and tan
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - East
Lost: 6/4/2018
ID: 8763
Name: Zeke
Type: Dog
Color: White and brown
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Baby
Last seen running across the street from the house to the neighbors on 21easton BLVD
Des Moines - North
Lost: 6/4/2018
ID: 8762
Name: Mia
Type: Cat
Color: Black white long hair
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
Quick Trip on 2nd Avenue