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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Found: 9/26/2016
ID: 3953
Name:
Type: Dog
Color: Chocolate brown
Breed:
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Found: 9/23/2016
ID: 3912
Name:
Type: Dog
Color:
Breed: American Bulldog
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - South
Found: 9/21/2016
ID: 3907
Name:
Type: Dog
Color: Black and white
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Baby
Was running across Indianola ave near Ewing dog park. Stopped to check on her and she jumped right in the car. Very malnourished and slightly timid but overall friendly.
Welton
Found: 9/17/2016
ID: 3890
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Senior
Des Moines - East
Found: 9/15/2016
ID: 3868
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 9/13/2016
ID: 3848
Name: Runt Runt
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Baby
We have him he is ourrs
Carlisle
Found: 9/9/2016
ID: 3980
Name: ?
Type: Reptile
Color:
Breed: Lizard
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 9/9/2016
ID: 3823
Name:
Type: Dog
Color: Cream
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Senior
Found at sw 12th street, between Virginia and Broad street
Des Moines - South
Found: 9/9/2016
ID: 3822
Name:
Type: Dog
Color: Cream
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Senior
Found at sw 12th between Virginia and Broad street
Des Moines - South
Found: 9/8/2016
ID: 3819
Name:
Type: Cat
Color: Tiger
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
Park/ SW 35th St area, very similar in color to tiger striped cat in ARL found ad from 9/7. Very friendly ! Sorry camera not working.
Ankeny
Found: 9/8/2016
ID: 3818
Name:
Type: Cat
Color:
Breed: Dilute Tortoiseshell
Gender: Unknown
Fixed: Unknown
Age: Adult
SW 3rd St and SW Maple St
Altoona
Found: 9/2/2016
ID: 3772
Name: unknown
Type: Dog
Color: multicolored. black and tan
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Baby
supposedly picked up from a man on the side of the road who said if she was not removed from his care he would kill her.
Ankeny
Found: 9/1/2016
ID: 3757
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Autumn Ridge area Very lovable 8648405 ph
Des Moines - East
Found: 8/31/2016
ID: 3753
Name:
Type: Cat
Color: Gray
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Wondering if anyone has been missing him for awhile. He doesn't have front claws and is very friendly so I know he belonged to someone.
Des Moines - Central
Found: 8/31/2016
ID: 3751
Name:
Type: Dog
Color:
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Baby
Found on Hickman and 40th Contact 515-782-4753 if this is your dog. He is neutered and microchips.
Ankeny
Found: 8/30/2016
ID: 3747
Name: unknown
Type: Cat
Color: black/gray tiger
Breed: Tiger
Gender: Unknown
Fixed: Unknown
Age: Adult
SE Richland Ct and SE 8th Street, Ankeny IA
Altoona
Found: 8/27/2016
ID: 3745
Name: Unknown
Type: Cat
Color: White with sand colored spots
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Found at Prairie Meadows Casino parking lot last Saturday. Please text 515-528-3274 and send a pic of your missing cat to confirm.
Des Moines - East
Found: 8/27/2016
ID: 3730
Name: Hope
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
In the front yard of 1220 e 37th ct
Des Moines - East
Found: 8/27/2016
ID: 3729
Name: Faith
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
She was last seen with her baby in my front yard of 1220 east 37th ct she runs on dubuque St all the time
Des Moines - North
Found: 8/24/2016
ID: 3727
Name: Unknown
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Very sweet cat.
West Des Moines
Found: 8/17/2016
ID: 3666
Name: Unknown
Type: Dog
Color: White with brown spots
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Young
Coachlight Dr, WDM
Pleasant Hill
Found: 8/16/2016
ID: 3658
Name: ?
Type: Dog
Color: Brown
Breed: Cocker Spaniel
Gender: Male
Fixed: Unknown
Age: Baby
I found this little guy wet, cold, and upset this morning on Robin Road in Pleasant Hill. I'm guessing that he hasn't wandered off too far, but never know. Please identify with previous photos, color of his color and proof of ownership.
Cedar Rapids
Found: 8/15/2016
ID: 3662
Name: Sweet Kitten
Type: Cat
Color: Orange and White
Breed: Tiger
Gender: Unknown
Fixed: Unknown
Age: Baby
Found this cute and sweet kitten near 1st Avenue and 27th, in Cedar Rapids.
Bronson
Found: 8/7/2016
ID: 3615
Name: Unknown
Type: Dog
Color: one is fawn, one is brindle
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Adult
Dundee
Found: 8/6/2016
ID: 3622
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Found near Dundee iowa near backbone state park