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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
Cumming
Found: 8/1/2020
ID: 14597
Name: Unknown
Type: Dog
Color: White and tan
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - East
Found: 7/31/2020
ID: 14593
Name:
Type: Dog
Color: White
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Senior
West Des Moines
Found: 7/31/2020
ID: 14590
Name:
Type: Dog
Color: White and yellow
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 7/30/2020
ID: 14589
Name:
Type: Cat
Color: Gray
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Found by county line road in greenfield plaza. Not declawed.
Urbandale
Found: 7/30/2020
ID: 14581
Name:
Type: Dog
Color: Brown black and white
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Young
Milo
Found: 7/29/2020
ID: 14580
Name:
Type: Cat
Color: Tortise
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Has been in the area a couple weeks. Not sure if she is lost or was dumped. I will adopt if nobody claims her.
Des Moines - Central
Found: 7/29/2020
ID: 14579
Name:
Type: Bird
Color: White
Breed: Pigeon
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - Central
Found: 7/29/2020
ID: 14573
Name:
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Found him walking through the yard at 1529 56th st Des Moines. He is lost.
Urbandale
Found: 7/29/2020
ID: 14571
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - North
Found: 7/27/2020
ID: 14567
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Saylor Township area, NW 52nd Ave & NW 6th Dr. This sweet girl came up to us , while we were having a little bonfire tonight. She is extremely friendly and lovey. Jumped right in my lap. She is very thin, has burrs stuck in her fur and has fleas. We gave her food and water, seemed like she hadn't eaten in a while. Appears to have been loved by a human at some point, so not sure if someone is looking for her or if she was dumped.
West Des Moines
Found: 7/27/2020
ID: 14566
Name:
Type: Cat
Color: Orange and white
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
29th and 31st Street in WDM
Urbandale
Found: 7/27/2020
ID: 14565
Name:
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 7/25/2020
ID: 14558
Name:
Type: Cat
Color: Brown tabby with white face and feet
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
701 Knolls
West Des Moines
Found: 7/25/2020
ID: 14555
Name:
Type: Dog
Color: Brown/Black Brindle with White
Breed: Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
500 block of Ashworth Road
Clive
Found: 7/25/2020
ID: 14553
Name:
Type: Cat
Color:
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Baby
Found around 165th in Clive
Clive
Found: 7/24/2020
ID: 14556
Name:
Type: Cat
Color: Orange and White Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Ankeny
Found: 7/24/2020
ID: 14548
Name:
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Found not far off of NE 36th St in north Ankeny near the golf course.
West Des Moines
Found: 7/24/2020
ID: 14545
Name: Nitro
Type: Dog
Color: black and white
Breed: Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Found: 7/23/2020
ID: 14542
Name: Archer
Type: Cat
Color: Brown tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
3900 block 69th street
North Liberty
Found: 7/23/2020
ID: 14540
Name:
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
This sweet kitty showed up at my door near Jones/Cherry in North Liberty. She(?) is all black with white whiskers. No collar. Skinny but otherwise seems well. Very affectionate. She let me pick her up and is currently scarfing down food in my garage.
Des Moines - North
Found: 7/22/2020
ID: 14538
Name:
Type: Cat
Color: Blonde/Orange & white
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
Around NE 52nd Ave & NE 14th st.
Urbandale
Found: 7/22/2020
ID: 14535
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
It was sitting on my front porch. Put out some food for it. Hiding in my bushes right now.
Des Moines - North
Found: 7/21/2020
ID: 14529
Name:
Type: Dog
Color: Black and White
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
Update: ARL has pickuped the dog and knows that is microchipped and will be contacting the owner. Found between Hickman and Urbandale on 53rd Street
West Des Moines
Found: 7/20/2020
ID: 14523
Name:
Type: Cat
Color: Orange and white
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Urbandale
Found: 7/18/2020
ID: 14516
Name:
Type: Dog
Color: Black, white and tan
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Senior
Homemakers parking lot