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>='1568505600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 8/12/2018
ID: 9373
Name: Storm
Type: Cat
Color: Multi
Breed:
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen last night around bricktown apartments. He is super friendly and also responds to bubbas.
Des Moines - North
Lost: 8/12/2018
ID: 9372
Name: Chloe
Type: Dog
Color: Black
Breed: Norwegian Elkhound
Gender: Female
Fixed: Neutered
Age: Young
Nw 2nd ave and 54th last seen
Adel
Lost: 8/12/2018
ID: 9368
Name: Grace
Type: Dog
Color: Tan/white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Young
Friendly but, may not come up to you. May come for food.
Urbandale
Lost: 8/11/2018
ID: 9394
Name: Juicy
Type: Cat
Color: Grey, white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Friendly, likes to be outdoors.
Des Moines - South
Lost: 8/11/2018
ID: 9384
Name: Teddy
Type: Dog
Color: White, black, and some brown
Breed: Lhasa Apso
Gender: Male
Fixed: Not Neutered
Age: Adult
Got lose on Elder Lane and is a companion pet.
Des Moines - Central
Lost: 8/11/2018
ID: 9374
Name: Jackie
Type: Cat
Color: Black and white .. Yellow eyes
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
Drake area... Cottage grove ave. Is where she got out.. Kind of fiesty..treats n tuna will help.
Des Moines - Central
Lost: 8/11/2018
ID: 9364
Name: Jackie
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
Yellow eyes..white chest..white feet
Urbandale
Lost: 8/11/2018
ID: 9362
Name: Payton
Type: Dog
Color: Black
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
64th st urbandale. Please call with anything news 319-389-6714
Des Moines - South
Lost: 8/11/2018
ID: 9361
Name: Siku
Type: Dog
Color: White
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 1500 block of E Lacona Ave. Friendly dog, very shy. Should not be contained within a stranger’s home without direct supervision as he will likely cause damage to property.
Ankeny
Lost: 8/11/2018
ID: 9360
Name: Izzy
Type: Dog
Color: Brown
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Adult
Escaped from the back yard. Skittish. Scared of men.
Des Moines - Central
Lost: 8/10/2018
ID: 9355
Name: Zoltar
Type: Dog
Color: Black & White
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
He was last seen by the BP on SW 9th just south of the Cityville Apartments. He is very friendly but can be skiddish. He slipped out of his collar so he will not have one on him.
Altoona
Lost: 8/10/2018
ID: 9354
Name: Cooper
Type: Dog
Color: Brown
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Senior
Altoona
Lost: 8/10/2018
ID: 9353
Name: Cooper
Type: Dog
Color: Brown
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Senior
Ankeny
Lost: 8/10/2018
ID: 9351
Name:
Type: Dog
Color: White / yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
At our home off of sw 41st ct 50023
Johnston
Lost: 8/10/2018
ID: 9347
Name:
Type: Dog
Color: Black, tan
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
Beaver ave and 54th
Des Moines - East
Lost: 8/9/2018
ID: 9397
Name: Shadow
Type: Cat
Color: Grey tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
14th and Dean. He is a very loving cat. He has some very distinct features. He is a polydactyl on 3 paws also has a half tail.
Des Moines - East
Lost: 8/9/2018
ID: 9348
Name: King
Type: Dog
Color: Brown and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
If anyone finds him please don’t let him outside by himself and call 515-313-5977
Des Moines - South
Lost: 8/9/2018
ID: 9344
Name: Kiwi
Type: Bird
Color: Green
Breed: Parrot
Gender: Unknown
Fixed: Unknown
Age: Baby
She was last seen by skate south she is very friendly and does answer to my kiwi there is a $100 reward
Des Moines - South
Lost: 8/9/2018
ID: 9340
Name: skip
Type: Dog
Color: Black
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Senior
Heading east on Summit Vista (east side of SW 31st) He's very friendly, chipped and has two tags on. (Owners live on Summit Vista) Cathy: 867.6688 mobile 244.4779 home
Ames
Lost: 8/8/2018
ID: 9419
Name: Trudy Lou
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen 56934 245th Street, SE of Ames. Green eyes, scared of strangers, very quiet meow.
Jewell Junction
Lost: 8/8/2018
ID: 9359
Name: Dora
Type: Cat
Color: Black and white Tuxedo
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen sleeping on our porch about the morning of the 8th
Des Moines - South
Lost: 8/8/2018
ID: 9352
Name: Chloe
Type: Dog
Color: white with tan spots
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Park Avenue and SW 9th area
Des Moines - South
Lost: 8/8/2018
ID: 9339
Name: Jax
Type: Dog
Color: Black/brown
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Young
Put outside chained up around 9 pm 937 gone
Des Moines - Central
Lost: 8/7/2018
ID: 9346
Name: Persephone/ Percy
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is freshly spayed so her belly is shaved. Last in the Sherman Hill neighborhood
Des Moines - Central
Lost: 8/7/2018
ID: 9334
Name:
Type: Dog
Color: Black
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Adult
19th and Keo