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
Clear Lake
Found: 10/11/2016
ID: 4060
Name:
Type: Cat
Color: gray with white feet
Breed:
Gender: Female
Fixed: Unknown
Age: Young
Very sweet and loving. Appears in excellent condition, but very hungry.
Carlisle
Found: 10/10/2016
ID: 4039
Name:
Type: Cat
Color: White an tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Very sweet an loving
Ankeny
Found: 10/9/2016
ID: 4041
Name:
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Found in caseys corporate parking lot in ankeny. Very affectionate!
Carlisle
Found: 10/8/2016
ID: 4033
Name:
Type: Cat
Color: Black an tan
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Very friendly
Des Moines - East
Found: 10/3/2016
ID: 3997
Name: Patrick
Type: Dog
Color: Black with white patch
Breed: Dachshund Standard
Gender: Male
Fixed: Neutered
Age: Senior
2345 e 11th st des moines iowa
Minburn
Found: 10/1/2016
ID: 3992
Name:
Type: Cat
Color: A himalayan or siamese mix
Breed: Dachshund Standard
Gender: Female
Fixed: Unknown
Age: Adult
Found north of minburn in the country. She's very thin so appears to have been on her own for a bit. Very loving. Appears slightly older due to teeth and gum appearance. Not posting photo as owner will need to provide identity verification.
Urbandale
Found: 9/26/2016
ID: 3953
Name:
Type: Dog
Color: Chocolate brown
Breed: Dachshund Standard
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