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
Altoona
Lost: 7/26/2018
ID: 9228
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Reasnor
Lost: 7/26/2018
ID: 9226
Name: Wrigley
Type: Dog
Color: Black with white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
In reasnor may have followed ragbrai riders very friendly dog
Des Moines - East
Lost: 7/26/2018
ID: 8880
Name: Boots
Type: Cat
Color: Tuxedo (Black & White)
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He has been missing since the beginning of June. He has green eyes.
Booneville
Lost: 7/25/2018
ID: 9325
Name: Chester
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He’s sweet and has white swirls on his side. He’s 1. He is declawed in the front.
Ankeny
Lost: 7/25/2018
ID: 9250
Name: Kitty
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Gladbrook
Lost: 7/25/2018
ID: 9233
Name: Sara
Type: Dog
Color: Light brown and white
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
Sara has her multicolored collar and an orange leash attached. She was scared and ran toward a field near Highway 96 on the south side of Gladbrook, Iowa. We caught another glimpse of her running in the same field, but she was still scared and ran back into the field.
Pleasant Hill
Lost: 7/23/2018
ID: 9222
Name: Delilah
Type: Cat
Color: Black and While
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen running around Pleasant Hill, don’t chase after her she will run. If you can catch her please call as soon as you can, thank you.
Hartford
Lost: 7/23/2018
ID: 9221
Name: Phoebe
Type: Dog
Color: Golden-red
Breed: Golden Retriever
Gender: Unknown
Fixed: Neutered
Age: Young
She left home with her sister, Chloe, who came home without her yesterday. She is very lovable and will get right in your car if you ask her to.
Altoona
Lost: 7/23/2018
ID: 9220
Name: Dezi
Type: Cat
Color: Gray Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
She was last seen while installing a new storm door. She is small and has had previous trauma (prior to our rescuing her) . One ear is pointed out rather than up, she has a foggy eye , shorter tail. She also has pink cat caps. She is very skittish.
Des Moines - South
Lost: 7/23/2018
ID: 9216
Name: fez
Type: Dog
Color: Black and white
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Senior
Last seen around Park Ave and Sw 12th st.
Des Moines - North
Lost: 7/22/2018
ID: 9312
Name: Digits
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
We just moved to NE 49th Ave when Digits took off out the door and hasnt been seen since, if you have any information please contact me. 515-241-3719
Des Moines - Central
Lost: 7/22/2018
ID: 9218
Name: Aries
Type: Dog
Color: White with black and white face
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at his home on 43rd and Ingersoll and must have gotten out of an open basement door.
Des Moines - North
Lost: 7/22/2018
ID: 9208
Name: Monroe
Type: Dog
Color: Tan & white
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Saturday night. He got out of our backyard gate. He is very friendly to humans and it is not like him to leave our property. He does have a collar on, but unfortunately his tag recently broke off, so he doesn't have contact info on him. He is microchipped. Please give me a call if you see our buddy. My # is 515-802-4304. Thanks!
Des Moines - South
Lost: 7/22/2018
ID: 8988
Name: Frankie
Type: Cat
Color: orangeish/cream colored
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
LAST SEEN AT MOTEL 6 ON FLEUR. HE HAS A LONG TAIL. HE IS CHIPPED. HE WIGGLED OUT OF HIS COLLAR SO HE DOES NOT HAVE ONE ON. PLEASE PLEASE PLEASE TEXT OR CALL IF YOU FIND HIM OR SEE HIM!!!!
Des Moines - East
Lost: 7/21/2018
ID: 9223
Name: Miklo
Type: Dog
Color: White
Breed: Poodle Standard
Gender: Male
Fixed: Neutered
Age: Adult
We miss him very much and I know he does to please help me get him home to us please he loves to take runs
Clive
Lost: 7/21/2018
ID: 9212
Name: Blaze
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 7/21/2018
ID: 9207
Name: Amelia
Type: Cat
Color: Black/orange/brown
Breed: Tortoiseshell
Gender: Unknown
Fixed: Not Neutered
Age: Young
Last seen in the greys lakes apartment complex.
Des Moines - South
Lost: 7/21/2018
ID: 9202
Name: Lilly
Type: Dog
Color: Black and white
Breed: Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
Lilly has both blue eyes and is black and white. She was last seen last night but a neighbor of ours said he heard our dogs about 2 this morning. She escaped her color somehow and ran off.... She ran off between 2 and 6:16 this morning. Please help me get Lilly back home. She just turnt a 1 year old in June. She means everything to me and my family.. Please help me get her back where she belongs... We live right down the street from the blank park zoo on Johnson street..
Des Moines - South
Lost: 7/20/2018
ID: 9209
Name: Trone
Type: Dog
Color: brindle
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Adult
broke his cable, he's very friendly, but does not like dogs...
Altoona
Lost: 7/20/2018
ID: 9206
Name: Paisley
Type: Cat
Color:
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
If seen please contact 5152055092
Lorimor
Lost: 7/20/2018
ID: 9203
Name: Tiger
Type: Dog
Color: White with brown and gray spots
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Got loose in the am hasnt been back yet looked all over town. He is deeply missed!
Nevada
Lost: 7/20/2018
ID: 9200
Name: Leia
Type: Dog
Color: Champagne and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
5pm in our backyard at 820 4th st. Nevada
Des Moines - South
Lost: 7/20/2018
ID: 9199
Name:
Type: Dog
Color: Black and white
Breed: Dalmatian
Gender: Male
Fixed: Unknown
Age: Baby
Found by Ewing park.
Des Moines - South
Lost: 7/20/2018
ID: 9197
Name: Savannah
Type: Dog
Color: white
Breed: Maltese
Gender: Female
Fixed: Not Neutered
Age: Senior
Last seen outside of home on E. Emma Avenue on the south side of DSM, near Donna's Lounge (now Donna's Garage). She is a senior dog with missing teeth, so her tongue hangs out. She is very sweet but probably won't respond to her name as she is mostly deaf. She is very small- 7 lbs max.
Nevada
Lost: 7/19/2018
ID: 9192
Name: Rosco
Type: Cat
Color: Black & tan stripped
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Jodie Hoover-Jasper 2 hrs Roscoe, our DSH stripped kitty, got out in the night & has disappeared. He's never been outside before. We live on S27 / 650th Ave, south of Fernauld. He's very friendly, a year old, neutered & has a chip that is not activated. Please call 5I5 2I5 2585 if you even think you've seen him. Thank you.