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
Nevada
Lost: 9/26/2017
ID: 6895
Name: Zena
Type: Dog
Color: Black and brown
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Applicable
Age: Adult
Last seen at the Intersection of 3rd st. and E Avenue in Nevada she was in the parking lot of the church. She has been staying around the area where last seen and been seen three times on Westwood St. which is on the west of 3rd St. Is friendlier to Women, can be scared of men she doesn’t know. Offering a reward for safe return
Des Moines - Central
Lost: 9/25/2017
ID: 7067
Name: Snickers
Type: Dog
Color: Brown
Breed: Poodle Toy
Gender: Male
Fixed: Neutered
Age: Adult
Snickers was lost around Mid Night in the Brawdlawns Hospital Area on Lincoln Ave
Grimes
Lost: 9/25/2017
ID: 6886
Name: Unknown
Type: Dog
Color: Dark blonde/light brown
Breed: Poodle Toy
Gender: Female
Fixed: Unknown
Age: Senior
Found her in our front yard in the rain
Norwalk
Lost: 9/24/2017
ID: 7775
Name: Sonic
Type: Cat
Color: White w/Black Spots
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
He meows alot and at the time was a bit hoarse and we had just started him on an antibiotic. Very friendly and Well Fed, also declawed.
Norwalk
Lost: 9/24/2017
ID: 6970
Name: Bella
Type: Cat
Color: chocolate
Breed: Siamese
Gender: Female
Fixed: Unknown
Age: Senior
Lost in Lakewood area between swimming area & powerline park.
New Virginia
Lost: 9/24/2017
ID: 6891
Name: Pepper
Type: Dog
Color: Black White
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Young
He has seizures
New Virginia
Lost: 9/24/2017
ID: 6889
Name: Pepper
Type: Dog
Color: Black White
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Young
He has seizures
Des Moines - East
Lost: 9/24/2017
ID: 6881
Name: Bailey
Type: Dog
Color: Brown and white
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 9/24/2017
ID: 6808
Name: Max
Type: Dog
Color: black and white
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Black collar with city license and rabies vac tag. No tail. Very friendly!
Madrid
Lost: 9/23/2017
ID: 7081
Name: Tyson
Type: Dog
Color: reddish-brown
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
friendly family member
Des Moines - South
Lost: 9/23/2017
ID: 6877
Name: Princess
Type: Cat
Color: Gray, black, and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen at home on S Union and Park. She's had a slender build. Leppord like gray spots on her belly.
Madrid
Lost: 9/22/2017
ID: 7978
Name: Tyson
Type: Dog
Color: Reddish-brown with white chest, tri-colored face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Tyson is 7 years old, gentle, smart & a very good boy! A member of our family since he was a pup. We miss Tyson & he misses home. Please keep your eyes open for him, maybe a new dog in your neighborhood that could be Tyson? Any sightings or information please call! Thanks & Reward offered!
Madrid
Lost: 9/22/2017
ID: 7197
Name: Tyson
Type: Dog
Color: brown wht. chest, brown, wht. & black face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
7 yrs. old very friendly. Last seen 6 mi. North of Madrid. Any information could be helpful. Call of text 515-205-0691.
Madrid
Lost: 9/22/2017
ID: 7196
Name: Tyson
Type: Dog
Color: brown wht. chest, brown, wht. & black face
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
7 yrs. old very friendly. Last seen 6 mi. North of Madrid. Any information could be helpful. Call of text 515-205-0691.
Madrid
Lost: 9/22/2017
ID: 7173
Name: TYSON
Type: Dog
Color: brown, white chest & stomach, tri-colored face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
N. of Madrid Very friendly, deep bark 7 yrs. old Please help him find his way home, greatly missed. call 515-205-0691 Any info. will be appreciated!
Madrid
Lost: 9/22/2017
ID: 7123
Name: Tyson
Type: Dog
Color: Tri-colored reddish-brown, wht. chest, Blk. wht. brown face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
N. of Madrid, 290th St. & V Ave. Very friendly, deep bark, Service dog for family. Any info. would be appreciated!
Madrid
Lost: 9/22/2017
ID: 7117
Name: Tyson
Type: Dog
Color: Reddish-brown, face is tri-colored
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen 6 mi. N. of Madrid, Iowa. Very friendly, happy boy w/deep voice. Please help him find his way home. Family member, missed.
Des Moines - South
Lost: 9/22/2017
ID: 6878
Name: Princess has been found but I don’t know how to delete this post
Type: Cat
Color: Gray, black, and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She has leopard spots on her belly that are gray and black triangle / diamonds on her tail. She has a slender build.
Pleasant Plain
Lost: 9/21/2017
ID: 7604
Name: Chuck
Type: Dog
Color: Silver grey tan
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
3:56 pm on 9-21-17 He is very shy and timid, hates car rides.
Pleasant Plain
Lost: 9/21/2017
ID: 7244
Name: Chuck
Type: Dog
Color: grey tan white
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
Midway st and penn Pleasant plain Iowa. Ice blue eyes, Tan coloring around eyes. Is skittish of people. Doesn't like car rides. Will hide and pretend you aren't there. IS NOT AGGRESSIVE. Probably won't come when called.
Des Moines - West
Lost: 9/21/2017
ID: 6945
Name: Baby girl
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
09/28/2017 across the street in a neighbors bushes
Des Moines - South
Lost: 9/21/2017
ID: 6893
Name: Leonardo
Type: Cat
Color: Orange Tabby with white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
200 block of E. Jackson Ave
Des Moines - South
Lost: 9/21/2017
ID: 6863
Name: Kyia(key-uh)
Type: Cat
Color: Brown and Tan Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She must have snuck out when a door was open. Did not notice her missing, she likes to hide.
Colfax
Lost: 9/21/2017
ID: 6862
Name: Koda
Type: Dog
Color: Brown
Breed: Shar Pei
Gender: Male
Fixed: Unknown
Age: Young
He broke off his chain we think early in the morning and haven’t been back since WE HAVE A CASH REWARD IF FOUND!!! He’s our baby and we hope he’s okay.
Des Moines - South
Lost: 9/21/2017
ID: 6853
Name:
Type: Dog
Color: 1 black & brown & 1 tan
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Running in Pioneer park & my yard for 2 day's