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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
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.