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
Ankeny
Lost: 10/18/2017
ID: 7350
Name: Mugsy
Type: Cat
Color: Tan/buff and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
It's been a few weeks, so he could have traveled quite a distance! But he was last seen in Ankeny by 8th and Lowell (which is off Delaware close to 1st St).
Des Moines - South
Lost: 10/18/2017
ID: 7309
Name: Mittens
Type: Cat
Color: Grey Tiger
Breed: Siberian
Gender: Male
Fixed: Neutered
Age: Young
Near Frazier avenue. Long hair coat.
Ankeny
Lost: 10/18/2017
ID: 7307
Name: Mugsy
Type: Cat
Color: Buff/tan and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Got out near 8th and Lowell/Michael (off Delaware by 1st). Sweet boy but a bit skittish. Would probably come if you called his name.
Ankeny
Lost: 10/18/2017
ID: 7213
Name: Mugsy
Type: Cat
Color: Buff/tan and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near 8th and Lowell (1st and Delaware area of Ankeny)
Ankeny
Lost: 10/18/2017
ID: 7177
Name: Mugsy
Type: Cat
Color: Buff/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
5th and Michael in Ankeny (1st and Delaware area.
Des Moines - North
Lost: 10/18/2017
ID: 7154
Name: Lucky
Type: Dog
Color: Grey
Breed: Schnoodle
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 10/18/2017
ID: 7152
Name: Mugsy
Type: Cat
Color: Buff and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 10/18/2017
ID: 7147
Name: Rigby
Type: Dog
Color: Black/White
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the drake area, she’s very friendly and will come right to you
Des Moines - Central
Lost: 10/18/2017
ID: 7146
Name: Rigby
Type: Dog
Color: Black/White
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the drake area, she’s very friendly and will come right to you
Johnston
Lost: 10/17/2017
ID: 7203
Name: Kush
Type: Cat
Color: black and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Young
off of 86th and Douglas. Johnston Iowa
Des Moines - South
Lost: 10/17/2017
ID: 7191
Name: Bear
Type: Dog
Color: Black/ tan
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Adult
Last seen laying next to me and my other dog sleeping. Pushed open storm door to go in backyard south of Wakonda Country Club. Doesn't come to strangers. Doesn't like planes, trucks or cars. Don't try to capture, call 5157458653 Very much missed and loved. He is microchipped
Johnston
Lost: 10/17/2017
ID: 7158
Name: Bindi
Type: Dog
Color: Cream
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
West Des Moines
Lost: 10/17/2017
ID: 7148
Name: Violet
Type: Dog
Color: brown & white
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Berkshire Townhouse headed towards Turtle Creek Apartments. Very timid, likes to hide in small places. Will not come up to people, will try to run from them.
Des Moines - South
Lost: 10/17/2017
ID: 7137
Name: Nyx
Type: Cat
Color: Grey
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Nyx was last seen at 3am on Tuesday morning, he ran out the door. He is a small about 7-8lb grey long haired cat. He was lost on Davis Ave right between South Union and SW 9th. Contact me 515-943-2456 if seen.
Des Moines - North
Lost: 10/17/2017
ID: 7129
Name: Dakota
Type: Dog
Color: Black
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
11:30am on 10th and seneca on the north side of des moines. She is a very friendly female boxer. Main color black with white around her face, white down the front of her chest, white on her 2 front paws. Call 515-778-7542 immediately if found! Thank you.
Des Moines - South
Lost: 10/16/2017
ID: 7247
Name: Precious
Type: Dog
Color: Brown and white
Breed: Jack Russell Terrier
Gender: Unknown
Fixed: Neutered
Age: Adult
Se 20 th E crest on ave 50320
Des Moines - West
Lost: 10/16/2017
ID: 7172
Name: Kita
Type: Cat
Color: black
Breed: Jack Russell Terrier
Gender: Female
Fixed: Neutered
Age: Young
45 th street Waveland area
Des Moines - West
Lost: 10/16/2017
ID: 7171
Name: Kita
Type: Cat
Color: black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
45 th street Waveland area
Huxley
Lost: 10/16/2017
ID: 7150
Name: Dash
Type: Cat
Color: Gray with white feet and belly
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
We live on Centennial in Huxley and was last seen on Sunday evening or Monday morning.
Des Moines - Central
Lost: 10/16/2017
ID: 7136
Name: Copper
Type: Dog
Color: Tan
Breed: Hound
Gender: Male
Fixed: Neutered
Age: Young
Is very very friendly loves to howl
Des Moines - East
Lost: 10/16/2017
ID: 7128
Name: Jack
Type: Cat
Color: Grey and Black
Breed: Hound
Gender: Male
Fixed: Neutered
Age: Adult
Lost in NE Des Moines- NE 27th and Aurora. He is very skittish and may not be when called. Please contact me if you find him.
Des Moines - East
Lost: 10/16/2017
ID: 7127
Name: Jack
Type: Cat
Color: Grey and Black
Breed: Hound
Gender: Male
Fixed: Neutered
Age: Adult
Lost in NE Des Moines- NE 27th and Aurora. He is very skittish and may not be when called. Please contact me if you find him.
Des Moines - East
Lost: 10/16/2017
ID: 7126
Name: Jack
Type: Cat
Color: Grey and Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Lost in NE Des Moines- NE 27th and Aurora. He is very skittish and may not be when called. Please contact me if you find him.
Des Moines - East
Lost: 10/15/2017
ID: 7113
Name: Sparton
Type: Dog
Color: Black with white on neck and chest
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Wondered off early sunday morning on the east side of Des Moines when he was let outside. Sparton is very friendly and smart, he does not bark.
Des Moines - East
Lost: 10/15/2017
ID: 7110
Name: Moe
Type: Dog
Color: black grey and white
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Adult
Moe has eyebrows and his rear end from tale looks like a bulls-eye. FOUND