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: 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.
Des Moines - South
Found: 4/18/2015
ID: 360
Name:
Type: Dog
Color: Brow and white
Breed: Cocker Spaniel
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Found: 4/16/2015
ID: 351
Name:
Type: Dog
Color: Dark brown with light brown and white
Breed: Beagle
Gender: Unknown
Fixed: Unknown
Age: Senior
Des Moines - South
Found: 4/13/2015
ID: 313
Name:
Type: Cat
Color:
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
I found this cat underneath my house on the south side today. I fed her and gave her water. She was very friendly and sat on my lap for awhile. I called animal control because her collar had cut into her leg very badly and she needed medical attention.
Des Moines - East
Found: 4/12/2015
ID: 308
Name:
Type: Dog
Color: Black
Breed: Great Dane
Gender: Female
Fixed: Unknown
Age: Senior
Found in the area of 42nd St & Easton Blvd.
Bondurant
Found: 4/12/2015
ID: 302
Name:
Type: Dog
Color:
Breed: Pekingese
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 4/6/2015
ID: 254
Name: Cheena
Type: Dog
Color: Light Brown
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
2300 block of Lyon st near fairgrounds
Keokuk
Found: 4/3/2015
ID: 220
Name: Luna
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - North
Found: 3/23/2015
ID: 160
Name:
Type: Dog
Color: White dog and brown dog
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Found these two dogs this afternoon 6 miles away at our in-laws. dirty and happy. DOGS ARE SMART!
Des Moines - North
Found: 3/22/2015
ID: 148
Name: Unknown
Type: Dog
Color: Chihuahua. White body with black spots. Brown and black face.
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
This sweet little guy showed up at our house at 6th Avenue and Franklin Avenue in Des Moines. He doesn't have a collar or tags but is very friendly and seems well fed.
Allison
Found: 3/18/2015
ID: 127
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young