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
Ankeny
Found: 8/24/2017
ID: 6590
Name: Hope
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Went to call in the other two cats and she was there on the porch. She found her way home.
Ankeny
Found: 8/24/2017
ID: 6589
Name: Hope
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
We went to call for the other two cats to come in and she was there at the door.
Ankeny
Found: 8/24/2017
ID: 6587
Name: Unknown
Type: Cat
Color: Grey/black/tan tiger striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Came up to our deck door at our house in Ankeny. Hesitant at first. After feeding became super affectionate. Vet did not find a microchip when scanned.
Des Moines - South
Found: 8/23/2017
ID: 6575
Name: Dakota
Type: Dog
Color: White with dark ears
Breed: Great Pyrenees
Gender: Female
Fixed: Neutered
Age: Senior
She came back this morning. Thank you all.
Bondurant
Found: 8/22/2017
ID: 6559
Name:
Type: Cat
Color: Black and orange
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
Very sweet, doesn't like strange cats. Was very hungry when we found her
Grimes
Found: 8/22/2017
ID: 6554
Name: King
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Found: 8/21/2017
ID: 6565
Name:
Type: Dog
Color: Yellow
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Young
See photo for comments
Ankeny
Found: 8/21/2017
ID: 6547
Name:
Type: Dog
Color:
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Young
Found along Oralabor, no collar
Des Moines - East
Found: 8/18/2017
ID: 6511
Name:
Type: Dog
Color: Brown white black
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
If you know anything about this dog or the dog is yours please text me describing the collar
West Des Moines
Found: 8/15/2017
ID: 6489
Name:
Type: Dog
Color: Black with White Chest
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Senior
I believe this male dog is older as he is a bit slow and has grey on his face. He is very well mannered and gentle. He looks like he is around 70lbs. I will try to post a photo soon.
Ankeny
Found: 8/14/2017
ID: 6775
Name:
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Young
She's front declawed and very sweet!
Des Moines - South
Found: 8/14/2017
ID: 6487
Name: Peanut
Type: Dog
Color: Tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
Had tag with rabies info,that's how I found out hisname. Vet had no current contact information.
Norwalk
Found: 8/14/2017
ID: 6482
Name:
Type: Cat
Color: Black
Breed: Chihuahua Long Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
Idk if this is a stray or ferrel but if you think it's your cat please let me know
Urbandale
Found: 8/14/2017
ID: 6478
Name: Ivy
Type: Dog
Color: Brown and White
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
Last seen in our yard at 8106 Madison Ave around 4:30. Had just gotten home from a walk and she acted tired so we came home. Guess she still had adventures in mind...
Norwalk
Found: 8/14/2017
ID: 6476
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
There is a cat In my garage and it is black and invetween the kitten and adult age if you think this is your cat please contact me
Des Moines - West
Found: 8/13/2017
ID: 6485
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly and vocal. Follows people. Climbs trees
Des Moines - South
Found: 8/13/2017
ID: 6474
Name: Owner Found – Joey
Type: Dog
Color: black/w gray
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Senior
REUNITED WITH OWNER Found in the 3000 block of Deerpath Court. Contact Dotty at 515-491-5323.
Des Moines - Central
Found: 8/12/2017
ID: 6465
Name: Zane
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
46th and Holcomb
West Des Moines
Found: 8/12/2017
ID: 6462
Name: Maxi
Type: Cat
Color: Brown/light colors
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
28th st and ashworth in west Des Moines
Des Moines - Central
Found: 8/11/2017
ID: 6458
Name:
Type: Cat
Color: Tabby with white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Found with black brother.
Des Moines - Central
Found: 8/11/2017
ID: 6457
Name:
Type: Cat
Color: Tabby with white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Found with black brother.
Des Moines - Central
Found: 8/11/2017
ID: 6456
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Found with tabby and white brother outside.
Des Moines - East
Found: 8/11/2017
ID: 6453
Name:
Type: Dog
Color:
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
E. 22nd & grand
Des Moines - East
Found: 8/11/2017
ID: 6452
Name:
Type: Dog
Color:
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
E. 22nd & grand
Des Moines - Central
Found: 8/11/2017
ID: 6450
Name:
Type: Dog
Color: Blond and Black
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Adult
Found on Hickman by Broadlawns