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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
West Des Moines
Found: 10/9/2020
ID: 15169
Name:
Type: Dog
Color: brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Senior
1500 block 19th street
Des Moines - Central
Found: 10/9/2020
ID: 15168
Name:
Type: Dog
Color: Brown & black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
At 4049 43rd st des moines, is 50310. Keeping in our dog crate French porch.
Des Moines - South
Found: 10/9/2020
ID: 15166
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult