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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Grimes
Found: 4/26/2016
ID: 2780
Name:
Type: Cat
Color: Orange/white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Front declawed
Altoona
Found: 4/26/2016
ID: 2770
Name:
Type: Dog
Color:
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Young
Woodburn
Found: 4/26/2016
ID: 2766
Name:
Type: Dog
Color: black
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Has collar. Give description of collar to claim him.
Des Moines - West
Found: 4/22/2016
ID: 2739
Name:
Type: Cat
Color: Brown stripes
Breed: Boston Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
FOUND: Cat with brown stripes found this morning in West Des Moines, near Grand Ave & 13th St. Cat is scared, but friendly. About 10 pounds, probably female (based on how my kitty is reacting). If you think this is your cat, please text 515-460-5567 to schedule a time to look at her.
Des Moines - Central
Found: 4/20/2016
ID: 2764
Name: Unknown
Type: Cat
Color: Mostly grey with white paws and chest
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Found this cat meowing outside in the Drake area. We out up found signs and the only reply was someone said he followed her from the gas station on 31st and University.
West Des Moines
Found: 4/20/2016
ID: 2729
Name: Andre
Type: Cat
Color: Black
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
From what we know, he ran outside while my roommate was letting the dog out. He is a gentle cat, no claws and only has 4 teeth. He is 14lbs and has a thin tail. Responds to Andre, Dan and Bubbus. Update: He's home!!!!
Des Moines - Central
Found: 4/19/2016
ID: 2717
Name:
Type: Cat
Color: Grey with white paws
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Young
He was meowing outside university terrace apartments. Took him inside because it was going to rain
Des Moines - East
Found: 4/19/2016
ID: 2714
Name:
Type: Dog
Color: White
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Young
Altoona
Found: 4/19/2016
ID: 2705
Name:
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
Altoona
Found: 4/17/2016
ID: 2708
Name:
Type: Dog
Color: Golden
Breed: Pomeranian Toy
Gender: Male
Fixed: Not Neutered
Age: Adult
Urbandale
Found: 4/15/2016
ID: 2682
Name: Abby
Type: Dog
Color: White/apricot
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Senior
90th and Iltis heading east
Des Moines - North
Found: 4/14/2016
ID: 2672
Name: No name tag
Type: Dog
Color: Black and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Found him on Aurora Ave on Lower Beaver in Des Moines.
West Des Moines
Found: 4/13/2016
ID: 2668
Name: Punkin
Type: Cat
Color: Black, orange, yellow
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near western hills elementary school
Pleasant Hill
Found: 4/12/2016
ID: 2685
Name: Patches
Type: Cat
Color: gray
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Large gray Maine Coon cat. He loves to hunt and we suspect he may have wandered too far. He has very large golden eyes that melt one's heart. Went missing from his home in Pleasant Hill Tuesday, April 12, 2016. UPDATE: after missing several days, he just walked in the house. :) God hears prayers about our fury family members too! :)
Des Moines - East
Found: 4/11/2016
ID: 2645
Name:
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Unknown
Fixed: Unknown
Age: Young
E. 41st Ct. & Easton Blvd.
Mitchellville
Found: 4/5/2016
ID: 2617
Name:
Type: Dog
Color: White and brown
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Baby
Glenwood
Found: 4/3/2016
ID: 2906
Name: Buddy
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
found in Glenwood Ia
Ankeny
Found: 4/1/2016
ID: 2591
Name: Moo
Type: Cat
Color: Calico/tortie
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is skittish and likely hiding
Ankeny
Found: 4/1/2016
ID: 2590
Name: Moo
Type: Cat
Color: Calico/tortie
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is skittish and likely hiding
Bondurant
Found: 3/30/2016
ID: 2571
Name:
Type: Dog
Color: brown
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 3/29/2016
ID: 2564
Name:
Type: Dog
Color:
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Found with collar. Will relates him to the person that correctly identifies the collar. Just want this guy to find his family.
Des Moines - East
Found: 3/27/2016
ID: 2539
Name: Unknown
Type: Dog
Color: Mostly black, some tan
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Adult
He's very friendly, large dog. Looks to be a rott mix. I found him and have him safe at my house. Must provide proof he is yours before I release him. Please call or email me if he is yours. 5156816948
Des Moines - West
Found: 3/26/2016
ID: 2536
Name:
Type: Dog
Color: White
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - West
Found: 3/26/2016
ID: 2535
Name:
Type: Dog
Color: White
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 3/19/2016
ID: 2494
Name:
Type: Dog
Color: Black & White
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Adult
Found between 2nd ave & cornell st at Euclid Call 515-771-4538