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>='1600992000')) ORDER BY pm1.meta_value DESC, post_date DESC
Pella
Found: 7/6/2020
ID: 14436
Name: Star
Type: Dog
Color: Brindle
Breed: Greyhound
Gender: Female
Fixed: Unknown
Age: Young
UPDATE: Star has been found!!!
Des Moines - Central
Found: 7/6/2020
ID: 14433
Name: Winter
Type: Dog
Color: White
Breed: Shiba Inu
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen around East Olinda Ave on Indianola ave by aroy dee restaurant. No collar but has a flea and tick collar. Will come to you if you call her.
Cylinder
Found: 7/6/2020
ID: 14426
Name:
Type: Dog
Color: Black and white
Breed: Bluetick Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Was found on the windfarm between cylinder and ringsted
Des Moines - South
Found: 7/5/2020
ID: 14417
Name:
Type: Cat
Color: Light and dark
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Young
Guthrie Center
Found: 7/4/2020
ID: 14406
Name: unknown
Type: Dog
Color: Black w/white muzzle
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Senior
Very sweet, overwhelmed & thirsty old girlie
Windsor Heights
Found: 7/4/2020
ID: 14403
Name: unknown
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Found near Windsor Heights Hy-Vee (more precisely, at the at the 72nd & University Flowerama). Very friendly kitty. We’ll soon take him to Furry Friends.
Des Moines - Central
Found: 7/2/2020
ID: 14404
Name:
Type: Cat
Color: White/orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Young
Seen on the Des Moines River Trail, South side of river, just East of 6th Avenue. Been there for a few days.
West Des Moines
Found: 7/2/2020
ID: 14387
Name:
Type: Dog
Color: Black, white, and brown
Breed: Beagle
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 7/2/2020
ID: 14386
Name:
Type: Dog
Color: White and Grey
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 7/1/2020
ID: 14382
Name:
Type: Dog
Color: White
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Found this guy wandering around south side. Super friendly!
Des Moines - East
Found: 7/1/2020
ID: 14381
Name:
Type: Cat
Color:
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - East
Found: 7/1/2020
ID: 14380
Name:
Type: Cat
Color:
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Baby
Urbandale
Found: 6/30/2020
ID: 14376
Name:
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - East
Found: 6/29/2020
ID: 14368
Name: pedro
Type: Dog
Color: black
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
was in fence in backyard with other dogs and when fireworks started he got out of fence and took off
West Des Moines
Found: 6/29/2020
ID: 14365
Name:
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Adult
900 Block of 16th Street
West Des Moines
Found: 6/29/2020
ID: 14364
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - South
Found: 6/29/2020
ID: 14351
Name: Nola
Type: Dog
Color: Brown Black and white
Breed: Havanese
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - East
Found: 6/28/2020
ID: 14363
Name:
Type: Dog
Color: Black/ tan
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
Kellogg
Found: 6/28/2020
ID: 14360
Name: unknown – TWO BROTHERS!!!
Type: Dog
Color: Blue Heeler
Breed: Australian Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
TWO BROTHERS found N/NE of Kellogg. Chased us down and tried to get in our car. When we extracted ourselves, one continued chasing us down another lane for a very long amount of time. Drove him back to his brother who was hiding in a ditch. Asked four different cars of people if they recognized them; they didn't. Were afraid they may have been dumped after so many people adopted/abandoned pets recently. Sorry if we tried to "rescue" your farm dogs; believe us, we're very embarrassed if that's the case. Let us know if they're yours.
Grimes
Found: 6/27/2020
ID: 14357
Name:
Type: Cat
Color: White/brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Pleasant Hill
Found: 6/27/2020
ID: 14356
Name: Walter
Type: Cat
Color: Brown Tabby
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Walter is a very people friendly longhaired brown tabby cat. However, he is not an outdoor cat so he may be skiddish if you approach him. If you see him, your best bet is to get down on his level and let him come to you. He is wearing a red collar with his name and our contact information. Our family misses Walter dearly and our other cat has been very distressed since he's been gone. If you see him or have any leads, please let us know. We desperately want him home!
Johnston
Found: 6/27/2020
ID: 14350
Name: Parker
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
West Des Moines
Found: 6/27/2020
ID: 14345
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
6400 Block of Pommel Place
Des Moines - South
Found: 6/26/2020
ID: 14563
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Off McKinley and SW 8th St
Des Moines - South
Found: 6/26/2020
ID: 14562
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Off McKinley and SW 8th St