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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Found: 6/18/2021
ID: 16984
Name:
Type: Dog
Color: cream
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
4118 66th St, 50322
Pleasant Hill
Found: 6/17/2021
ID: 16977
Name: Dozer
Type: Dog
Color: Black,brown,white
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Shimmied his way under the fence. He’s a rescue dog. Before we got him he lived in a cage his whole life. Almost 2 years old. Loved humans and our other dogs but skiddish around other animals. Has his hunting collar on but no tags on him. Been missing since 916am
Des Moines - North
Found: 6/16/2021
ID: 16971
Name: Erza
Type: Cat
Color: black, brown, white
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
near 3000 N union st. zip code 50316
Windsor Heights
Found: 6/16/2021
ID: 16968
Name:
Type: Bird
Color: Blue
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Baby
I’m feeding and watering the bird - please do call or text I’m worried a hawk will get him
West Des Moines
Found: 6/16/2021
ID: 16965
Name: Paka
Type: Cat
Color: Tortoise
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 6/15/2021
ID: 16967
Name: Sugar
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Neighborhood
West Des Moines
Found: 6/15/2021
ID: 16958
Name: Riley
Type: Dog
Color: White
Breed: West Highland White Terrier Westie
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 6/14/2021
ID: 16957
Name:
Type: Cat
Color: Orange/white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found by apartments at 35th/Ingersoll/Grand. Very friendly. Front declawed.
West Des Moines
Found: 6/14/2021
ID: 16954
Name:
Type: Cat
Color: black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Cobblestone Townhomes 50322
Des Moines - South
Found: 6/14/2021
ID: 16946
Name:
Type: Cat
Color: grey/black. tail tip white
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Walking around south union past week.
Des Moines - South
Found: 6/14/2021
ID: 16945
Name: unknown
Type: Cat
Color: grey, black/white stripes. Tail tip white.
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
walking around south union for the past week.
Des Moines - North
Found: 6/13/2021
ID: 16948
Name:
Type: Dog
Color: White
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Des Moines - South
Found: 6/12/2021
ID: 16938
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Found on the southside by pleasant view drive.
Des Moines - South
Found: 6/12/2021
ID: 16937
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Found on the southside by pleasant view drive.
West Des Moines
Found: 6/12/2021
ID: 16930
Name: Elsa
Type: Dog
Color: BROWN
Breed: Hound
Gender: Female
Fixed: Neutered
Age: Adult
604 33rd St, 50265
Clive
Found: 6/11/2021
ID: 16931
Name:
Type: Cat
Color: tortie
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
12834 Walnut st,
Des Moines - South
Found: 6/10/2021
ID: 16955
Name: Azrieal
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Update: (HES CAME HOME!!) Around the SW 9th and Porter area was last seen. If you please or holding him, please let him go to come home. If you’ve seen him please contact me! I really do miss him..
West Des Moines
Found: 6/10/2021
ID: 16922
Name:
Type: Cat
Color: grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Parking lot of Mills Fleet Farm
West Des Moines
Found: 6/10/2021
ID: 16918
Name:
Type: Dog
Color: Tan, Black and White
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Unknown
Age: Senior
6th and vine
West Des Moines
Found: 6/9/2021
ID: 16914
Name:
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
West Des Moines
Found: 6/9/2021
ID: 16904
Name:
Type: Dog
Color: Black
Breed: Newfoundland Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
1202 Office Park Rd
Des Moines - North
Found: 6/8/2021
ID: 16902
Name: Unknown
Type: Dog
Color: Tan & White & Black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Found on the corner of Forest Avenue and 3rd Street.
La Porte City
Found: 6/7/2021
ID: 16974
Name:
Type: Cat
Color: white and striped
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
found in rural LaPorte City, very friendly
Des Moines - Central
Found: 6/7/2021
ID: 16909
Name:
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
I tried to get her chip scanned, and the vet did not find one. They did say that if it is of a certain type, it may not show up in their system, so she could possibly still have a chip.
West Des Moines
Found: 6/7/2021
ID: 16903
Name:
Type: Cat
Color: Buff
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult