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 = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 3/19/2021
ID: 16241
Name:
Type: Dog
Color: Tan and white
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
Found on Beaver Ave and Aurora Ave this morning. Was able to get a leash on him and a lady in the neighborhood is keeping him at her house. I have her contact info.
Urbandale
Found: 3/17/2021
ID: 16235
Name:
Type: Dog
Color: Brown brindle and white
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Adult
4565 86th St
Urbandale
Found: 3/16/2021
ID: 16230
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Mother with kittens
West Des Moines
Found: 3/15/2021
ID: 16228
Name: Unknown
Type: Cat
Color: Black/White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 3/14/2021
ID: 16322
Name:
Type: Cat
Color: orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
reposting - Found in alley Des Moines, not microchipped, not neutered, ear mites and fleas at time of found; has all claws. Treated for fleas and ear mites, now is neutered and has all vaccinations/tests.
Urbandale
Found: 3/14/2021
ID: 16224
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/14/2021
ID: 16223
Name: Unknown
Type: Dog
Color: White and Orange
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young
Alleman
Found: 3/13/2021
ID: 16212
Name: Unknown
Type: Cat
Color: Grey and white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
In the garage to keep safe.
Alleman
Found: 3/13/2021
ID: 16211
Name: Unknown
Type: Cat
Color: Grey and white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
In the garage to keep safe.
West Des Moines
Found: 3/13/2021
ID: 16209
Name:
Type: Dog
Color: brown and white
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
Wild Rose Park, 6801 Cody Dr
West Des Moines
Found: 3/13/2021
ID: 16208
Name:
Type: Cat
Color: black, orange and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
1041 Gypsum Dr
Waterloo
Found: 3/12/2021
ID: 16206
Name:
Type: Cat
Color: Gray/Brown Tabby
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/12/2021
ID: 16199
Name:
Type: Dog
Color: Gray and Light Brown
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - North
Found: 3/12/2021
ID: 16196
Name: Leroy
Type: Dog
Color: Black with brown tail and white markings
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Edit: He was picked up by the ARL and is home safe. Was in the backyard around 11 pm and missing this am. Very friendly. Merle hay area
Ankeny
Found: 3/11/2021
ID: 16195
Name:
Type: Cat
Color: orange
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
West Des Moines
Found: 3/11/2021
ID: 16187
Name:
Type: Dog
Color: Grey
Breed: Schnauzer Miniature
Gender: Unknown
Fixed: Unknown
Age: Senior
Des Moines - South
Found: 3/10/2021
ID: 16200
Name: Princess
Type: Dog
Color: Grey
Breed: Staffordshire Bull Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
Was found and taking in by a dog owner and is not reunited with her family
Ankeny
Found: 3/10/2021
ID: 16184
Name:
Type: Cat
Color:
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 3/10/2021
ID: 16180
Name: Black Kitty
Type: Cat
Color: Black, orange, white
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Senior
Elkhart
Found: 3/10/2021
ID: 16179
Name: Unkn
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
I Sent him for safe keeping to the ARL. Hoping he makes his way home!! Sweet boy!!
Des Moines - North
Found: 3/10/2021
ID: 16178
Name:
Type: Cat
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
He came to our home this morning. He's very vocal and we are in the area of 57 college ave. Right off of meral hey
Des Moines - North
Found: 3/10/2021
ID: 16172
Name: Jazz
Type: Dog
Color: Black/tan
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Neutered
Age: Senior
West Des Moines
Found: 3/9/2021
ID: 16170
Name: Jazz
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Urbandale
Found: 3/9/2021
ID: 16167
Name: Unknown
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Found: 3/8/2021
ID: 16157
Name: Rufus
Type: Dog
Color: Cream
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Adult