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 = 'lost' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1562803200')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 7/17/2019
ID: 11898
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
6th and Locust
Ankeny
Lost: 7/17/2019
ID: 11897
Name: Reese
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Last seen this morning before leaving for work.
Des Moines - Central
Found: 7/17/2019
Animal ID: 175444
Des Moines - Central
Found: 7/17/2019
Animal ID: 175442
Des Moines - South
Lost: 7/17/2019
ID: 11895
Name: Simon
Type: Dog
Color: Brown and while
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Pleasant Hill
Found: 7/17/2019
Animal ID: 175458
Des Moines - Central
Found: 7/17/2019
Animal ID: 175365
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
Reasnor
Lost: 7/16/2019
ID: 11896
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Lamoni
Found: 7/16/2019
Animal ID: 175457
Ankeny
Lost: 7/16/2019
ID: 11892
Name: Kota Bear
Type: Dog
Color: Black with silver brindle
Breed: Akita
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen in Ankeny around the brick town @ piper apartments. He ran away around 10pm. When he ran away we tried to get him and we watching him get hit by a car. If u do find him he is most likely very injured
Des Moines - Central
Found: 7/16/2019
Animal ID: 175403
Des Moines - Central
Lost: 7/16/2019
ID: 11888
Name: Country
Type: Dog
Color: Black and White
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Young
Country was last seen on the 28th block between Cottage Grove and Kingman around 7am on July 16th. She is a very friendly dog. She recently started heart worm treatment and will need her medication soon. She is wearing a red collar along with a flea and tick collar.
Des Moines - Central
Found: 7/16/2019
Animal ID: 175397
Des Moines - Central
Found: 7/16/2019
Animal ID: 117660
Des Moines - Central
Found: 7/16/2019
Animal ID: 175400
Des Moines - Central
Found: 7/15/2019
Animal ID: 175342
Des Moines - Central
Lost: 7/15/2019
ID: 11887
Name: Willow
Type: Dog
Color: Black and tan
Breed: Rottweiler
Gender: Female
Fixed: Neutered
Age: Adult
Willow was last seen in the afternoon Monday, July 15th. She is incredibly friendly despite her Rottweiler-husky mix looks. She loves belly rubs, car rides, and treats, and can be enticed with any of the aforementioned. She has heterochromia (one blue eye, and one brown eye). If found please call Chris 319-429-1927 or Dillon 515-447-8358.
Des Moines - Central
Found: 7/15/2019
Animal ID: 175364
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/15/2019
Animal ID: 175323
Des Moines - Central
Found: 7/15/2019
Animal ID: 175324
Urbandale
Lost: 7/14/2019
ID: 11889
Name: Simbah
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He’s skidding if he doesn’t know you but very loving and talkative.
Des Moines - Central
Found: 7/14/2019
Animal ID: 175411
Des Moines - Central
Found: 7/14/2019
Animal ID: 175366