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>='1571184000')) ORDER BY pm1.meta_value DESC, post_date DESC
Colfax
Lost: 9/21/2017
ID: 6862
Name: Koda
Type: Dog
Color: Brown
Breed: Shar Pei
Gender: Male
Fixed: Unknown
Age: Young
He broke off his chain we think early in the morning and haven’t been back since WE HAVE A CASH REWARD IF FOUND!!! He’s our baby and we hope he’s okay.
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
Ackley
Lost: 9/19/2017
ID: 6879
Name: Cocoa and Rosie
Type: Dog
Color: Chocolate labs
Breed: Labrador Retriever
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Our dogs are 7-year old litter mates. They were last home Monday evening. They are chocolate labs. One dog is heavier both good natured and loving.
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$$$$. UDATE : mother has been found and Sammie male is still missing.
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
Des Moines - East
Lost: 9/17/2017
ID: 6838
Name: Red
Type: Cat
Color: Red calico orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
On east 15th and vine
Ankeny
Lost: 9/17/2017
ID: 6825
Name: Opie/Simba
Type: Dog
Color: Charcoal grey
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Young
Lost at rest stop north of Ankeny on I-35. PLEASE dont mistake his fear as aggression.
Des Moines - South
Lost: 9/17/2017
ID: 6821
Name: Besos
Type: Dog
Color: White
Breed: Great Dane
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 9/17/2017
ID: 6820
Name: Besos
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Lost: 9/16/2017
ID: 6814
Name: Duck
Type: Dog
Color: Tan and White
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Baby
He's super friendly
Urbandale
Lost: 9/16/2017
ID: 6813
Name: Duck
Type: Dog
Color: Tan and white
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
He's extremely friendly
Urbandale
Lost: 9/15/2017
ID: 7075
Name: Tigger
Type: Cat
Color: Grey and Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at the Westpointe Apartments, 7605 Buckingham Square, Urbandale, IA. It should be noted that Tigger is very skittish of people and will not likely just come up to you. She has been gone for over a month now and we really want her home safely. Thanks.
Des Moines - East
Lost: 9/15/2017
ID: 6823
Name: Emma
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She almost always comes home when I whistle, but has been gone 2 days now. Scared of most people.
Des Moines - Central
Lost: 9/15/2017
ID: 6806
Name: Kiki
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Kiki was last seen in the 1300 block of 46th st. In des Moines.
Des Moines - Central
Lost: 9/15/2017
ID: 6805
Name: Kiki
Type: Dog
Color: Brinfle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Kiki was lost in the 1300 block of 46th st in des Moines.
Rural Polk County
Lost: 9/15/2017
ID: 6802
Name: “Animal”
Type: Dog
Color: Black & white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Brown eyes. Beautiful markings. Very sweet boy. Loves people and loves to run, jump, and apparently go on adventures. He broke off his cable and may have a portion of a red cable connected to his choker. We miss him so much. Please contact us with any information or if you think you have spotted him in your area.
Rural Polk County
Lost: 9/15/2017
ID: 6801
Name: “Animal”
Type: Dog
Color: Black & white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Brown eyes. Beautiful markings. Very sweet boy. Loves people and loves to run, jump, and apparently go on adventures. He broke off his cable and may have a portion of a red cable connected to his choker. We miss him so much. Please contact us with any information or if you think you have spotted him in your area.
Brooklyn
Lost: 9/14/2017
ID: 6906
Name: Domino
Type: Cat
Color: Black&white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
At the Pilot gas station between Victor and Brooklyn he has a small notch out of his right ear and is shy.
Urbandale
Lost: 9/14/2017
ID: 6860
Name: Tigger
Type: Cat
Color: Black and Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Tigger can be skittish and doesn't like most people. Please call if seen.