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>='1594080000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - North
Lost: 6/24/2019
ID: 11703
Name: Miso
Type: Cat
Color: Siamese
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
Last seen on the 24th. There was a storm and a tree fell down in the yard. when we went out to check, the door was left open and Both cats ran out. He is super sweet but very shy. Siamese seam point
Ankeny
Lost: 6/24/2019
ID: 11702
Name: Kuro
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Runnells
Lost: 6/24/2019
ID: 11687
Name: Cash
Type: Dog
Color: Brown and white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Runnells
Lost: 6/24/2019
ID: 11686
Name: Dash
Type: Dog
Color: Brown and White
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 6/24/2019
ID: 11680
Name: Yogurt
Type: Cat
Color: Brown and Black
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
white patch on nose
Des Moines - Central
Lost: 6/24/2019
ID: 11666
Name: Jerry and Lucy
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
Jerry and Lucy went missing about 1pm around lower beaver area.
Des Moines - Central
Lost: 6/24/2019
ID: 11590
Name: Mittens
Type: Cat
Color: Brown and black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Beaverdale on 49th St. and Urbandale Avenue. She has 6 toes on front paws.
Des Moines - East
Lost: 6/23/2019
ID: 11810
Name: MJ
Type: Cat
Color: Gray, orange, white
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Adult
Phone number is not the one listed!!!! Please contact 515-954-6800
Des Moines - East
Lost: 6/23/2019
ID: 11794
Name: Fuzzy
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Johnston
Lost: 6/23/2019
ID: 11696
Name: Kallie
Type: Cat
Color: Calico
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
She’s very friendly. She is a smaller cat but is full grown. Her eyes are a yellow greenish color.
Runnells
Lost: 6/23/2019
ID: 11675
Name: Marley
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
Marley is a indoor cat, he has a saggy belly a black goatee with a white tuxedo belly, he also has a lightning bolt pattern on one of his back feet!! Has all claws but is so sweet, hes a lover!!!
Des Moines - Central
Lost: 6/23/2019
ID: 11662
Name: Rizzo
Type: Dog
Color: Brindle
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - Central
Lost: 6/23/2019
ID: 11661
Name: Rocky
Type: Dog
Color: Brown
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 6/23/2019
ID: 11657
Name: Pearl
Type: Cat
Color: Light gray with dark gray
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Pearl went missing on 4/9/19 or the morning of 4/10/19. She got out somehow on Snyder Blvd, a side street off of Oralabor Rd in Ankeny. She has all her claws. Friendly but has never been out for this long so may be skittish. If you see her or have her please do the right thing and call or text 515-720-5523. I have had her since she was 4 weeks old and she is now 3 years old.
Des Moines - East
Lost: 6/22/2019
ID: 11809
Name: MJ
Type: Cat
Color: Gray, orange, white
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
Phone number is not the one listed!!! Contact 515-954-6800
Des Moines - East
Lost: 6/22/2019
ID: 11808
Name: Fuzzy
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Phone number is not what is listed 515-954-6800
Des Moines - East
Lost: 6/22/2019
ID: 11807
Name: Fuzzy
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult