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>='1565568000')) ORDER BY pm1.meta_value DESC, post_date DESC
Waukee
Found: 6/4/2019
ID: 11513
Name:
Type: Cat
Color: Brown gray black tail
Breed: Maine Coon
Gender: Unknown
Fixed: Unknown
Age: Young
11:45pm, meowing outside our sliding door. Have some food, tried to go to her/him but wouldn’t let me get close enough. I have more pics
Des Moines - South
Found: 6/3/2019
ID: 11501
Name: Mia
Type: Cat
Color: Tan, brown & white
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Baby
Found!!!
Des Moines - South
Found: 6/3/2019
ID: 11498
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
I think somebody on this street called the ARL so I would try there first.
Des Moines - East
Found: 6/2/2019
ID: 11503
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - East
Found: 6/2/2019
ID: 11494
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Just found her wondering in my yard! Super friendly!
Des Moines - South
Found: 6/2/2019
ID: 11492
Name:
Type: Dog
Color: Red and white
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Found: 6/1/2019
ID: 11488
Name: Wanda
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Urbandale area
West Des Moines
Found: 6/1/2019
ID: 11487
Name: Oreo
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Motel 6. Oreo has been found. Thank you everyone for the help!
Des Moines - Central
Found: 6/1/2019
ID: 11478
Name:
Type: Dog
Color: Black and brown
Breed: Alaskan Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
Two different color eyes
Des Moines - Central
Found: 5/29/2019
ID: 11464
Name:
Type: Cat
Color: Gray white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Young
Friendly. No collar. Been hanging around neighborhood the past few days.
Ames
Found: 5/29/2019
ID: 11462
Name: Unknown
Type: Cat
Color: Tan/gray and white tabby
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Found in North Ames. Will be adopted on 6/5 if no one comes forward with proof-of-ownership.
Des Moines - East
Found: 5/29/2019
ID: 11458
Name: Tucker
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
He’s been found!
Des Moines - East
Found: 5/29/2019
ID: 11456
Name: Tucker
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on 14th and university
Urbandale
Found: 5/29/2019
ID: 11452
Name: Jesse
Type: Cat
Color: Buff tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
Found in the 6500 block of Urbandale.
Urbandale
Found: 5/28/2019
ID: 11467
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Very sweet loving little boy showed up at 147th and Meredith after terrible storms. Used to being inside with lots of attention
Ames
Found: 5/28/2019
ID: 11449
Name:
Type: Cat
Color: Black and White
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
8:00 pm 05/28/19 Believed to be a female, but could be a neutered male. Maybe one year old. No collar. Tame, but cautious, won't be petted, but will stay close to eat. Seems underfed, not aggressive.
Ames
Found: 5/28/2019
ID: 11448
Name:
Type: Cat
Color: Black and White
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
8:00 pm 05/28/19 Believed to be a female. Maybe one year old. No collar. Tame, but cautious, won't be petted, but will stay close to eat.
West Des Moines
Found: 5/28/2019
ID: 11447
Name:
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on 8000 block of Mill Civic Pkwy
West Des Moines
Found: 5/28/2019
ID: 11446
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found on 1200 block of 64th St.
West Des Moines
Found: 5/26/2019
ID: 11432
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - South
Found: 5/26/2019
ID: 11427
Name: unknown
Type: Dog
Color: Black, brown and tan
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
Found dragging stake and leash down SW 16th St.
Urbandale
Found: 5/25/2019
ID: 11422
Name: Unknown
Type: Dog
Color: Brown and White
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Urbandale area
Des Moines - Central
Found: 5/24/2019
ID: 11418
Name: Unknown
Type: Dog
Color: Black and white
Breed: Spaniel American Cocker
Gender: Female
Fixed: Unknown
Age: Senior
She was found around 39th and Douglas and is now at 48th and Urbandale. She is very sweet and in good care until we find her owner(s)!
Des Moines - North
Found: 5/24/2019
ID: 11417
Name:
Type: Dog
Color:
Breed: Boxer
Gender: Unknown
Fixed: Unknown
Age: Baby
West Des Moines
Found: 5/24/2019
ID: 11412
Name:
Type: Cat
Color: gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
300 block of 34th Street