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>='1568505600')) ORDER BY pm1.meta_value DESC, post_date DESC
Johnston
Found: 6/12/2015
ID: 749
Name:
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
We found him running on a busy road in northern Johnston, close to Camp Dodge.
Des Moines - Central
Found: 6/12/2015
ID: 736
Name:
Type: Dog
Color: grey and white
Breed: Alaskan Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - East
Found: 6/10/2015
ID: 728
Name: stash
Type: Cat
Color:
Breed: Alaskan Husky
Gender: Female
Fixed: Neutered
Age: Adult
Found her today!!! She is back home with us once again!!!! She has lost all her weight she was 12lbs now she weighs 3!!! We r glad she is safe and back home!!!!
Des Moines - West
Found: 6/2/2015
ID: 672
Name: Unknown
Type: Dog
Color: Auburn
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Baby
Found roaming front lawn at Roosevelt high school. Seems to have poor hearing and vision
Des Moines - North
Found: 6/1/2015
ID: 669
Name: Buddy
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Running loose at Prospect Park right off Hickman. Super friendly! Must be able to tell me his body color and whether he had collar and what is on the collar!
Des Moines - North
Found: 6/1/2015
ID: 668
Name: Buddy
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Running loose at Prospect Park right off Hickman. Super friendly! Must be able to tell me his body color and whether he had collar and what is on the collar!
Ankeny
Found: 6/1/2015
ID: 664
Name: Sarabi
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Not declawed. Terrified of being outside. Answers to Sarabi and Robby.
Des Moines - Central
Found: 5/27/2015
ID: 634
Name: ?
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
Found in Beverdale, very nice.
Des Moines - Central
Found: 5/27/2015
ID: 633
Name:
Type: Dog
Color: white
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
found in Beverdale area.
Des Moines - East
Found: 5/25/2015
ID: 631
Name:
Type: Cat
Color: White with Calico ears, spot on side, tail is grey stripped
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Young
We are trying to catch this cat and take to the ARL on E 14th St. As soon as we catch her she will be there.
Des Moines - South
Found: 5/25/2015
ID: 600
Name:
Type: Dog
Color: Tan and white
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Adult
Sw 5th pl. Very friendly and not scared at all. Being taken care of.
Ames
Found: 5/23/2015
ID: 606
Name:
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Found near Onion Creek Farm in NW Ames. Vocal and skittish. Call 701 317 2940 to identify.
Carlisle
Found: 5/16/2015
ID: 551
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
This dog came to our house last night.
Carlisle
Found: 5/16/2015
ID: 549
Name:
Type: Dog
Color: Brown and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
Winterset
Found: 5/11/2015
ID: 524
Name:
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
Ankeny
Found: 5/6/2015
ID: 488
Name: William
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Johnston
Found: 5/6/2015
ID: 482
Name: Unknown
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
I have the cat in a crate to protect it. I have an acreage and a very large raccoon was already chasing the cat when I found it. The cat is very scared of people and appears to be in good health.
Des Moines - South
Found: 5/5/2015
ID: 477
Name: Unknown (but we’ve been calling him Zorro)
Type: Cat
Color: White with grey spots & a grey tail
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Found him on our back porch last night. He is front declawed. He is very friendly and a bit of a social butterfly. He will NOT stay still long enough for a picture.
Des Moines - North
Found: 5/2/2015
ID: 460
Name:
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - East
Found: 5/1/2015
ID: 438
Name:
Type: Dog
Color: black
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Adult
friendly and in good health
Des Moines - Central
Found: 4/27/2015
ID: 417
Name:
Type: Dog
Color:
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
Found him wondering.in the am off of martin luther king play
Des Moines - North
Found: 4/27/2015
ID: 411
Name: Rocco
Type: Dog
Color: dark red
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Rocco has been found and returned home. Thanks for this great resource>
Muscatine
Found: 4/26/2015
ID: 405
Name:
Type: Dog
Color: red
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Grimes
Found: 4/23/2015
ID: 395
Name:
Type: Cat
Color:
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Found: 4/21/2015
ID: 383
Name: unknown
Type: Dog
Color: brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
we found him on bell avenue on the south side by grays lake. he may be a pit or shepherd mix?? he is so sweet, friendly.