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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - North
Lost: 9/9/2017
ID:
Name: Bella
Type: Dog
Color: Tan with white paws
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
She's only 4 months old she's super friendly and short! gate was left open so she ran we all miss her very much at home if anyone see her or knows anything please call (515)350-8445 we will find her!!
Des Moines - North
Lost: 9/9/2017
ID: 6774
Name: Bella
Type: Dog
Color: Tan with white paws
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
She's only 4 months old she's super friendly and short! gate was left open so she ran we all miss her very much at home if anyone see her or knows anything please call (515)350-8445 we will find her!!
Des Moines - North
Lost: 9/9/2017
ID: 6773
Name: Bella
Type: Dog
Color: Tan with white paws
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
Shes only 4 months she has white paws super friendly girl we all miss her so much kids at home left back gate open so she got away but we will find her!!!
Des Moines - South
Lost: 9/9/2017
ID: 6757
Name: Adonis
Type: Cat
Color: White and black
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around Weston Park Apartments... he's very friendly and will approach you if you call his name or shake a bag of treats.
Ankeny
Lost: 9/9/2017
ID: 6755
Name: Perry
Type: Cat
Color: Black/gray and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Perry was last seen in the SW block of Sharmin dr- he is VERY friendly and will come when called
Ankeny
Lost: 9/9/2017
ID: 6754
Name: Perru
Type: Cat
Color: Black/gray and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Perry was last seen in the SW block of Sharmin dr- he's VERY friendly and will come when called
Des Moines - Central
Lost: 9/8/2017
ID: 7098
Name: Exene
Type: Cat
Color: Grey and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Went missing approx a month ago. Posting again. We miss her so much. Went missing from 23rd and Forest
Des Moines - Central
Lost: 9/8/2017
ID: 6855
Name: Ace
Type: Dog
Color: Black and Brown
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
Near Drake