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>='1575331200')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 11/9/2019
ID: 12816
Name: Unknown
Type: Dog
Color: Brown and White
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
Found on 400 block of 68th st
Des Moines - North
Found: 11/9/2019
ID: 12803
Name: Unkown
Type: Cat
Color: White and grey and tan
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
Current hiding out in our garage
West Des Moines
Found: 11/9/2019
ID: 12788
Name:
Type: Cat
Color: White with black spots and black tail
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Seen around 68th Street and Ashworth. Mostly white. Black spots by each ear and a few black spots on body, tail is black. Medium length fur on body with longer fur on tail. Meows a lot, comes when called but will not let me pet or hold. Has pink collar and more toes than normal. Update: cat taken to Furry Friends Refuge
Ames
Found: 11/8/2019
ID: 12840
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Found in West Ames
West Des Moines
Found: 11/8/2019
ID: 12782
Name: unknown
Type: Dog
Color:
Breed: Wheaten Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 11/8/2019
ID: 12781
Name:
Type: Cat
Color: Orange
Breed: Tuxedo
Gender: Unknown
Fixed: Unknown
Age: Adult
It has orange and white fur not sure of female or male really friendly.
Winterset
Found: 11/7/2019
ID: 12801
Name:
Type: Cat
Color: Grey
Breed: Tuxedo
Gender: Female
Fixed: Unknown
Age: Adult
Found rural madison county, teenage/young adult, female, grey cat, no front claws. Loves people, seems to have been an indoor cat.
Altoona
Found: 11/7/2019
ID: 12786
Name:
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Near Vanberry trail apts
Urbandale
Found: 11/7/2019
ID: 12774
Name: unknown
Type: Cat
Color: orange tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
2900 block of 70th st
Carlisle
Found: 11/6/2019
ID: 12917
Name:
Type: Cat
Color: Brown, black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
Super friendly and lovable. Not chipped. This cat must have been someone's pet. He loves kids. Not the least bit anxious.
West Des Moines
Found: 11/6/2019
ID: 12771
Name:
Type: Rabbit
Color: black
Breed: Mini Rex
Gender: Unknown
Fixed: Unknown
Age: Young
1300 block of 11th Street in West Des Moines
Urbandale
Found: 11/6/2019
ID: 12770
Name:
Type: Bird
Color: Blue, Yellow, White with Black accents
Breed: Parakeet
Gender: Unknown
Fixed: Not Applicable
Age: Adult
4000 block of 67th street
Pella
Found: 11/5/2019
ID: 12807
Name:
Type: Cat
Color: Gray brown tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
This cat came injured and emaciated to were I work. Keeping him fed and warm until the owner is found.
Melcher-Dallas
Found: 11/5/2019
ID: 12764
Name: Luna
Type: Dog
Color: Black
Breed: Mastiff
Gender: Female
Fixed: Not Neutered
Age: Baby
She has a white bat shaped spot on her chest. She's a little skittish so she may be hard to catch.
West Des Moines
Found: 11/5/2019
ID: 12763
Name: Unknown
Type: Dog
Color: white and Brown
Breed: Jack Russell Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Ashworth Road in West Des Moines
Des Moines - North
Found: 11/4/2019
ID: 12758
Name:
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
This super friendly cat is hanging around my yard.
Johnston
Found: 11/4/2019
ID: 12756
Name:
Type: Dog
Color: Gray/Brown/White
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
Northglenn Neighborhood in Johnston. He was taken to the Animal Hospital on Merle Hay Rd and checked for a microchip. A chip was not found. He's a very well behaved and gentle.
West Des Moines
Found: 11/3/2019
ID: 12751
Name:
Type: Bird
Color: Red and white
Breed: Chicken
Gender: Female
Fixed: Unknown
Age: Adult
1200 block of 11th St.
West Des Moines
Found: 11/3/2019
ID: 12750
Name:
Type: Cat
Color: Black and white
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Pond by Living History Farms
Des Moines - East
Found: 11/2/2019
ID: 12936
Name:
Type: Cat
Color: Black and white
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
State Avenue EDM. Adult Cat no collar. Seems scared. Won't get close to me but its warming up. Likes dry food. Very healthy and shiny. She has been in my yard for a couple of weeks. Looking for owner.
Des Moines - North
Found: 11/2/2019
ID: 12748
Name:
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Urbandale
Found: 11/2/2019
ID: 12743
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
2700 block of 100th in Urbandale, The Learning Post parking lot
Urbandale
Found: 11/2/2019
ID: 12742
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
82nd & Madison in Urbandale
Des Moines - Central
Found: 11/1/2019
ID: 12739
Name: Jazz
Type: Dog
Color: Brown and Black
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Adult
Ankeny
Found: 11/1/2019
ID: 12737
Name:
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Very friendly