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: 9/28/2020
ID: 15078
Name: Boomer
Type: Dog
Color: Gray black
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Senior
He got out of the house at 25th and Maury about noon on the 28th either in Chesterfield or fairgrounds area
Runnells
Lost: 9/27/2020
ID: 15115
Name: Jewels (Julie) (Juju) Chip#981020025101310
Type: Cat
Color: Black -small wisp of wht on upper chest
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen SE 56th & 104th in Runnells, IA. She has thin hair in front of her ears with brown spots on her skin. Chubby girl. Has all claws.
Newton
Lost: 9/27/2020
ID: 15110
Name: Tiger
Type: Cat
Color: Gray and black
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Tiger is 11 years old he's gray and black with a striped tail he is declawed and fixed he is very friendly lost in Newton Iowa
Des Moines - Central
Lost: 9/27/2020
ID: 15099
Name: Francis
Type: Cat
Color: White with Orange spots
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Francis is an outside / inside cat so he roams around our property daily, always returning several times throughout the day. He has been missing for several days, he is not micro chipped and has no collar. He is close to 17 years old and meows very loudly!
Runnells
Lost: 9/27/2020
ID: 15094
Name: Julie
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Sunday afternoon
Ankeny
Lost: 9/27/2020
ID: 15074
Name:
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Found kitten outside of our home around 1007pm. SE Oak Ankeny. Kitten taken to ARL.
Ankeny
Lost: 9/27/2020
ID: 15069
Name: Mally
Type: Cat
Color: Brown/black tabby cat with white chest and white paws. Her right foot has a marking that resembles a heart
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 9/26/2020
ID: 15051
Name: Atlanta
Type: Dog
Color: grey, white, tan
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
He was in the care of my mom and someone stole him..
Bevington
Lost: 9/26/2020
ID: 15066
Name: Paisley
Type: Dog
Color: Grey w/ spots
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15065
Name: Gunner
Type: Dog
Color: Grey w/ spots
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15064
Name: Gunner
Type: Dog
Color: Grey w/ spots
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15063
Name: Louie
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Unknown
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15062
Name: Ranger
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15061
Name: Pinkie
Type: Dog
Color: Black
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15060
Name: Charlie Brown
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15059
Name: Lemon Drop
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Bevington
Lost: 9/26/2020
ID: 15058
Name: Hunter
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Baby
About 3 miles North of Bevington
Des Moines - Central
Lost: 9/26/2020
ID: 15055
Name: Tucc
Type: Dog
Color: light brown
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
He has unique tail see picture $500 reward
Des Moines - Central
Lost: 9/26/2020
ID: 15054
Name: Tucc
Type: Dog
Color: light brown
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
$500 reward
Des Moines - Central
Lost: 9/26/2020
ID: 15053
Name: Tucc
Type: Dog
Color: light brown
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - West
Lost: 9/26/2020
ID: 15052
Name: Balian
Type: Cat
Color: Brown Marbel
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the home in the evening of 9/25/20. He has no claws and is very friendly and loves to me petted. He has green eyes. He was last seen in between 56th-63rd street in a blue townhouse complex, Frisbee Park 50312.
Ankeny
Lost: 9/25/2020
ID: 15070
Name: Mally Owen
Type: Cat
Color: Brown with white chest, underbelly, and feet
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
She is microchipped
Altoona
Lost: 9/25/2020
ID: 15056
Name: grey
Type: Cat
Color: grey
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
missing the tip of her tail has a collar on with name and my phone number.
Des Moines - South
Lost: 9/24/2020
ID: 15578
Name: Kalena
Type: Dog
Color: White and Brown
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Applicable
Age: Young
She was last seen at 6808 Chaffee Road at the The Fort Living Apts. She was taken from my apt while I was at work. She is a Staffshire Terrior, 14 wks when went missing. It's been 2 months and I will not give up lookn for my baby girl. She is very friendly and is very much loved and missed. Anyone knowing of her whereabouts plz contact me at 515 689 5731 Reward to anyone who brings her home
Urbandale
Lost: 9/24/2020
ID: 15100
Name: Gabe
Type: Cat
Color: Orange and White Long hair
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
Long hair Very shy and sly. Likes to hide. Has a chip, Very small and light but may look larger because of long hair