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>='1600387200')) ORDER BY pm1.meta_value DESC, post_date DESC
Winterset
Found: 6/13/2020
ID: 14222
Name: Frankie
Type: Dog
Color: Black with tan/white face
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
He was probably on Pammel Park Rd in Winterset if someone may have picked him up and not known where to take him.
Des Moines - South
Found: 6/12/2020
ID: 14215
Name:
Type: Cat
Color: Black with white spot under belly near rear end
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 6/12/2020
ID: 14214
Name: Unknown
Type: Dog
Color: Mostly White w/ Black patches
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Young
Found at approx. 5pm on 6/12/2020 running across and down 2nd Avenue near Seneca Ave. ARL picked up just before 8pm on 6/12/2020
Des Moines - East
Found: 6/10/2020
ID: 14208
Name:
Type: Dog
Color: Brown and white
Breed: Basset Hound
Gender: Male
Fixed: Unknown
Age: Adult
Found by AE Dairy. The guys called animal control. He was taken to the ARK
Des Moines - South
Found: 6/10/2020
ID: 14204
Name:
Type: Dog
Color: Tan & black
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Baby
Found on ss des moines off of watrous
Des Moines - East
Found: 6/9/2020
ID: 14203
Name:
Type: Dog
Color:
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen on NE 38th st by Grandview little league
Des Moines - South
Found: 6/6/2020
ID: 14191
Name: Aggie Mae
Type: Dog
Color: White
Breed: German Shorthaired Pointer
Gender: Unknown
Fixed: Neutered
Age: Young
She was last seen in her kennel around 7:45 pm. Fireworks spooked her and somehow got out!
Urbandale
Found: 6/6/2020
ID: 14183
Name:
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
4500 Block of 86th Street
Des Moines - West
Found: 6/5/2020
ID: 14179
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Hickman MLK area. Help!!! Come get your dog
West Des Moines
Found: 6/5/2020
ID: 14177
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
6000 block of Colt Drive
West Des Moines
Found: 6/3/2020
ID: 14163
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - North
Found: 6/3/2020
ID: 14158
Name: Don’t Know
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Big Feet. Nice Cat. Seems Lost. In area of Monroe School.
Urbandale
Found: 6/2/2020
ID: 14149
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
7000 block of Roseland Drive
Des Moines - East
Found: 6/2/2020
ID: 14143
Name: Allie
Type: Dog
Color: Grey/white
Breed: Husky
Gender: Female
Fixed: Neutered
Age: Senior
Someone broke in and let her out of her runner she has a bad acl loves skittle very picky eater
Des Moines - East
Found: 6/2/2020
ID: 14142
Name: Allie
Type: Dog
Color: Grey/white
Breed: Husky
Gender: Female
Fixed: Neutered
Age: Senior
Someone broke into our yard and let them out of their running pen Very friendly call here she will come loves skittles on southeast side by the river Yaw Auto Salvage
Des Moines - South
Found: 6/1/2020
ID: 14165
Name:
Type: Dog
Color:
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Baby
McKinley area
Brooklyn
Found: 6/1/2020
ID: 14164
Name:
Type: Dog
Color: white
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
Originally spotted running west on I-80 near Grinnell IA. Spotted again this morning closer to Brooklyn IA. Dog is still headed west.
West Des Moines
Found: 6/1/2020
ID: 14144
Name:
Type: Cat
Color: Grey and Cream
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Adult
4900 block of Pleasant
Des Moines - Central
Found: 6/1/2020
ID: 14141
Name:
Type: Bird
Color: Blue
Breed: Parakeet
Gender: Male
Fixed: Unknown
Age: Young
We are caring for the bird at our home.
Windsor Heights
Found: 6/1/2020
ID: 14139
Name:
Type: Reptile
Color:
Breed: Turtle
Gender: Unknown
Fixed: Unknown
Age: Young
West Des Moines
Found: 5/31/2020
ID: 14126
Name: Mabel
Type: Dog
Color: red
Breed: GoldenDoodle
Gender: Female
Fixed: Unknown
Age: Adult
Sylvania & Valley West Dr. Picked up at 1:42 AM
West Des Moines
Found: 5/30/2020
ID: 14117
Name:
Type: Dog
Color: Brown/white/black
Breed: Collie
Gender: Female
Fixed: Unknown
Age: Adult
West Des Moines
Found: 5/29/2020
ID: 14119
Name:
Type: Cat
Color: Brown tabby
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
EP True Parkway & Grand Avenue
Remsen
Found: 5/29/2020
ID: 14116
Name: Unknown
Type: Dog
Color: Brown
Breed: Griffon
Gender: Male
Fixed: Unknown
Age: Adult
Found this dog in the pen with our dog , call Kim @ (712)444-6300 in Remsen! !As of 06/02/2020, surrendered to Noah's Hope
Urbandale
Found: 5/29/2020
ID: 14114
Name:
Type: Dog
Color: White and Black
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult