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
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
Cumming
Lost: 9/24/2020
ID: 15041
Name: Maizy
Type: Dog
Color: Flashy brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Headed west on 140th toward Cumming highway
Cumming
Lost: 9/24/2020
ID: 15040
Name: Maizy
Type: Dog
Color: Flashy brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Headed west on 140th st in Madison county
Des Moines - South
Lost: 9/24/2020
ID: 15039
Name: E
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Se 5th and E Phillip
Des Moines - South
Lost: 9/24/2020
ID: 15038
Name: E
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
On e Phillip and 5th on the south side of des moines