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>='1594166400')) ORDER BY pm1.meta_value DESC, post_date DESC
Polk City
Lost: 5/8/2020
ID: 13969
Name:
Type: Cat
Color: Black and white
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
721 Phillips Street in Polk City
Des Moines - East
Lost: 5/8/2020
ID: 13965
Name: Archie
Type: Cat
Color: Black with white piece under neck -
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in home - somehow must of darted out the door - he is real friendly - sneezes all the time - small - cuddly - his mamma misses him.. E32nd and Aurora - Norwoodville area - Daughter got from the ARL - microchipped - not sure if info is updated -
Des Moines - East
Lost: 5/8/2020
ID: 13964
Name:
Type: Cat
Color: White,Carmel,black
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 5/8/2020
ID: 13949
Name: Adri
Type: Dog
Color: White
Breed: Maltipoo
Gender: Unknown
Fixed: Unknown
Age: Adult
North side near North Highschool
Des Moines - North
Lost: 5/8/2020
ID: 13942
Name: Duchess
Type: Cat
Color: Gray/Black
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 5/8/2020
ID: 13932
Name: Makaveli
Type: Dog
Color: Tan with black on his face
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
He is a mini pit very friendly loves food lost him around e 14th and and Cleveland
Ankeny
Lost: 5/6/2020
ID: 14322
Name: The Queen
Type: Cat
Color: light gray/ black
Breed: Tonkinese
Gender: Female
Fixed: Neutered
Age: Adult
The Queen, who is 3 years old, was last seen on May 6th. She is not technically a Tonkinese but looks very similar to one. She has a notch in her left ear to show she is spayed since she was an alley cat when I found her and didn't know if she would stick around because she is so skiddish. She has her nails and is not chipped. She is a surviver and has been gone for up to 4 weeks before and numerous 2 week durations as well. She would never come up to anyone she doesn't know. If you have seen her or know of her where abouts please contact me.
North Liberty
Lost: 5/6/2020
ID: 13939
Name: Fran
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen for sure 5/6 11:30am, possible sighting 5/8 7:30am. Friendly, but likely scared.
Des Moines - East
Lost: 5/6/2020
ID: 13919
Name: Jake/ chubby
Type: Dog
Color: Tan
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Near 34th and Kinsey near Stowe elementary in no outlet area
Monroe
Lost: 5/5/2020
ID: 13984
Name: Fish
Type: Cat
Color: Black, Orange, White Calico
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Adult
Last seen in Monroe, Very sweet, worried someone took her in thinking she was a stray
Des Moines - East
Lost: 5/5/2020
ID: 13927
Name: Winchester goes by Winnie
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
He comes when you whistle an ask if he wants to eat he might growl a lot but he's harmless
Des Moines - East
Lost: 5/5/2020
ID: 13912
Name: Luna
Type: Dog
Color: Black and brown markings
Breed: Rottweiler
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen around the northeast part of des moines by porters hardware off of e 40th st and e madison. Offering a reward if returned safely.
Mystic
Lost: 5/4/2020
ID: 13928
Name: Jaxsin “Bubba”
Type: Dog
Color: White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Bondurant
Lost: 5/4/2020
ID: 13921
Name: Elvis Purrrsley
Type: Cat
Color: all black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Baby
He was last seen on Kadin trail in Bondurant hes a little shy but super friendly will usually come to his name and the sound of your fingers rubbing together
Waukee
Lost: 5/4/2020
ID: 13907
Name: Mitts
Type: Cat
Color: Black/white paws
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
West Waukee just a couple blocks off the triangle
Denver
Lost: 5/4/2020
ID: 13906
Name: Milo
Type: Dog
Color: Brown, white, & black
Breed: Chinese Crested Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Milo was last seen at the intersection of E Gresham and Schenk Rd outside of Denver
Des Moines - East
Lost: 5/4/2020
ID: 13905
Name:
Type: Cat
Color: simease colored with white blaze down her face
Breed: Snowshoe
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around noon but didn't know she was missing until 6.
Des Moines - Central
Lost: 5/4/2020
ID: 13904
Name: Lucky
Type: Dog
Color: light/dark brown
Breed: Pomeranian
Gender: Unknown
Fixed: Not Neutered
Age: Young
last seen around noon by the grubb YMCA on 11th street. she also might bark, but very friendly
Des Moines - Central
Lost: 5/4/2020
ID: 13903
Name: Lucky
Type: Dog
Color: dark/light brown
Breed: Pomeranian
Gender: Female
Fixed: Not Neutered
Age: Young
near Grubb YMCA on 11th street in Des Moines
Knoxville
Lost: 5/3/2020
ID: 13918
Name: Penny
Type: Dog
Color: Brown and White
Breed: Rat Terrier
Gender: Female
Fixed: Neutered
Age: Young
about a mile from the Knoxville, IA Sportsmans Club. She is very friendly, and will come when you call her name.
Rathbun
Lost: 5/3/2020
ID: 13915
Name: Zora
Type: Cat
Color: All white - no other color.
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at the Dam Site campground late Saturday night. Campground across from the Marina. She is declawed and somewhat timid. Microchipped.
Altoona
Lost: 5/3/2020
ID: 13913
Name: Bob
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 5/3/2020
ID: 13910
Name: Mitt
Type: Cat
Color: White and gray
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Greenwood Park/Pond area
Des Moines - Central
Lost: 5/3/2020
ID: 13902
Name: Harley
Type: Cat
Color: Black and brown
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
5/3/2020 skittish, has claws
Des Moines - Central
Lost: 5/3/2020
ID: 13896
Name: Nala
Type: Cat
Color: light tan
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Not Neutered
Age: Baby