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>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Found: 6/29/2018
ID: 8980
Name:
Type: Dog
Color: White
Breed: Maltese
Gender: Male
Fixed: Unknown
Age: Adult
We have him inside and are taking care of him until further notice. We found him on the corner of lacona Avenue and south union street.
Des Moines - West
Found: 6/26/2018
ID: 8959
Name:
Type: Dog
Color: Tan
Breed: Maltese
Gender: Male
Fixed: Unknown
Age: Adult
45th and Aurora
Des Moines - Central
Found: 6/25/2018
ID: 8952
Name: Unknown
Type: Cat
Color: Black and white: tux
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Young
Reposting with pics because I could not edit the original. Very friendly intact male cried outside our door to come in from the storm. Obviously well loved and cared for, just got clean bill of health from our vet but no microchip. Please email myjennaration@gmail.com. Will likely take him to furry friends later today if cannot find his owner.
Des Moines - Central
Found: 6/25/2018
ID: 8948
Name: Unknown
Type: Cat
Color: Tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Young
Crying outside our door in the rain. Hopped up on my lap and started purring. Very friendly and appears well cared for.
Cumberland
Found: 6/25/2018
ID: 8940
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
Today
Cumberland
Found: 6/25/2018
ID: 8938
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
Still in my yard
Des Moines - East
Found: 6/24/2018
ID: 8936
Name: Charlie
Type: Dog
Color: Brown/tan
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Charlie slipped out his collar around 10pm last night (Sunday) and escaped from our fence.
Des Moines - South
Found: 6/24/2018
ID: 8924
Name:
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Young
Very sweet. Is soft, so can't have been outside long. This is a busy street and I'm worried for its safety.
Des Moines - East
Found: 6/23/2018
ID: 8922
Name: Rocky and mila
Type: Dog
Color: Tan and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Carlisle
Found: 6/23/2018
ID: 8914
Name:
Type: Dog
Color: Black/silver
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Dog is at kyda koda in indianola.
Grimes
Found: 6/21/2018
ID: 8896
Name: Unknown
Type: Cat
Color: black and brown tiger with white
Breed: Australian Shepherd
Gender: Unknown
Fixed: Unknown
Age: Adult
This cat showed up at our house on the NE side of Grimes this morning and won't leave.
Ankeny
Found: 6/20/2018
ID: 8899
Name: Unknown
Type: Cat
Color: Orange
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
We found a mother tabby cat and her two young kittens living in our backyard. We live in the Westwinds area of Ankeny. The mother cat does not have a collar.
Des Moines - South
Found: 6/20/2018
ID: 8895
Name:
Type: Dog
Color: Tan and White
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Found off McKinley Ave, will hold onto him until we can find the owner.
Des Moines - South
Found: 6/20/2018
ID: 8894
Name:
Type: Dog
Color: White, Red
Breed: Brittany Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Bondurant
Found: 6/18/2018
ID: 10132
Name: Odie
Type: Dog
Color: Blonde
Breed: Labradoodle
Gender: Male
Fixed: Neutered
Age: Senior
West Des Moines
Found: 6/17/2018
ID: 8861
Name:
Type: Dog
Color: White, tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - West
Found: 6/17/2018
ID: 8860
Name: Unknown
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Found near 57th street and University Ave in Des Moines. He is very friendly and quiet, collar had no tags. We found him late at night and he was panting heavily so him took home to get water. We are only able to house him overnight and will be taking him to the shelter in the morning. If you believe this is your pet, contact and we will let you know which specific shelter we took him to.
Des Moines - North
Found: 6/15/2018
ID: 8871
Name: Spyro
Type: Dog
Color: multi
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
11th Place & Madison, Seneca
Des Moines - North
Found: 6/15/2018
ID: 8866
Name: Syro
Type: Dog
Color: multi
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
11th Place between Madison & Seneca
Des Moines - East
Found: 6/15/2018
ID: 8862
Name:
Type: Cat
Color: White and orange
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Young
Found near 42nd and Williams. Was stuck and a tree.
Shell Rock
Found: 6/14/2018
ID: 8941
Name: Unknown
Type: Dog
Color: chocolate/white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Is friendly, but rambunctious. Has not left our yard since showing up.
De Soto
Found: 6/14/2018
ID: 8840
Name: Lion
Type: Cat
Color: Yellow
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around 412 Madison St in Desoto, IA
Des Moines - East
Found: 6/10/2018
ID: 8801
Name:
Type: Dog
Color: Grey/white
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Adult
Ankeny
Found: 6/9/2018
ID: 8793
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Scooter was reunite with his family!
Newton
Found: 6/8/2018
ID: 8790
Name: Unknown
Type: Dog
Color: White
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Young
We found her walking around our yard at around noon today (8 June 2018).