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
Des Moines - West
Found: 11/10/2016
ID: 4304
Name:
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
He is safe in our garage. Found at 49th and grand running across street.
Des Moines - West
Found: 11/10/2016
ID: 4302
Name:
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
He is safe in our garage. Found at 49th and grand running across street.
Des Moines - West
Found: 11/10/2016
ID: 4301
Name:
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
He is safe in our garage. Found at 49th and grand running across street.
Boone
Found: 11/10/2016
ID: 4287
Name: Unknown
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - East
Found: 11/8/2016
ID: 4285
Name:
Type: Cat
Color: Orange and white
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
He is safe in our home and will be our cat if he is not claimed
Des Moines - East
Found: 11/6/2016
ID: 4254
Name: Trouble
Type: Cat
Color: Orange tabby
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Senior
Missing a front fang from a surgical removal, 2 imch nub of a tail, 5 other teeth surgically removed, orange tabby with white blazed chest, not an outside cat, √Ćuoh
West Des Moines
Found: 11/6/2016
ID: 4248
Name:
Type: Bird
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Found: 11/4/2016
ID: 4275
Name: Tom aka: Itchy
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Found him earlier today, he got into a neighbors garage and had been shut in since last Friday night/Saturday morning. Jim was out working in yard and kept hearing a meow and found it coming from the garage. He was pretty dirty and very hungry and thirsty but seems to be OK.
Charlotte
Found: 11/4/2016
ID: 4228
Name: Molly and morgan
Type: Bird
Color: Ash
Breed: African Grey
Gender: Male
Fixed: Unknown
Age: Baby
Its with me at my home
Pleasant Hill
Found: 11/2/2016
ID: 4218
Name: Lila
Type: Dog
Color: Black
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Senior
very friendly-has an invisible fence collar on-
Marion
Found: 11/1/2016
ID: 4243
Name:
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Young
Black cat found in North side of Marion and is being fostered. Extremely sweet and house trained. Looks like collar may have been recently removed.
Des Moines - West
Found: 10/31/2016
ID: 4220
Name:
Type: Cat
Color:
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
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