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>='1610755200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 11/15/2020
ID: 15483
Name:
Type: Cat
Color: Black white
Breed:
Gender: Male
Fixed: Unknown
Age: Young
I found her On my front stoop. Brought her or him in to warm up. My dogs don’t like her so I had to put her back outside for her safety.
Altoona
Lost: 11/14/2020
ID: 15499
Name: Milo
Type: Cat
Color: Orange/white
Breed: Manx
Gender: Male
Fixed: Not Neutered
Age: Young
Milo is a Manx kitten, he has no tail. He went missing in Altoona Iowa at the kading townhomes (Boston lane sw)
Des Moines - South
Lost: 11/14/2020
ID: 15494
Name: Kitty paws
Type: Cat
Color: Grey stripe
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is very friendly and vocal. Loves food and is a fat boy.
Des Moines - South
Lost: 11/14/2020
ID: 15485
Name: Weezy
Type: Dog
Color: Black/grey muzzle
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Senior
He is very friendly towards people but should be kept away from other dogs
Norway
Lost: 11/13/2020
ID: 15479
Name: Champ
Type: Dog
Color: Mostly brown with some black on back and white on face
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Last seen on Main Street in Norway Iowa yesterday around 3 pm.
Des Moines - North
Lost: 11/13/2020
ID: 15478
Name: Ike
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
2nd Avenue firestone area
Dubuque
Lost: 11/13/2020
ID: 15474
Name: Cheech
Type: Cat
Color: Dark brown and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in alpine park, come to his name and treats
Des Moines - East
Lost: 11/12/2020
ID: 15518
Name: Lucy Kimmel
Type: Cat
Color: White and gray with some black marks
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Carlisle
Lost: 11/12/2020
ID: 15471
Name: Bosey
Type: Cat
Color: Black
Breed: Bombay
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on Bellflower Dr around 10 PM or so, maybe 8. Short black hair, has a couple bald spots between eyes & ears. very friendly and lovey.
Ankeny
Lost: 11/12/2020
ID: 15468
Name: T-Bone
Type: Dog
Color: White and Tan
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Young
Last seen on SE belmont Dr in ankeny. Very sweet and loving.
Ankeny
Lost: 11/12/2020
ID: 15467
Name: Tbone
Type: Dog
Color: Brown and white
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Adult
Ran out of house SE BELMONT DRIVE
Ottumwa
Lost: 11/12/2020
ID: 15453
Name: Gracie
Type: Cat
Color: White black orange calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Originally missing on 8/4/20 but want to keep her face out there. She is a “indoor wanna be outdoor” escapee....we believe she was captured and dumped on the north end of our town. We have a 500 dollar reward for her return, we obviously love her a lot. She’s a talker, friendly and pretty smart. We are hoping for a miracle!
Des Moines - Central
Lost: 11/11/2020
ID: 15540
Name: Blanket
Type: Cat
Color: Grey Tabby
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Drake neighborhood. Small amount of brown in left cornea and healed minor injury to ear.
Indianola
Lost: 11/11/2020
ID: 15495
Name: Luna
Type: Dog
Color: Tan
Breed: Black And Tan Coonhound
Gender: Female
Fixed: Neutered
Age: Young
She is very sweet and will come to her name. She has a white spot on her chest.
Ottumwa
Lost: 11/11/2020
ID: 15480
Name: Midnite
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Senior
He's is very old and friendly. Hard of hearing and has no teeth.
Ottumwa
Lost: 11/11/2020
ID: 15460
Name: Midnite
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Senior
He is an older dog . very nice and much loved . he has no teeth left . short hair at the moment but does grow long
Ottumwa
Lost: 11/11/2020
ID: 15459
Name: Midnite
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Senior
He is an older dog . very nice and much loved . he has no teeth left . short hair at the moment but does grow long
Ottumwa
Lost: 11/11/2020
ID: 15458
Name: Midnight
Type: Dog
Color: black
Breed: Pomeranian Standard
Gender: Male
Fixed: Unknown
Age: Adult
Missing family last seen on Davis street in ottumwa iowa Midnight is 13 years old well loved an super friendly help pass the word thanks for looking
Ackworth
Lost: 11/11/2020
ID: 15457
Name: Dixie
Type: Dog
Color:
Breed: Basset Hound
Gender: Female
Fixed: Not Applicable
Age: Young
Winterset
Lost: 11/11/2020
ID: 15455
Name: Raja
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Around the High School
Winterset
Lost: 11/11/2020
ID: 15454
Name: Raja
Type: Cat
Color: Black with brown tint
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Around High school in Winterset
Waterloo
Lost: 11/11/2020
ID: 15451
Name: Benji
Type: Dog
Color: Grey with black and white spots
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Young
Hope Martin park Waterloo Iowa
Dubuque
Lost: 11/11/2020
ID: 15448
Name: Gizmo
Type: Cat
Color: Grey black white
Breed: Dilute Calico
Gender: Unknown
Fixed: Not Applicable
Age: Baby
Has never been outside
Britt
Lost: 11/10/2020
ID: 15563
Name: Zippy
Type: Dog
Color: Grayish blackish whitieish
Breed: Terrier
Gender: Male
Fixed: Not Applicable
Age: Adult
Des Moines - East
Lost: 11/9/2020
ID: 15444
Name: Bandit
Type: Dog
Color: Black, white, and tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by the US bank and Perkins on Euclid