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 - North
Found: 10/16/2017
ID: 7118
Name:
Type: Dog
Color:
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
5th and Arthur
Des Moines - South
Found: 10/16/2017
ID: 7115
Name:
Type: Dog
Color: Multi - Brown, Tan, Black, Grey
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
Found near Park Avenue and SW 34th/ SW 42nd Street in Des Moines. He is not microchipped and doesn't have any tags.
Des Moines - Central
Found: 10/15/2017
ID: 7106
Name: Unknown
Type: Dog
Color: black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Last seen in front of Samuelson Elementary in Des Moines. Please call 515-314-6155
Stuart
Found: 10/15/2017
ID: 7101
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
3097 285th street, stuat, iowa 50250 accompanied with a smaller toto dog.
Des Moines - East
Found: 10/13/2017
ID: 7097
Name:
Type: Dog
Color: Black with white down chest and white back paws
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Found on east 37 by 4 mile get ahold of me at 515-776-2469
Des Moines - South
Found: 10/13/2017
ID: 7091
Name:
Type: Bird
Color:
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on southside outside our home. Is a Indian Ringneck Parakeet Call 491-8180
Des Moines - South
Found: 10/13/2017
ID: 7088
Name:
Type: Bird
Color: Yellow
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Adult
This bird was found in the 2400 block of Watrous on Des Moines' south side by elementary school.
Des Moines - West
Found: 10/11/2017
ID: 7130
Name:
Type: Cat
Color: light orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Young
Lovely, friendly little orange kitten hanging around Forest & 42nd. Skinny, and not street-savvy so hoping to find his home soon! Currently wearing a blue collar w/ bell and a flea collar.
Ankeny
Found: 10/11/2017
ID: 7057
Name: Marlee
Type: Cat
Color: Gray/white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
At the apartments in state and 1st behind caseys
De Soto
Found: 10/10/2017
ID: 7073
Name: Unknown
Type: Cat
Color: Maine coon
Breed: Maine Coon
Gender: Male
Fixed: Not Neutered
Age: Young
He was found at Desoto Elementary school.
Des Moines - South
Found: 10/9/2017
ID: 7037
Name:
Type: Dog
Color: Black/Tan/White
Breed: Collie
Gender: Male
Fixed: Unknown
Age: Young
Found him crossing SE 14th from my office window, so I hopped in the car and grabbed him. He has no tags nor microchip and looks like he chewed through or broke a leash as it was still attached, but torn. If he is yours, text me a picture. I am at work and can't answer my phone during the day.
Elkhart
Found: 10/9/2017
ID: 7034
Name: Bailey
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Des Moines - East
Found: 10/8/2017
ID: 7033
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Birmingham
Found: 10/6/2017
ID: 7028
Name:
Type: Dog
Color: White with black spots
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Rides well in car, collar indent in fur. .
Johnston
Found: 10/5/2017
ID: 6994
Name: Unknown
Type: Cat
Color: White and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Today. Actually have seen him around since end of August. Very, very friendly, cuddly and needy but has been scaring off our own lost Tuxedo cat.
Pleasant Hill
Found: 10/2/2017
ID: 7153
Name:
Type: Cat
Color: Orange, White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Very friendly orange and white cat. Vet thinks it is neutered but could not find a microchip. Adult cat. Found in Pleasant Hill.
Des Moines - West
Found: 10/2/2017
ID: 6967
Name: Lightning
Type: Dog
Color: Black
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Baby
Winterset
Found: 10/1/2017
ID: 6965
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Young
Found near W Buchanan Street around 11pm Sunday, 10/1.
Des Moines - Central
Found: 10/1/2017
ID: 6963
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Indianola
Found: 10/1/2017
ID: 6952
Name: Unknown
Type: Dog
Color:
Breed: Blue Heeler
Gender: Female
Fixed: Unknown
Age: Young
Midway between Indianola, South Des Moines, Norwalk, Carlisle.
Des Moines - Central
Found: 9/30/2017
ID: 6991
Name:
Type: Cat
Color: Golden Tan and White
Breed: Blue Heeler
Gender: Female
Fixed: Unknown
Age: Baby
Front claws declawed, well groomed and very sweet Has been hanging around 51st and 52nd and Lincoln Ave area between Hickman and Franklin ave
Johnston
Found: 9/30/2017
ID: 6950
Name:
Type: Cat
Color: Blonde
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Found: 9/30/2017
ID: 6938
Name:
Type: Cat
Color: Gray
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
Cat had no collar or tags, animal was turned over to Des Moines Animal Control. Cat was found in Beaverdale neighborhood.
West Des Moines
Found: 9/30/2017
ID: 6936
Name:
Type: Cat
Color: Orange/Tan
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found outside Culver's on Jordan Creek Parkway with no collar. Approachable cat and friendly. Has blue eyes. Contact 515-257-6314
Des Moines - North
Found: 9/28/2017
ID: 6918
Name:
Type: Dog
Color: White/brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
Found in Chautauqua neighborhood