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
Dundee
Found: 8/6/2016
ID: 3621
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Found near Dundee iowa near backbone state park
New Hampton
Found: 8/5/2016
ID: 3592
Name:
Type: Cat
Color: Black and orange
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
Bettendorf
Found: 8/2/2016
ID: 3572
Name: Lucy
Type: Cat
Color: Wht/Brown
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 7/30/2016
ID: 3547
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Young
Contact me at 515.240.5967
Ankeny
Found: 7/30/2016
ID: 3544
Name:
Type: Cat
Color: black and orange
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Norwalk
Found: 7/24/2016
ID: 3505
Name: 2 Dogs
Type: Dog
Color:
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Found in between Cummings and Norwalk on Hwy G-14 closer to Norwalk. Must identify if they are both yours. Call: Howling Hills Canine Campus @ 515-981-5120 or 515-577-8216
Norwalk
Found: 7/24/2016
ID: 3504
Name: 2 Dogs
Type: Dog
Color:
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Found in between Cummings and Norwalk. Must identify if they are both yours. Call: Howling Hills Canine Campus @ 515-981-5120 or 515-577-8216
Des Moines - East
Found: 7/24/2016
ID: 3499
Name:
Type: Cat
Color: All black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Young
Found on twana dr, very friendly and loving, missing little chunk of its left ear.
Des Moines - Central
Found: 7/18/2016
ID: 3455
Name: Winter
Type: Dog
Color: White
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Winter is a very shy dog so if you do find her, do not run at her or yell because she will flee. She has the perfect pigtail and resembles a fox.
Pleasant Hill
Found: 7/17/2016
ID: 3446
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Young
Found on onramp to bypass off Univerity in PH. Altoona police are taking custody tonight. Pink color with a black cat charm and heart charm
Des Moines - West
Found: 7/7/2016
ID: 3430
Name:
Type: Cat
Color: Orange
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
We have an adult orange cat stuck up in our large oak tree. We have tried everything to get it down, food, begging, a bucket truck, no luck. I'm hoping to find it's owner and possibly they can coax it down. If you are missing an orange cat, please contact me right away.
Des Moines - South
Found: 7/7/2016
ID: 3402
Name:
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Young
Found around Park Ave and SW 9th
Des Moines - Central
Found: 7/7/2016
ID: 3371
Name: N/A
Type: Dog
Color:
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Young
found on bike trail between Mullets and Greys Lake. Very friendly little girl.
Pleasant Hill
Found: 7/4/2016
ID: 3344
Name: Unknown
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Minburn
Found: 7/4/2016
ID: 3333
Name:
Type: Dog
Color: Black/White
Breed: Border Collie
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 7/4/2016
ID: 3329
Name: unknown
Type: Dog
Color: cream and light brown
Breed: Shar Pei
Gender: Unknown
Fixed: Unknown
Age: Adult
Traveling with a second dog that is larger (maybe pit bull)
Des Moines - North
Found: 7/4/2016
ID: 3328
Name: Unknown
Type: Dog
Color: Brown and White
Breed: Shar Pei
Gender: Unknown
Fixed: Unknown
Age: Adult
Found around the 26th and Hickman area of DSM. Traveling with a second dog that might be a sharpae (sorry, don't know how to spell this)). The second dog is a cream and light brown color (small size).
Des Moines - East
Found: 7/3/2016
ID: 3308
Name: Tuffy
Type: Dog
Color: Yellow
Breed: Cocker Spaniel
Gender: Male
Fixed: Not Neutered
Age: Senior
Backyard 1840 capitol ave dm 50316
Bettendorf
Found: 7/3/2016
ID: 3298
Name:
Type: Dog
Color: Cream
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Found on edge of river2
Clive
Found: 7/2/2016
ID: 3309
Name:
Type: Cat
Color:
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Adult
This cat was hit and killed it is in the median between 80th and 82nd on Hickman road. It is a Bengal. Someone moved it onto the grass median. My sympathies to the owner.
Des Moines - South
Found: 6/25/2016
ID: 3244
Name: ???
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Was dragging a red leash attached to a black leash.
Bussey
Found: 6/23/2016
ID: 3234
Name: ?
Type: Dog
Color: White and brown
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Found on the motor cross area
Des Moines - West
Found: 6/20/2016
ID: 3214
Name:
Type: Dog
Color: Blackish/Gray
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Baby
Small dog found wandering NW Des Moines in the vicinity of 51st & Merced Street (near Price Chopper on Merle Hay Road). Must describe design & color of collar, along with sex of the dog.
Des Moines - North
Found: 6/16/2016
ID: 3175
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 6/16/2016
ID: 3174
Name: Unknown
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby