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>='1585785600')) ORDER BY pm1.meta_value DESC, post_date DESC
Johnston
Lost: 3/17/2020
ID: 13585
Name: Kiba
Type: Dog
Color: Brindle
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Lawson Elementary
Des Moines - Central
Lost: 3/16/2020
ID: 13601
Name: Artemis Moon
Type: Cat
Color: Black, Gray & Brown Tiger
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
Artie is friends with all of the neighbors, he is an indoor/outdoor cat, he is very friendly. Location Des Moines, Ia.
Windsor Heights
Lost: 3/16/2020
ID: 13592
Name: Benji
Type: Cat
Color: grey/white stripe
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Waukee
Lost: 3/16/2020
ID: 13584
Name: Khaos
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen in our home near the Waukee highschool. He is SO sweet! He gives love nibbles and purrs a lot, Adopted from the ARL over a year ago. We miss him and our other cat keeps waiting by the door. Please please contact me if found.
Des Moines - East
Lost: 3/16/2020
ID: 13580
Name: DeOGe, yes DOG
Type: Dog
Color: BRINDLE/WHITE
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
On lead in front yard on E Washington.
Urbandale
Lost: 3/15/2020
ID: 13708
Name: Mattie aka mattcat
Type: Cat
Color: Grey with white chest and stomach markings
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
We lost everything in an apartment fire and unfortunately he was inside and I was unable to get him out but his remains were not found so we are being optimistic he is alive! His left eye is a little fuzzy not as clear as the other eye and has a bikini like shaped white marking on his stomach and white marking on chest! He is 13 pounds and microchipped last seen at the apartment building of ashford ridge at 3600 Patricia Dr Urbandale ia!
West Des Moines
Lost: 3/15/2020
ID: 13589
Name: Misha
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
She slips out our door every time any one opens it so it’s hard to keep her inside. She is friendly but playful. She will do a play nibble but lick you immediately after as if she feels bad for biting.
Des Moines - North
Lost: 3/14/2020
ID: 13594
Name: Ruby
Type: Cat
Color: Black/white
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
38th and Valdez, DSM
Des Moines - South
Lost: 3/14/2020
ID: 13567
Name: Brutus
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
Sw16th and McKinley Ave he is super friendly loves water.
Des Moines - Central
Lost: 3/13/2020
ID: 13564
Name: Katie k8
Type: Dog
Color: Brown tan and black
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
If found please call 5158651385
Des Moines - East
Lost: 3/13/2020
ID: 13563
Name: Blue
Type: Dog
Color: Light brown and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Last seen near Euclid and 2nd
Des Moines - North
Lost: 3/13/2020
ID: 13561
Name: Leia
Type: Cat
Color: White , brown , beige
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Baby
29th st
Des Moines - Central
Lost: 3/13/2020
ID: 13558
Name: Chloe
Type: Dog
Color: Black
Breed: Pomeranian
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 3/13/2020
ID: 13553
Name:
Type: Dog
Color: White and brown spots
Breed: American Bulldog
Gender: Unknown
Fixed: Unknown
Age: Baby
Ne aurora
Lacona
Lost: 3/12/2020
ID: 13568
Name: Pearl
Type: Dog
Color: White/tan
Breed: American Bulldog
Gender: Unknown
Fixed: Not Neutered
Age: Young
She got out of her pin with the other dog that lives there also.
Altoona
Lost: 3/12/2020
ID: 13552
Name: Marley
Type: Dog
Color: Black/Brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Please call 515.554.3066 or 515.210.2524
Des Moines - North
Lost: 3/12/2020
ID: 13550
Name: Max
Type: Dog
Color: Black and white and brown
Breed: Bichon Frise
Gender: Male
Fixed: Not Neutered
Age: Adult
Extremely friendly and will come when called. Please call ASAP
Des Moines - North
Lost: 3/11/2020
ID: 13557
Name: Kevin
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
got out of the house near NW 50th Street, Des moines 50310
Des Moines - Central
Lost: 3/11/2020
ID: 13556
Name: Kevin
Type: Cat
Color: Orange Tabby
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Very friendly cat, got out of the house around NW. 50th Street, Des Moines
Des Moines - North
Lost: 3/11/2020
ID: 13546
Name: Zelda
Type: Dog
Color: brown/white
Breed: American Staffordshire Terrier
Gender: Unknown
Fixed: Neutered
Age: Adult
She's very nice and great with humans!
Des Moines - South
Lost: 3/10/2020
ID: 13541
Name: Leo
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 3/10/2020
ID: 13535
Name: Charlie
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Is skittish and hates plastic bags. Will come to, "Charlie, Charlie."
Pleasant Hill
Lost: 3/9/2020
ID: 13583
Name: Nala
Type: Dog
Color: White
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Young
1125 N Hickory Blvd At the Casey’s on the north side of University
Pleasant Hill
Lost: 3/9/2020
ID: 13582
Name: Nala
Type: Dog
Color: White
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Young
1125 N Hickory Blvd At the Casey’s on the north side of University
Pleasant Hill
Lost: 3/9/2020
ID: 13581
Name: Nala
Type: Dog
Color: White
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Young
1125 N Hickory Blvd At the Casey’s on the north side of University