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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Jolley
Lost: 7/3/2021
ID: 17121
Name:
Type: Dog
Color: Tan
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 7/3/2021
ID: 17119
Name: Glacier
Type: Dog
Color: Black/White
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
Our back yard
Des Moines - Central
Lost: 7/3/2021
ID: 17118
Name: Skye
Type: Dog
Color: Black/White
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
In our backyard.
Des Moines - East
Lost: 7/3/2021
ID: 17117
Name: Shiloh
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Baby
6:00 pm Des Moines East Side near Fairgrounds
Des Moines - East
Lost: 7/3/2021
ID: 17116
Name: Shiloh
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Adult
6:00 pm.
Des Moines - Central
Lost: 7/3/2021
ID: 17111
Name: Cali
Type: Dog
Color: Bindle and white
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Young
lost 7/2/21....woodland heights area. She's very timid and shy.
Des Moines - North
Lost: 7/2/2021
ID: 17271
Name: Shimmer
Type: Cat
Color: White and brown
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen around 16th st on Clark he has big poofy tail please contact me if you have seen him (515) 401-4529
Osage
Lost: 7/2/2021
ID: 17239
Name: Shadow Man
Type: Cat
Color: grey and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
He is super friendly and loves everybody and likes to go visiting
Ankeny
Lost: 7/2/2021
ID: 17166
Name: Dexter
Type: Cat
Color: Gray and black
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Senior
Ankeny
Lost: 7/2/2021
ID: 17165
Name: Dexter
Type: Cat
Color: Gray and black
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Senior
Osage
Lost: 7/2/2021
ID: 17158
Name: Shadow Man
Type: Cat
Color: grey and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
He jumped out my bedroom window while someone was watching him he is super sweet and very friendly and loves everyone he just likes to go visit and make friends we miss you so much please help me get him home
Ankeny
Lost: 7/2/2021
ID: 17137
Name: Dexter
Type: Cat
Color: Gray with black stripes and a bit or orange brown tuff on belly, eyes and chest
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Deer Creek, Ankeny- NE 17th St
Des Moines - North
Lost: 7/2/2021
ID: 17109
Name: Shira
Type: Dog
Color: White
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Not Neutered
Age: Senior
Urbandale
Lost: 7/1/2021
ID: 17228
Name: Graycee
Type: Cat
Color: grey and cream white
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Adult
Earlham
Lost: 7/1/2021
ID: 17113
Name: Blob
Type: Cat
Color: Yellow Tabby
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen the am hours early morning. He is very loud meow and meows a lot. He has scared paws from being burnt on stove top. And it looks like he has a small dirt spot on his nose. Very very friendly.
Des Moines - South
Lost: 7/1/2021
ID: 17104
Name: J.J
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Last seen around Loomis behind Lincoln high school around 11pm, he’s friendly and will most likely come up to you.
Des Moines - East
Lost: 7/1/2021
ID: 17101
Name: Skue
Type: Dog
Color: Brown
Breed: Pinscher
Gender: Male
Fixed: Not Neutered
Age: Young
2pm on 1400 Dean Ave
Ankeny
Lost: 7/1/2021
ID: 17095
Name: Kai
Type: Dog
Color: Gray and white
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Young
11am
Ankeny
Lost: 7/1/2021
ID: 17094
Name: Kai
Type: Dog
Color: grey and white
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Young
11:30am
Ankeny
Lost: 7/1/2021
ID: 17093
Name: Kai
Type: Dog
Color: White and black
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around Oak Creek Golf Course in Ankeny. Friendly, but thinks chasing is a game. Please call if spotted.
Altoona
Lost: 7/1/2021
ID: 14393
Name: Stitch
Type: Cat
Color: Gray/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
If anyone took him in or saw him injured or dead, please just let us know. Ty. He just vanished in JUNE 2020 & he was friendly yet tough, it’s hard to imagine he just disappeared. I’d rather know he’s in a nice home or pet heaven. Ty
Cedar Falls
Lost: 6/30/2021
ID: 17162
Name: Mystic
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
700 W Ridgeway Ave lot 636
Des Moines - East
Lost: 6/30/2021
ID: 17098
Name: Oreo
Type: Dog
Color: White and brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Idaho St and he barks at unknown people, he also likes to play, and even run. His collar is not on him, he took it off and ran off.
Des Moines - East
Lost: 6/30/2021
ID: 17097
Name: Joy
Type: Dog
Color: Brown body W/ brown and white face
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Joy was last seen 06/30/2021 around 8AM on the East Side of Des Moines.
Des Moines - East
Lost: 6/30/2021
ID: 17083
Name: Joy
Type: Dog
Color: Grey/brown
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Young
Escaped from our yard. Very shy and no collar