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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Panama
Lost: 6/29/2019
ID: 11753
Name: coco
Type: Dog
Color: light brown and white
Breed: Corgi
Gender: Female
Fixed: Neutered
Age: Adult
North 2nd Street in Panama, Iowa
Altoona
Lost: 6/29/2019
ID: 11734
Name: Mor
Type: Dog
Color: Brown & White
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Service Dog. Was wearing handler tags
Des Moines - East
Lost: 6/28/2019
ID: 11784
Name:
Type: Cat
Color: Grey and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on 255th and Elizabethg
Ankeny
Lost: 6/28/2019
ID: 11730
Name: Kyara
Type: Cat
Color:
Breed: Tiger
Gender: Unknown
Fixed: Unknown
Age: Adult
She is an indoor/ outdoor cat. she has beautiful green eyes.
Des Moines - South
Lost: 6/28/2019
ID: 11728
Name: Brownie
Type: Dog
Color: Brown and white
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
SW 13th St
Carlisle
Lost: 6/27/2019
ID: 11758
Name: shasta
Type: Dog
Color: red/drown/white
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Adult
walking toward flooded field
Polk City
Lost: 6/27/2019
ID: 11723
Name: Thelma
Type: Cat
Color: White, gray, and orange
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is and indoor/outdoor cat. Thelma loves to hunt and is very friendly. She likes to go over by Prarie Flower campground in Saylorville area.
Polk City
Lost: 6/27/2019
ID: 11722
Name: Thelma
Type: Cat
Color: White, gray, and orange
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is and indoor/outdoor cat. Thelma loves to hunt and is very friendly. She likes to go over by Prarie Flower campground in Saylorville area.
Polk City
Lost: 6/27/2019
ID: 11721
Name: Thelma
Type: Cat
Color: White, gray, and orange
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
She is and indoor/outdoor cat. Thelma loves to hunt and is very friendly. She likes to go over by Prarie Flower campground in Saylorville area.
Des Moines - Central
Lost: 6/27/2019
ID: 11697
Name: Pogo
Type: Cat
Color: White black brown
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
This morning while moving
Des Moines - North
Lost: 6/27/2019
ID: 11692
Name: Tilly
Type: Dog
Color: Black and white
Breed: Maltipoo
Gender: Male
Fixed: Not Applicable
Age: Young
2715 59th st Des Moines, Ia
Des Moines - North
Lost: 6/26/2019
ID: 11699
Name: Black kitty of Des Moines
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
Very friendly cat with a few white hairs on her front chest/lower neck.
Des Moines - North
Lost: 6/26/2019
ID: 11698
Name: Black kitty of Des Moines
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
A very friendly cat with a few white hairs on her lower front chest/ lower neck.
Des Moines - North
Lost: 6/26/2019
ID: 11693
Name: Jr
Type: Dog
Color: White , with black spots
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Last seen Walking on ovid by him self .
Des Moines - North
Lost: 6/26/2019
ID: 11681
Name: Dolly
Type: Dog
Color: Tan with black snout and bits of black on body
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
4900 block of Lyndale Drive about 4:00-4:30 pm
Ankeny
Lost: 6/26/2019
ID: 11678
Name: Louie
Type: Dog
Color: White and brown
Breed: Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Got out of house on NW 26th St. recently moved so he doesn’t know his surroundings
Altoona
Lost: 6/25/2019
ID: 11757
Name: Fozzie
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near 2600 Adventureland Dr
Altoona
Lost: 6/25/2019
ID: 11718
Name: Squirt
Type: Cat
Color: Grey&white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Has a broken tail
Des Moines - South
Lost: 6/25/2019
ID: 11676
Name: Penny
Type: Cat
Color: Bronze and black and little bit of white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
I lost Lorelei’s cat. Her name is penny, calico colored, has a white flea collar, and is well fed. She has all her claws still. I don’t think she has a chip in her either. I’ll post a picture when I find one! But she was lost by the zoo!
Ankeny
Lost: 6/25/2019
ID: 11674
Name: Blue
Type: Dog
Color: Brown/Grey
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
He got out of the gate around 6:15-6:30am this morning by Westwood Elementary
Ankeny
Lost: 6/25/2019
ID: 11673
Name:
Type: Dog
Color: Gray/silver and black
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Adult
Saw a larger gray or silver and black dog with bright orange collar running towards greenwood and 18 th street about 15 minutes ago
Runnells
Lost: 6/24/2019
ID: 11877
Name: Cash
Type: Dog
Color: Liver and White
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Dash and Cash were last seen around Powers Drive and Vandalia.
Runnells
Lost: 6/24/2019
ID: 11876
Name: Dash
Type: Dog
Color: Liver and White
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Dash and Cash were last seen around Power Drive and Vandalia.
Des Moines - East
Lost: 6/24/2019
ID: 11832
Name: Yogurt
Type: Cat
Color: Brown, black and a little white on face and feet
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Russell
Lost: 6/24/2019
ID: 11712
Name: Sammie
Type: Dog
Color: Black and White
Breed: English Pointer
Gender: Female
Fixed: Unknown
Age: Adult
Russel Iowa. Does not usually approach men, tends to like women more. Not a wandering dog, always comes home, doesn't stray far normally.