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>='1560384000')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 3/19/2019
ID: 10765
Name: Mufasa
Type: Cat
Color: Cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
I shaved him like a little lion. Last at 562 16th st WDM IA 50265
Des Moines - East
Lost: 3/19/2019
ID: 10763
Name: Champion mo buddy baker
Type: Dog
Color: Yellow
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 3/18/2019
ID: 10853
Name: Morris
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He was last seen near the corner 41st St and Boyd St on the east side of Des Moines. He’s very shy when he’s scared and tends to hide. The whiskers on the left side of his face are slightly shorter than the ones on his right (when looking at him head on). He’s my ESA so it’s crucial that I get him back because I really need him.
Jesup
Lost: 3/18/2019
ID: 10769
Name: Luna
Type: Dog
Color: White w/ Cream Markings
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Will answer to Luna, if wearing Collar veteranarian Contact is on it, last seen after she was let out to go to the bathroom with older male black Labrador. She is only 4 months old.
Des Moines - West
Lost: 3/18/2019
ID: 10768
Name: Bear
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - West
Lost: 3/18/2019
ID: 10767
Name: Bear
Type: Cat
Color: Black
Breed: Oriental Long Hair
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - West
Lost: 3/18/2019
ID: 10766
Name: Bear
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
I see him before iam going to my work 10 pm
Des Moines - North
Lost: 3/18/2019
ID: 10761
Name: Polo
Type: Dog
Color: White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Broke his cable type chain and jumped the fence. Should have chain piece still attached to collar.
Waukee
Lost: 3/18/2019
ID: 10759
Name: Mazie
Type: Dog
Color: Black with slight gray under her chin
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Senior
near 125 NE Venture Drive in Waukee
Des Moines - North
Lost: 3/17/2019
ID: 10774
Name: Zeus
Type: Dog
Color:
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Has tag with Zeus and owners phone number. He also has a birthmark on the roof of his mouth.
Dubuque
Lost: 3/17/2019
ID: 10771
Name: Lilly Beth
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Senior
Fussy around new people. Answers to momma and lil bear.
Urbandale
Lost: 3/17/2019
ID: 10758
Name: Hemi
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Very loving and comes to his name . Grumpy when he’s hungry.
Agency
Lost: 3/17/2019
ID: 10755
Name: Skye
Type: Dog
Color: Tricolor
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Young
New Virginia
Lost: 3/17/2019
ID: 10754
Name: Maddie
Type: Dog
Color: White and tan
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
On Church Street in New Virginia IA
Des Moines - North
Lost: 3/17/2019
ID: 10753
Name:
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
Found dragging chain. No tags.
Dubuque
Lost: 3/16/2019
ID: 10756
Name: Adrien
Type: Cat
Color: Dark Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen Saturday evening , March 16, 2019. Adrien is extremely affectionate and will cuddle up to anyone. She went missing in the Barony Woods area of Dubuque, Iowa.
West Des Moines
Lost: 3/16/2019
ID: 10748
Name: Bob
Type: Cat
Color: Brown striped
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Senior
Bob is declawed, he is deaf, he is missing a thing, he is upwards of 17 years old. He is an incredibly sweet cat and if you put your fist out he will take his head and fist bump you. We love them and we want him home. He must’ve gotten out when one of our kids left the door open. Bob is declawed, he is deaf, he is missing a saying, he is upwards of 17 years old. He is an incredibly sweet cat and if you put your fist out he will take his head and fist bump you. We love him and we want him home. He must’ve gotten out when one of our kids left the door open. We are near the Ashworth and 60th St. intersections in West Des Moines.
Clive
Lost: 3/16/2019
ID: 10745
Name: Beckham
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Got out of house between 3:30 and 5pm
Des Moines - East
Lost: 3/16/2019
ID: 10744
Name: Gypsy
Type: Dog
Color: Black and brownish white
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Applicable
Age: Young
E 25th ct and Onawa Des Moines IA
Clive
Lost: 3/16/2019
ID: 10743
Name: Luna
Type: Dog
Color: Black white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
Clive
Lost: 3/16/2019
ID: 10742
Name: Luna
Type: Dog
Color: Black and white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
Near the flats apartments
Des Moines - Central
Lost: 3/15/2019
ID: 11035
Name: Elmo
Type: Cat
Color: Black with white on both back feet
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
When weather 1st started getting warm I let him out.
Dubuque
Lost: 3/15/2019
ID: 10773
Name: Scout
Type: Cat
Color: Orange/White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He’s very vocal and friendly.
Des Moines - North
Lost: 3/15/2019
ID: 10747
Name: Rex
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 3/15/2019
ID: 10746
Name: Lobito
Type: Dog
Color:
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Baby
Left eye brown right eye blue