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' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1505520000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 9/21/2017
ID: 6853
Name:
Type: Dog
Color: 1 black & brown & 1 tan
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Running in Pioneer park & my yard for 2 day's
Adel
Lost: 9/20/2017
ID: 6854
Name: Pretty princess
Type: Dog
Color: Reverse bridle
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Senior
We let her outside at 7 am and called for her a half hour later but she never returned.. we've searched all around our area without any luck. She's a small breed terrier mix believed to be pregnant.. She also has seizures so we really need to find her. This it totally unlike her to run off. She's a very loyal, Sweet, loving little girl. Our family misses her so much and we are all worried sick about her. Any help would be appriciated. Please call day or night with any information 515-669-4986
Carlisle
Lost: 9/20/2017
ID: 6848
Name:
Type: Cat
Color: Orange/white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around the apartments by east casey's in carlisle.
West Des Moines
Lost: 9/20/2017
ID: 6843
Name: Trouble
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
White Oak Town homes 2259 Grand Ave WDM
Des Moines - Central
Lost: 9/18/2017
ID: 6846
Name: Sammie
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Baby
He was last seen in the 28th and cottage grove area. He is 9wks old and was with his mother who is also brindle and 11 years old. There is a $$REWARD$$$$
Des Moines - Central
Lost: 9/18/2017
ID: 6845
Name: Bella
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Unknown
Fixed: Not Applicable
Age: Senior
She was last seen around 4pm she was with her 9wk old puppy who is also brindle. Last seen in the area of 28th cottage grove. REWARD$$$
Des Moines - West
Lost: 9/18/2017
ID: 6842
Name: Sammie
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Baby
Unclipped tail white tip, all four paws are white as well
Des Moines - West
Lost: 9/18/2017
ID: 6841
Name: Bella
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Unknown
Fixed: Not Neutered
Age: Senior
West Des Moines
Lost: 9/18/2017
ID: 6832
Name: Lilly
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Young
Escaped from Turtle Creek apartments in West Des Moines
Des Moines - East
Lost: 9/17/2017
ID: 6839
Name: Red
Type: Cat
Color: Red calico orange and white
Breed: Tortoiseshell
Gender: Male
Fixed: Not Neutered
Age: Adult
On east 15th and vine