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>='1565568000')) ORDER BY pm1.meta_value DESC, post_date DESC
Bondurant
Found: 7/20/2019
ID: 11924
Name:
Type: Cat
Color: Orange white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Found: 7/17/2019
ID: 11902
Name:
Type: Dog
Color: White & Tan
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Elkhart
Found: 7/17/2019
ID: 11901
Name:
Type: Dog
Color:
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Adult
Very sweet, well behaved girl.
Des Moines - South
Found: 7/17/2019
ID: 11893
Name: Unknown
Type: Dog
Color: Black/Brown
Breed: German Shepherd/Purebred
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Ankeny
Found: 7/15/2019
ID: 11886
Name: Mojo
Type: Dog
Color: Black
Breed: Pinscher
Gender: Male
Fixed: Not Neutered
Age: Senior
I found mojo !! He was stuck in the garage .
Des Moines - Central
Found: 7/13/2019
ID: 11864
Name: Edward
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
I found my son!!!
Des Moines - North
Found: 7/11/2019
ID: 11899
Name:
Type: Cat
Color: grey and white
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Showed up on our deck. We live in Saylorville Township. Is not afraid of people, very friendly.
Urbandale
Found: 7/11/2019
ID: 11854
Name: Batman
Type: Cat
Color: White & Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
FOUND HIM
West Des Moines
Found: 7/11/2019
ID: 11852
Name:
Type: Cat
Color: Grey and Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
400 block of 1st Street
Des Moines - Central
Found: 7/11/2019
ID: 11845
Name: Normin
Type: Cat
Color: Black and White
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Found: 7/10/2019
ID: 11831
Name: Buster
Type: Dog
Color:
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 7/8/2019
ID: 11908
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Date found probably isn't accurate, I don't remember exactly when he/she started coming around. Not sure if he/she was dumped or if someone is missing them.
West Des Moines
Found: 7/8/2019
ID: 11816
Name: Tucker
Type: Cat
Color: Buff/White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
7600 block of Office Plaza
West Des Moines
Found: 7/8/2019
ID: 11811
Name:
Type: Cat
Color: Orange/White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
Very friendly orange and white cat showed up at our apt near valley junction, has claws.
Urbandale
Found: 7/7/2019
ID: 11804
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found at Bank of America ATM on 86th St.
Urbandale
Found: 7/6/2019
ID: 11791
Name:
Type: Dog
Color:
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
7020 Rocklyn Circle
Urbandale
Found: 7/6/2019
ID: 11790
Name:
Type: Dog
Color: brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Adult
7020 Rocklyn Circle
Ankeny
Found: 7/6/2019
ID: 11788
Name: Jinx
Type: Dog
Color: black and white
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
She will be with our Goldendoodle Joey. She never leaves his side.
Ankeny
Found: 7/6/2019
ID: 11787
Name: Joey
Type: Dog
Color: cream
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Adult
I let them out this morning in our yard and they some how got out of the fence. They typically stick around our neighborhood, but I can't find them anywhere.
Des Moines - South
Found: 7/5/2019
ID: 11780
Name:
Type: Cat
Color:
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Baby
Dallas Center
Found: 7/4/2019
ID: 11772
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Adult
2 female GSD found north of Dallas Center. Are safe in rescue volunteers home. Must provide proof of ownership to claim
Carlisle
Found: 7/4/2019
ID: 11765
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Indianola
Found: 7/4/2019
ID: 11764
Name:
Type: Dog
Color: White and brown
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 7/3/2019
ID: 11756
Name: Patches
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Baby
Found by miracle baseball field. If shes yours please have proof.
Des Moines - Central
Found: 7/3/2019
ID: 11755
Name: Patches
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Baby
Found downtown by miracle baseball field. If shes yours please have proof .