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
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
Des Moines - Central
Lost: 6/22/2019
ID: 11669
Name: Frank
Type: Cat
Color: Grey tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Frank was last seen in our yard on 19th St in between Center and Pleasant. He did not have his collar on and is not chipped. He is missing some teeth and has a white patch on his chest as well as white feet. He in indoor outdoor and spends most nights outside, but didn't come home the morning of 6/22. We miss him dearly. Please contact us if you've seen him!
West Des Moines
Lost: 6/22/2019
ID: 11658
Name: Simon
Type: Cat
Color: Gray brown , blue eyes
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Senior
Last seen at 1725 S 50th St in WDM. Escaped from townhouse.
Des Moines - Central
Lost: 6/22/2019
ID: 11653
Name: Greta
Type: Dog
Color: White and red
Breed: Cavalier King Charles Spaniel
Gender: Female
Fixed: Unknown
Age: Adult
Scared with storms.
Des Moines - Central
Lost: 6/22/2019
ID: 11652
Name: Turbee
Type: Cat
Color: Torti
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Friendly but very shy. Would likely go to anyone with some food. She is very thin as She is Hyperthyroid and needs daily medication.
Urbandale
Lost: 6/22/2019
ID: 11651
Name: Aceso
Type: Cat
Color: Brown, orange , and black
Breed: Himalayan
Gender: Unknown
Fixed: Neutered
Age: Adult
She can be shy. Lost around urbandale QT on 100th st.
Clive
Lost: 6/22/2019
ID: 11650
Name: Daisey
Type: Dog
Color: Golden
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Senior
I left for a haircut and came back and she had left. She is very calm and shy.
Ankeny
Lost: 6/22/2019
ID: 11649
Name: Kion
Type: Dog
Color: Silver/light brown
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Young
Prairie trail and State street
Burlington
Lost: 6/21/2019
ID: 11643
Name: I don’t know
Type: Dog
Color: Brown and black
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Baby
Two black and brown dogs found on street with collars don’t know owners no name or number on collars