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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
Humboldt
Lost: 6/19/2016
ID: 3201
Name: Toffee
Type: Dog
Color: whiteish tannish
Breed: Rat Terrier
Gender: Female
Fixed: Unknown
Age: Young
Washta
Lost: 6/18/2016
ID: 3204
Name: Vester/Vefer
Type: Cat
Color: Black/brown/stripped/white
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Is special needs so he does walk like he's falling over and shakes. Will run if you try to approach him.
Westfield
Lost: 6/17/2016
ID: 3218
Name: Devland
Type: Dog
Color: Tan/white
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
Running south of Westfield through corn fields. He's very scared and shy. No loud noises and soft slow voices. He has white paws, white chest and white tip on his tail.
Des Moines - East
Lost: 6/17/2016
ID: 3191
Name: Blu
Type: Dog
Color: White with grey markings
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on 6/17 630am. Was told a man in a blue truck stop and asked a lady if he belonged to her. He is also my therapy dog for PTSD
Des Moines - South
Lost: 6/17/2016
ID: 3188
Name: Ice
Type: Dog
Color: White
Breed: Samoyed
Gender: Male
Fixed: Neutered
Age: Senior
Lost from friends homes on Park Ave. Collar was missing. Ice is very sweet, and loved by everyone he meets, but mostly by his girl,Jillian. Please catch him if you can and contact me, Afford A Care Pet Hospital and the ARL if you see him.
Des Moines - South
Lost: 6/17/2016
ID: 3187
Name: Ice
Type: Dog
Color: White
Breed: Samoyed
Gender: Male
Fixed: Neutered
Age: Baby
Last seen on Park Ave in Des Moines, south. Super sweet and very loved. If you see him, please hold him and contact me or report to Afford a Care Pet Hospital or the ARL as he is chipped.
Des Moines - East
Lost: 6/16/2016
ID: 3205
Name: leo
Type: Dog
Color: tricolor
Breed: Hound
Gender: Male
Fixed: Unknown
Age: Young
Last seen around 9:00 thursday he is a non neutered pupp and would like to keep it that way and get him home safe
Des Moines - East
Lost: 6/16/2016
ID: 3183
Name: Patch
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Slipped out of his collar when digging under the fence. Last seen on 51st CT Des Moines. Friendly dog, tail has a "kink" in it from puppy hood injury.
Des Moines - North
Lost: 6/16/2016
ID: 3172
Name:
Type: Dog
Color:
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
Ankeny
Lost: 6/15/2016
ID: 3253
Name:
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Senior
1507 nw 22nd Lane Ankeny,iowa 50023
Des Moines - North
Lost: 6/15/2016
ID: 3252
Name: Miss kitty
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Yard, very loving
Des Moines - East
Lost: 6/15/2016
ID: 3251
Name: Miss kitty
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
She was feeding kittens. Very loving. Might of been brought into ARL bye Lisa judge! 2 black kittens came up missing the same time.
Des Moines - East
Lost: 6/15/2016
ID: 3156
Name: Izzy
Type: Dog
Color: Black and white
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen around E 39th and Douglas. She is very scared and won't come to people. Please don't approach her please call 515- 867-8315
Des Moines - North
Lost: 6/15/2016
ID: 3154
Name:
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Found at 16th and douglas
Des Moines - North
Lost: 6/14/2016
ID: 3200
Name: Bear
Type: Dog
Color: Black with white patchocolate on the chest
Breed: Cane Corso Mastiff
Gender: Male
Fixed: Unknown
Age: Young
Last seen off of 12th and Euclid. We believe he was dognapped as he does not leave the yard. If seen please call 515-357-2988.
Des Moines - North
Lost: 6/14/2016
ID: 3199
Name: Bear
Type: Dog
Color: Black with white patchocolate on the chest
Breed: Cane Corso Mastiff
Gender: Male
Fixed: Unknown
Age: Young
Last seen off of 12th and Euclid. We believe he was dognapped as he does not leave the yard. If seen please call 515-357-2988.
Grimes
Lost: 6/13/2016
ID: 3232
Name: Sophie
Type: Cat
Color: White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She loves being outdoors and is a big hunter. Sophie is very smart and always returns home, but can tend to venture far out on our property. We think someone picked her up thinking she was a stray because we live on a HWY. She has green eyes and is white, but a dirtier white because she is outdoors so often. She also has a full set of claws.
Dallas Center
Lost: 6/13/2016
ID: 3229
Name: Sophie
Type: Cat
Color: white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She loves being outdoors and is a big hunter. Sophie is very smart and always returns home, but can tend to venture far out on our property. We think someone picked her up thinking she was a stray because we live on a HWY. She has green eyes and is white, but a dirtier white because she is outdoors so often.
Des Moines - East
Lost: 6/13/2016
ID: 3196
Name: Burt
Type: Cat
Color: Brown tip
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
Very scared was chased by a dog. Shy cat
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