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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 3/7/2021
ID: 16154
Name: Princess
Type: Dog
Color: Grey (top) white large spot ( bottom)
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Unknown
Age: Adult
19th and Pleasant Sherman Hills Historic District area, NW of Des Moines, IA
Des Moines - North
Lost: 3/7/2021
ID: 16151
Name: Hunny
Type: Dog
Color: Yellow
Breed: Golden Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Ames
Lost: 3/6/2021
ID: 16334
Name: Sammie
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
We live in the country west of Ames. He’s an outside cat. Last seen on camera about 5:30 am. May be shy. Friendly.
Le Mars
Lost: 3/6/2021
ID: 16152
Name: Bean
Type: Dog
Color: Reds and browns
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Young
Heading north to ethanol plant, them sounds like went west
Des Moines - East
Lost: 3/6/2021
ID: 16149
Name: Pepper
Type: Dog
Color: grey and white
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Adult
1340 idaho st
Des Moines - Central
Lost: 3/6/2021
ID: 16146
Name: Deangelo
Type: Cat
Color: Gray/white stripes
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Ingersoll neighborhood 29th and High
Des Moines - East
Lost: 3/6/2021
ID: 16139
Name: Canelo
Type: Dog
Color: Gold
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen outside of my house going to the bathroom and disappeared while i used the bathroom
Bondurant
Lost: 3/6/2021
ID: 16136
Name: Evie
Type: Cat
Color:
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Senior
Last night
Waterloo
Lost: 3/6/2021
ID: 16135
Name: Breck
Type: Dog
Color: White
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on starlite blvd in Waterloo.
Des Moines - East
Lost: 3/5/2021
ID: 16132
Name: Aries
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Behind Aldi on E 14th Last seen at radio city motor park
Des Moines - North
Lost: 3/5/2021
ID: 16131
Name: Sherman
Type: Dog
Color: Black and white
Breed: Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Between Cornell St and Hull Ave
Des Moines - Central
Lost: 3/4/2021
ID: 16129
Name: Kozie
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Unknown
Fixed: Unknown
Age: Adult
Kozie is a Great Pyrenees MIX, her snout and head have coloring.
Ankeny
Lost: 3/3/2021
ID: 16161
Name: Fuzzy
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She has front claws, small white patch on chest.
Ames
Lost: 3/3/2021
ID: 16127
Name: Tano
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
508 Lynn she was last seen before she ran out of the house. She is 6 months old, and loves ham. She is shy. Please contact 641-870-1199 or me if found or spotted.
West Des Moines
Lost: 3/3/2021
ID: 16126
Name: Kiki
Type: Cat
Color: Light Brown
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
West Des Moines
Lost: 3/3/2021
ID: 16125
Name: Kiki
Type: Cat
Color: Light Brown
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 3/3/2021
ID: 16118
Name: Osiris Mau
Type: Cat
Color: White & Orange
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at Elmcrest Apartments late in the night. 433 E. Philip St.
Des Moines - Central
Lost: 3/2/2021
ID: 16116
Name: S’mores
Type: Cat
Color:
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 3/2/2021
ID: 16115
Name: Cota
Type: Dog
Color: Black & White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by MCDONALD'S on SW 9th St.
Des Moines - South
Lost: 3/2/2021
ID: 16114
Name: Cota
Type: Dog
Color: Black & White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Baby
Cota was last seen by MCDonalfs on SW 9th st.
Ankeny
Lost: 3/2/2021
ID: 16113
Name: Orion
Type: Cat
Color: Orange Stripe
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Got out around 11 p.m. on March 2. The apartment is very close to I-35. There is a fence between the apartment complex and the interstate. Any leads would be appreciated. Thank you. Call or text 515-864-9121.
Des Moines - East
Lost: 3/2/2021
ID: 16111
Name: Goliath
Type: Cat
Color: Grey
Breed: British Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 3/2/2021
ID: 16110
Name: Goliath
Type: Cat
Color: Grey
Breed: British Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 3/2/2021
ID: 16107
Name: Sativa
Type: Dog
Color: Black gray and brown
Breed: Hound
Gender: Male
Fixed: Not Neutered
Age: Adult
The evening 8215 Plaza Lane Des Moines Iowa the lady said she brought her to the ARL cuz we saw a post where somebody had found her you could call me at 515-443-2599
Ankeny
Lost: 3/2/2021
ID: 16103
Name: Snoop
Type: Dog
Color: Black and rust
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Adult
Northwest elementary school Ankeny