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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
Norwalk
Found: 10/28/2016
ID: 4207
Name:
Type: Cat
Color: orange/tiger
Breed: Tiger
Gender: Unknown
Fixed: Unknown
Age: Young
Found west end of Beardsley Street in Norwalk. Very friendly and clean.
Waukee
Found: 10/26/2016
ID: 4167
Name: Buc
Type: Dog
Color: White and brown
Breed: Brittany Spaniel
Gender: Male
Fixed: Unknown
Age: Adult
Buc was hooked up this morning, slipped out of his collar. He lives in the trailer court with his dad who really misses him! He is extremely friendly! He is up to date on his shots as a FYI since he does not have his collar on. He has a heart shaped spot on the top of his head.
Des Moines - South
Found: 10/24/2016
ID: 4142
Name: Ozzie
Type: Dog
Color: Tan
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Adult
Got out of our yard the morning of 10/24/16. Very friendly!!!
Ankeny
Found: 10/23/2016
ID: 4147
Name: Callie
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Near SE Hillside Drive
Des Moines - East
Found: 10/21/2016
ID: 4279
Name: Pj
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
White under chin loving 2522 Logan avenue. indoor cat
Fort Madison
Found: 10/20/2016
ID: 4122
Name: Unknown
Type: Dog
Color: Brown/White
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Ran up to door on 3rd St & Avenue F in Fort Madison, IA. Looking for owner, nobody in neighborhood looking for lost dog. Seems like he had been out for a while, empty stomach and very thirsty.
West Des Moines
Found: 10/20/2016
ID: 4120
Name:
Type: Cat
Color:
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Adult
Declawed, very nice, patches of missing fur on its back, obviously used to being indoors and outdoors, fairly used to dogs.
Urbandale
Found: 10/18/2016
ID: 4104
Name:
Type: Dog
Color: White
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Found: 10/15/2016
ID: 4086
Name:
Type: Cat
Color: orange
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Found: orange cat, female, friendly/sweet, front declawed, probably young, no microchip, seen in neighborhood by others earlier in week, found in Somersby neighborhood SW Ankeny: near Dog Park south of DMACC--wanted to go inside, pet, must be missing family!!!
Des Moines - South
Found: 10/14/2016
ID: 4085
Name:
Type: Dog
Color: White
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
10/15/16 safe in someone's home
Davenport
Found: 10/12/2016
ID: 4069
Name: Unknown
Type: Cat
Color: Tan, Brown and Black
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
This cat looks like a calico and acts like it to. She is super cuddly. We found her on Kirkwood Ave last night around 10:00. We will keep her at our house for a couple days and then figure out what to do with her. We only took her in because she didn't seem to want much to do with the outside and didn't regard cars as a threat. Most outside cats don't just run up to you and snuggle let alone let you pick them up and follow you. Contact me if you know this animal.
Des Moines - Central
Found: 10/12/2016
ID:
Name:
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - Central
Found: 10/12/2016
ID: 4061
Name:
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Baby
Clear Lake
Found: 10/11/2016
ID: 4060
Name:
Type: Cat
Color: gray with white feet
Breed: Boxer
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