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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 7/15/2021
ID: 17240
Name: KC
Type: Dog
Color: Black and brown
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Adult
Kelley
Found: 7/14/2021
ID: 17250
Name: Lost Kitty
Type: Cat
Color: White, gray yellow
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Appears visual impared
Des Moines - South
Found: 7/14/2021
ID: 17241
Name: Mighty
Type: Cat
Color: Orange stripes with white face
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Found!
West Des Moines
Found: 7/14/2021
ID: 17232
Name:
Type: Dog
Color: Brown and white
Breed: Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 7/12/2021
ID: 17212
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Intersection of 21st & university. Deceased. I took her to Starch Pet Hospital to see if she had a microchip. If you have questions, please call Starch Pet Hospital about the deceased black (white patch) female who was found at 21st st.
Urbandale
Found: 7/10/2021
ID: 17196
Name:
Type: Dog
Color: Brown
Breed: Hound
Gender: Female
Fixed: Unknown
Age: Adult
15406 Townsend Drive, urbandale, Iowa, 50322
West Des Moines
Found: 7/10/2021
ID: 17194
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
1201 Office Park, West Des Moins, iowa, 50265
Marion
Found: 7/9/2021
ID: 17197
Name: Unknown
Type: Cat
Color: Grey Tabby
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Found in Marion, IA, corner of Boyson and 10th St. Can only hold for 3 days due to lease restrictions. Will then move to Marion police dept.
Des Moines - Central
Found: 7/9/2021
ID: 17193
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Baby
It's been on 38th st for a few days, multiple neighbors have been feeding it, but no one knows who it belongs to, cat seems fairly young and is very friendly
West Des Moines
Found: 7/9/2021
ID: 17191
Name:
Type: Dog
Color: black and white
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Oakwood Lane, West Des Moines, IA 50265, United States of America, Polk County, 50265
West Des Moines
Found: 7/8/2021
ID: 17187
Name:
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Vine st
Clive
Found: 7/8/2021
ID: 17186
Name:
Type: Cat
Color: grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
The Rack Billiard Club, 2249 Northwest 86th Street, Clive, IA 50325, United States of America, Polk County, 50325
Des Moines - Central
Found: 7/8/2021
ID: 17184
Name: Unknown
Type: Dog
Color: Golden
Breed: Labradoodle
Gender: Male
Fixed: Unknown
Age: Young
The dog is microchipped but there is no information on the chip since it is not registered. We took it to a vet to make sure.
Clive
Found: 7/8/2021
ID: 17183
Name:
Type: Dog
Color: tan and black
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
99th st and lincoln ave
Windsor Heights
Found: 7/8/2021
ID: 17178
Name:
Type: Dog
Color: Black and tan
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Adult
Terrier mix found in Windsor Heights. Friendly, no collar. The Windsor Heights police picked it up and it will be at the ARL.
Des Moines - East
Found: 7/7/2021
ID: 17173
Name: Unknown
Type: Dog
Color: Black & brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
1600 blk of E22nd St in DM. Sadly, I'll have to call ARL to pick up if owner not found in next couple hrs. System wouldn't let me upload an image.
West Des Moines
Found: 7/7/2021
ID: 17167
Name: Rocket
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Muscatine
Found: 7/6/2021
ID: 17168
Name: Gomer
Type: Dog
Color: Brown Mix
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Senior
North of Muscatine, IA
West Des Moines
Found: 7/6/2021
ID: 17164
Name: Luno
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Low Moor
Found: 7/6/2021
ID: 17163
Name:
Type: Dog
Color: Black/tan
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 7/6/2021
ID: 17160
Name:
Type: Dog
Color: Brown
Breed: Australian Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Young
4524 EP True Parkway West Des Moines 50266
West Des Moines
Found: 7/6/2021
ID: 17155
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 7/5/2021
ID: 17152
Name: Buddy
Type: Dog
Color: Black
Breed: Schnauzer
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 7/5/2021
ID: 17135
Name:
Type: Bird
Color: black
Breed: Chicken
Gender: Unknown
Fixed: Unknown
Age: Young
Black rooster in Union Park North neighborhood.
Des Moines - South
Found: 7/4/2021
ID: 17130
Name: Luna
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
She is back home after her 4 day adventure safe and sound