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
Des Moines - East
Lost: 6/13/2016
ID: 3195
Name: Bur5
Type: Cat
Color: Brown tip
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Baby
Very scared was chased by a dog. Shy cat
Des Moines - Central
Lost: 6/13/2016
ID: 3170
Name: Pierre
Type: Cat
Color: white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Pokey is his nick name. He is very shy scared or people. Walks with his head tilted (unsure why) . Super sweet. I miss him! Of you see him around the Des Moines Roosevelt area please let me know. Text 5156318295
Des Moines - North
Lost: 6/13/2016
ID: 3149
Name: Jack
Type: Dog
Color: Black
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Missing dog 12 to 14 yr old. Neutered. Has occasional seizures, needs to come home. His name is jack Last seen 6/13/2016 1700 block of 2nd Ave. Bull terrier mix Notify me to my sister Call or text jenny 5153616336
Des Moines - North
Lost: 6/13/2016
ID: 3140
Name: Jack
Type: Dog
Color: Black with white stipe on chest
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Has seizures. Needs to come home. Has lose permanent broken rib that will never heal. Do not pick him up or be rough with him.
Des Moines - North
Lost: 6/13/2016
ID: 3139
Name: Jack
Type: Dog
Color: Black with white stipe on chest
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Has seizures. Needs to come home. Has lose permanent broken rib that will never heal. Do not pick him up or be rough with him.
Des Moines - North
Lost: 6/12/2016
ID: 3137
Name: Bentley
Type: Dog
Color: Tawny
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 6/12/2016
ID: 3133
Name: Moe
Type: Cat
Color: White and black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Has a heart shaped spot on one side and an m shaped spot on the other
Swan
Lost: 6/11/2016
ID: 3150
Name: Sandy
Type: Dog
Color: Golden Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Swan area Highway 5 and 316. Reward offered for any information.
Fremont
Lost: 6/10/2016
ID: 3184
Name: Carlos
Type: Dog
Color: brown/black
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
Has serious heart murmor. Needs meds!!! Loves to give kisses
Des Moines - North
Lost: 6/9/2016
ID: 3762
Name: Sneakers
Type: Cat
Color: Brown/White/Grey Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in South Ankeny.
Preston
Lost: 6/9/2016
ID: 3164
Name: Copper
Type: Dog
Color: reddish brown
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
owners think he may have been picked up as he never wandered for long from home. missing from Iron Bridge Road area
Des Moines - South
Lost: 6/9/2016
ID: 3141
Name: Moxie
Type: Cat
Color: Brown grey black
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
We miss her so! Please contact if you see her at all. She went missing from 700 kirkwood ave (near sw 9th)
Des Moines - South
Lost: 6/9/2016
ID: 3132
Name: Moxie
Type: Cat
Color: Brown grey black
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
We just moved to a new house near Lincoln High school two weeks ago. Moxie is very near and dear to our children and offers anxiety support to our son on the autism spectrum. Moxie loves to hunt and as there is a wooded area behind our house i believe she may Have gotten lost back there. She has never been gone this long. We are offering a reward with her safe return.
Des Moines - North
Lost: 6/9/2016
ID: 3131
Name: Sneakers
Type: Cat
Color: Grey/White Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Has medical issues. Reward if found. Sighting off 66th st in saylorville!
Creston
Lost: 6/8/2016
ID: 3211
Name: Ox
Type: Dog
Color:
Breed: Australian Cattle Dog
Gender: Male
Fixed: Unknown
Age: Adult
LOST DOG: extremely urgent, this family loves and misses "Ox". The family lives in Stanton and came over for a cattle sale on June 8th. He's a medium size Heeler/Border Collie mix, 3 years old, dark colored with brown markings, he is friendly but probably scared, call Kit or Carolyn if you see him or know where he is, 712-829-2663; 712-370-6828.
Des Moines - West
Lost: 6/8/2016
ID: 3115
Name: PUERCO
Type: Dog
Color: GREY AND WHITE
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Baby
LAST SEEN ON 22 ST BEHIND KUM IN GO ON UNIVERSITY AVE WAS TOOKEN OFF FRONT PORCH OF HOUSE
Aspinwall
Lost: 6/8/2016
ID: 3110
Name: Bunny and Boo Boo
Type: Cat
Color: Orange
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Young
Farm in Aspinwall Iowa probably traveling together back to Bennington NE which would be Carroll and Harrison counties
Ankeny
Lost: 6/8/2016
ID: 3104
Name: Callie
Type: Cat
Color: White,black&orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Callie was last seen Sunday June 5th. It is unlike her to not be around home. We assume she is lost and can't find her way. shw is super sweet and very missed by her family. Please contact with any info 5152022672.
Ankeny
Lost: 6/8/2016
ID: 3103
Name: Callie
Type: Cat
Color: White,black&orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Callie was last seen Sunday June 5th. It is unlike her to not be home...we assume she is lost and can't find her way. She is super sweet and very missed by her family. Any info would be appreciated.
Council Bluffs
Lost: 6/7/2016
ID: 3355
Name: jasmine
Type: Cat
Color: Bio color
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
2o S 41st council Bluffs Iowa . THERE is a 500.00 reward
West Des Moines
Lost: 6/7/2016
ID: 3107
Name: Abbie
Type: Cat
Color: Grey Taby
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
Jumped out my bedroom window in the middle of the night
Council Bluffs
Lost: 6/6/2016
ID: 3354
Name: jasminene
Type: Cat
Color: SealBio color
Breed: Ragdoll
Gender: Female
Fixed: Neutered
Age: Adult
In the apt .thete is a 500.00 reward for her
Des Moines - Central
Lost: 6/5/2016
ID: 3081
Name: Freyja.
Type: Cat
Color: Black/white.
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Freya got out last night, and hasn't been seen since. She normally will stay in the yard, and has never been gone overnight. She is skitish, but very lovey.
Johnston
Lost: 6/5/2016
ID: 3079
Name: Sadie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in Johnston
Des Moines - East
Lost: 6/4/2016
ID: 3138
Name: Gary
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Has a white flea collar.