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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - West
Lost: 9/14/2017
ID: 6829
Name: Cali
Type: Cat
Color: Black with orange
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Beaverdale 35th and Hickman
Missouri Valley
Lost: 9/14/2017
ID: 6800
Name: ELSA
Type: Dog
Color: Grey, White Spots, Black Ears, Light Brown Legs
Breed: Blue Heeler
Gender: Female
Fixed: Neutered
Age: Young
UPDATE: Last seen on Thursday, 9/14/17 at 8:00am, approximately 2 miles SOUTH of Missouri Valley on Loess Hills Trail. "Elsa" jumped out of owner's pickup truck window while stopped at "Missouri Valley Restarea Eastbound I-680" past Loveland near 185th St & Whippoorwill Dr. She did not have her collar on. She is very sweet but timid with strangers. Her family is devastated and desperate to find her. Please call Jack @ 402.598.5080 or Alex @ 402.740.6478 with any information. We're actively searching the area everyday and have distributed hundreds of fliers to local police & fire departments, residents, businesses, restaurants & bars, etc. The Midlands Humane Society, Nebraska Humane Society, all local Animal Shelters and Police have been notified.
Missouri Valley
Lost: 9/14/2017
ID: 6798
Name: ELSA
Type: Dog
Color: Grey, White Spots, Black Ears, Light Brown Legs
Breed: Blue Heeler
Gender: Female
Fixed: Neutered
Age: Young
UPDATE: Last seen on Thursday, 9/14/17 at 8:00am, approximately 2 miles SOUTH of Missouri Valley on Loess Hills Trail. "Elsa" jumped out of owner's pickup truck window while stopped at "Missouri Valley Restarea Eastbound I-680" past Loveland near 185th St & Whippoorwill Dr. She did not have her collar on. She is very sweet but timid with strangers. Her family is devastated and desperate to find her. Please call Jack @ 402.598.5080 or Alex @ 402.740.6478 with any information. We're actively searching the area everyday and have distributed hundreds of fliers to local police & fire departments, residents, businesses, restaurants & bars, etc. The Midlands Humane Society, Nebraska Humane Society, all local Animal Shelters and Police have been notified.