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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Missouri Valley
Lost: 9/14/2017
ID: 6797
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.
Walker
Lost: 9/14/2017
ID: 6791
Name: Leona
Type: Dog
Color: black brindle
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Adult
very friendly, will lay-over for belly rubs
Des Moines - East
Lost: 9/13/2017
ID: 6785
Name: Toku
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Last seen in backyard. Checked on him and he was gone and gate was open.
Des Moines - North
Lost: 9/11/2017
ID: 6779
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Missouri Valley
Lost: 9/10/2017
ID: 6799
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/10/2017
ID: 6796
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.
Crescent
Lost: 9/10/2017
ID: 6795
Name: ELSA
Type: Dog
Color: Grey, Brown, White Spots
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 Rest Area Eastbound I-680 at 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.
Des Moines - South
Lost: 9/10/2017
ID: 6776
Name: Blu
Type: Cat
Color: Gray tabby
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly . He would walk up to anyone. He's a house cat so he is not used to the outside.