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>='1573084800')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - North
Found: 3/17/2015
ID: 105
Name: Unknown
Type: Dog
Color: Chocolate Cocker Spaniel
Breed: Cocker Spaniel
Gender: Female
Fixed: Unknown
Age: Young
Found at 67th and Urbandale Avenue
West Des Moines
Found: 3/15/2015
ID: 106
Name: Spirit
Type: Dog
Color: Brown and White
Breed: Papillon
Gender: Male
Fixed: Neutered
Age: Adult
Thank You!!!
Des Moines - East
Found: 3/11/2015
ID: 65
Name:
Type: Dog
Color: yellow
Breed: Papillon
Gender: Female
Fixed: Unknown
Age: Young
Owner has been found.
Davenport
Found: 3/7/2015
ID: 48
Name: Rags
Type: Dog
Color: Light brown/Tan/Cream
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Adult
Small Yorkie that probably is no longer brown but really dirty and matted. He ran out and maybe located around Scott, Gaines or even Harrison streets in Davenport, IA
Altoona
Found: 3/4/2015
ID: 34
Name: Vince
Type: Dog
Color: Black and White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Vince has been found is now at home.
Des Moines - South
Found: 3/3/2015
ID: 31
Name: unknown
Type: Dog
Color: black and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Adult
Found by willy call 515 657 3411
Des Moines - East
Found: 3/2/2015
ID: 27
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Baby
NE 52nd ct Des Moines. Deleware Township