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>='1573689600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 8/29/2017
ID: 6652
Name: Unknown
Type: Cat
Color: Black and grey
Breed:
Gender: Unknown
Fixed: Unknown
Age: Baby
Was seen on Sunday out downtown and taken in on tuesday night.
Des Moines - Central
Found: 8/29/2017
ID: 6651
Name: Unknown
Type: Cat
Color: Black and grey
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
Was seen on Sunday out downtown and taken in on tuesday night.
Johnston
Found: 8/27/2017
ID: 6607
Name: Tank
Type: Dog
Color: Black white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Waukee
Found: 8/26/2017
ID: 6606
Name:
Type: Dog
Color: Blond
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Young
He's safe in my backyard.
Johnston
Found: 8/26/2017
ID: 6605
Name: Tank
Type: Dog
Color: Black white
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Adult
66th Ave
Cedar Rapids
Found: 8/25/2017
ID: 7192
Name: Don’t know, I just call him Blondie
Type: Cat
Color: Blone with blonde and white striped tail
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
He is still hanging around my back deck like he lives here! He has chased away my outside cat so now my cat lives inside and out front. Probably because I made the mistake of feeding him but I did not want him to go hungry.
Ankeny
Found: 8/25/2017
ID: 6601
Name: Ellie
Type: Dog
Color: Brown/tan
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on NW 6th Drive, Ankeny, IA going towards Sailorville. $200 REWARD IF FOUND!!!!
Ankeny
Found: 8/25/2017
ID: 6600
Name: Ellie
Type: Dog
Color: Brown/tan
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on NW 6th Drive, Ankeny, IA going towards Sailorville. $200 REWARD IF FOUND!!!!
Ankeny
Found: 8/25/2017
ID: 6596
Name: Ellie
Type: Dog
Color: Tan/brown
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Was lost at Praire Trail neighborhood in Ankeny. She is very small and skiddish
Des Moines - South
Found: 8/25/2017
ID: 6592
Name: unknown
Type: Cat
Color: white
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
She walked in to car dealership at 4611 SW 9th st Des Moines
Ankeny
Found: 8/24/2017
ID: 6612
Name:
Type: Cat
Color: Grey/black/tan tiger striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Came onto our deck in NW Ankeny. Very Friendly. Vet said he is neutered.
Ankeny
Found: 8/24/2017
ID: 6590
Name: Hope
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Went to call in the other two cats and she was there on the porch. She found her way home.
Ankeny
Found: 8/24/2017
ID: 6589
Name: Hope
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
We went to call for the other two cats to come in and she was there at the door.
Ankeny
Found: 8/24/2017
ID: 6587
Name: Unknown
Type: Cat
Color: Grey/black/tan tiger striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Came up to our deck door at our house in Ankeny. Hesitant at first. After feeding became super affectionate. Vet did not find a microchip when scanned.
Des Moines - South
Found: 8/23/2017
ID: 6575
Name: Dakota
Type: Dog
Color: White with dark ears
Breed: Great Pyrenees
Gender: Female
Fixed: Neutered
Age: Senior
She came back this morning. Thank you all.
Bondurant
Found: 8/22/2017
ID: 6559
Name:
Type: Cat
Color: Black and orange
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
Very sweet, doesn't like strange cats. Was very hungry when we found her
Grimes
Found: 8/22/2017
ID: 6554
Name: King
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Found: 8/21/2017
ID: 6565
Name:
Type: Dog
Color: Yellow
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Young
See photo for comments
Ankeny
Found: 8/21/2017
ID: 6547
Name:
Type: Dog
Color:
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Young
Found along Oralabor, no collar
Des Moines - East
Found: 8/18/2017
ID: 6511
Name:
Type: Dog
Color: Brown white black
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
If you know anything about this dog or the dog is yours please text me describing the collar
West Des Moines
Found: 8/15/2017
ID: 6489
Name:
Type: Dog
Color: Black with White Chest
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Senior
I believe this male dog is older as he is a bit slow and has grey on his face. He is very well mannered and gentle. He looks like he is around 70lbs. I will try to post a photo soon.
Ankeny
Found: 8/14/2017
ID: 6775
Name:
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Young
She's front declawed and very sweet!
Des Moines - South
Found: 8/14/2017
ID: 6487
Name: Peanut
Type: Dog
Color: Tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
Had tag with rabies info,that's how I found out hisname. Vet had no current contact information.
Norwalk
Found: 8/14/2017
ID: 6482
Name:
Type: Cat
Color: Black
Breed: Chihuahua Long Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
Idk if this is a stray or ferrel but if you think it's your cat please let me know
Urbandale
Found: 8/14/2017
ID: 6478
Name: Ivy
Type: Dog
Color: Brown and White
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
Last seen in our yard at 8106 Madison Ave around 4:30. Had just gotten home from a walk and she acted tired so we came home. Guess she still had adventures in mind...