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>='1632268800')) ORDER BY pm1.meta_value DESC, post_date DESC
Altoona
Found: 10/17/2020
ID: 15239
Name:
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Unknown
Fixed: Unknown
Age: Adult
Found with a buddy near 8th st. I took them both to my house and then the Polk County Animal Rescue Transport came and picked them up. They are being taken to the ARL! So call them.
West Des Moines
Found: 10/17/2020
ID: 15238
Name:
Type: Dog
Color:
Breed: Great Pyrenees
Gender: Female
Fixed: Unknown
Age: Young
Please call 515-720-8474
West Des Moines
Found: 10/17/2020
ID: 15235
Name:
Type: Dog
Color: Black, White, & Tan
Breed: Hound
Gender: Female
Fixed: Unknown
Age: Adult
800 block of Valley West Drive
Urbandale
Found: 10/16/2020
ID: 15231
Name:
Type: Cat
Color: grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
4400 block 62nd st
West Des Moines
Found: 10/16/2020
ID: 15226
Name:
Type: Cat
Color: Cream and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 10/15/2020
ID: 15222
Name:
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Found around the Earl Mays by intersection of Indianola and highway 69.
Urbandale
Found: 10/15/2020
ID: 15217
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - North
Found: 10/14/2020
ID: 15209
Name:
Type: Cat
Color: White and orange
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
West Des Moines
Found: 10/14/2020
ID: 15206
Name:
Type: Cat
Color: White with gray patches
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Cat is extremely friendly. Yellow/Green eyes. Will take to ARL on friday
Des Moines - South
Found: 10/13/2020
ID: 15204
Name: Oso
Type: Dog
Color: Black & fluffy, brown eyebrows, brown snout, brown paws, white underbelly
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in our yard, we live close to Army Post and SE 14th.
Waterloo
Found: 10/12/2020
ID: 15223
Name: Unknown
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Cat behaves as though she is from a home. But has been outside longer than a week. Missing the tip of her left ear
West Des Moines
Found: 10/12/2020
ID: 15197
Name: Oreo
Type: Dog
Color: white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
200 block 9th st, Wilson Park
West Des Moines
Found: 10/12/2020
ID: 15196
Name: Joey
Type: Dog
Color: black and white
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
200 block 9th st, wilson park
Des Moines - Central
Found: 10/12/2020
ID: 15195
Name:
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Unknown
Age: Young
Animal control will be picking him up this evening and probably be taken To the southside ARL
Urbandale
Found: 10/12/2020
ID: 15191
Name:
Type: Dog
Color: Grey and White
Breed: Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Moorhead
Found: 10/11/2020
ID: 15192
Name: Unknown
Type: Dog
Color: brown/white
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
Just a puppy--very smart--showed up in middle of thunderstorm. Well taken care of.
West Des Moines
Found: 10/11/2020
ID: 15190
Name:
Type: Cat
Color: Torbie
Breed: Torbie
Gender: Female
Fixed: Unknown
Age: Adult
West Des Moines
Found: 10/11/2020
ID: 15186
Name:
Type: Dog
Color: Brown and white
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Young
Near Hyvee at Jordan Creek
Clive
Found: 10/10/2020
ID: 15188
Name: Bandit
Type: Cat
Color: Grey with black stripes on legs
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Senior
We have found her!
West Des Moines
Found: 10/10/2020
ID: 15184
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Hamlet Apartments on EP True Parkway
West Des Moines
Found: 10/10/2020
ID: 15183
Name:
Type: Cat
Color: White & Orange Flame Point
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Adult
3000 University Avenue
West Des Moines
Found: 10/10/2020
ID: 15182
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Mills Civic Parkway & Cascade Avenue (found with brown tabby)
West Des Moines
Found: 10/10/2020
ID: 15181
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Mills Civic Parkway & Cascade Avenue (found with black cat)
Johnston
Found: 10/9/2020
ID: 15172
Name: Unknown
Type: Cat
Color: Tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found with another cat. Unknown if they live together. No microchip.
Johnston
Found: 10/9/2020
ID: 15171
Name: Betty Boo
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found with another cat. She has a microchip but address and phone number are incorrect.