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 = 'lost' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1571270400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 10/8/2019
ID: 12548
Name: N/A
Type: Dog
Color: brown and white
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
came running into my back yard, hasn’t tried biting me but has tried biting my neighbor. let me pet him. apparently has been running around my neighborhood since 1 pm on october 8th. dog tag collar is green and has a number for a spray clinic that’s it.
West Des Moines
Found: 10/8/2019
ID: 12547
Name:
Type: Cat
Color: White and Grey
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Adult
400 block of 6th St
Ankeny
Lost: 10/7/2019
ID: 12575
Name: Copper
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near downtown Ankeny
West Des Moines
Lost: 10/7/2019
ID: 12563
Name: Wiggly Whiskers
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 10/7/2019
ID: 12561
Name: Chloe
Type: Cat
Color: Brown/Grey/Tan
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Very soft fur, may be skiddish
Ankeny
Lost: 10/7/2019
ID: 12560
Name: Chloe
Type: Cat
Color: brown/grey/tan Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Very soft fur, may be skiddish.
Waukee
Lost: 10/7/2019
ID: 12546
Name: Feisty
Type: Cat
Color: Black and gray
Breed: Bobtail
Gender: Male
Fixed: Neutered
Age: Adult
Feisty is home and safe!!
Ankeny
Lost: 10/7/2019
ID: 12545
Name: Copper
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around Ankeny Animal and Avian Clinic on Ankeny Blvd. He most likely wont respond to his name because we only got him a week ago and he probably doesnt know it yet
Pella
Found: 10/7/2019
ID: 12543
Name: Teddy
Type: Dog
Color: Deadgrass
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Teddy is home safe. Thank you!
Des Moines - North
Lost: 10/7/2019
ID: 12542
Name: Crash
Type: Dog
Color: Brown/red
Breed: Pinscher-Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
He barks at everyone and everything but is harmless.
West Des Moines
Found: 10/7/2019
ID: 12541
Name: Unknown
Type: Bird
Color: Grey,Yellow, and white
Breed: Cockatiel
Gender: Unknown
Fixed: Unknown
Age: Adult
Found at maple grove elementary school.
Dubuque
Lost: 10/6/2019
ID: 12558
Name: Boots
Type: Cat
Color: Black/white/brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Ogden
Lost: 10/6/2019
ID: 12550
Name: Kitty
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
He is people friendly, his two front claws has been removed but still have the back ones. His name tag says his name: Kitty with my fiancé number on it.
Des Moines - Central
Lost: 10/6/2019
ID: 12544
Name: Rhaego
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Lives on aurora off Shawnee. But could be anywhere in the Hoover High area. Weighs about 13.5 pounds. Name pronounced ray-go.
Clive
Found: 10/6/2019
ID: 12540
Name: Raven
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
On the 2100 Block of NW 90th
Newton
Lost: 10/6/2019
ID: 12538
Name:
Type: Cat
Color: Black, white and brown
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
West Des Moines
Found: 10/6/2019
ID: 12530
Name:
Type: Dog
Color: Tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Adult
Found in WDM near Ashworth and 50th Street
Waukee
Lost: 10/5/2019
ID: 12564
Name: Ben
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is an indoor outdoor cat but always comes back at some point during the day to sleep and eat. We last saw him saturday night. He does have a greenish collar on with a name tag that includes his name, our address and phone number. He is super friendly so I am wondering if someone took him for their own...
Prescott
Lost: 10/5/2019
ID: 12537
Name: Daya
Type: Dog
Color: Brown
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Baby
She was last scene in front of our home. She loves treats and is very sweet she should come right to you if you talk really sweet to her.
Pella
Lost: 10/5/2019
ID: 12528
Name: Teddy
Type: Dog
Color: Deadgrass
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen outside of Pella near lake red rock on a hunting trip. Very friendly dog. He’s young and may be timid and scared. He is okay to approach.
Des Moines - Central
Lost: 10/5/2019
ID: 12527
Name:
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
6-week-old kitten named Boots; grey kitten with white paws
West Des Moines
Lost: 10/5/2019
ID: 12526
Name: Leo
Type: Dog
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen corner of Ashworth and 31st st West Des Moines
Ankeny
Lost: 10/5/2019
ID: 12525
Name: Janie
Type: Dog
Color: Black and white
Breed: Havanese
Gender: Unknown
Fixed: Unknown
Age: Adult
NE Ankeny Briarwood
Des Moines - South
Lost: 10/5/2019
ID: 12524
Name: Capone
Type: Dog
Color: Fawn
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on south union and McKinley
Des Moines - South
Found: 10/5/2019
ID: 12522
Name:
Type: Dog
Color: Black and white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Armypost road running from autozone to hyvee southridge