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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Iowa City
Lost: 3/21/2019
ID: 10782
Name: Bobo
Type: Cat
Color: tortoise shell - black and orange
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
very friendly, green eyes, will come when offered food
Des Moines - South
Lost: 3/21/2019
ID: 10780
Name: Cricket
Type: Dog
Color: Tri-color
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Left for work-came home and the screen was out of my window and my eleven month old puppy was missing. Speckled face, licks a lot/very friendly.
Des Moines - South
Lost: 3/21/2019
ID: 10779
Name: Unknown
Type: Dog
Color: Black white tan
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Indianola ave and 1st street on south side of Des Moines
Des Moines - Central
Lost: 3/20/2019
ID: 10788
Name: Hershel
Type: Cat
Color: Orange tabby
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Cross streets 16th and College, early morning. Recently moved. Previous residence cross streets Euclid Ave and 12th, may have tried to find his way back there. All claws. Wearing same collar as picture. Sweet, fluffy, timid.
Des Moines - South
Lost: 3/20/2019
ID: 10784
Name: Mia
Type: Cat
Color: Brown, black, and white
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
A friend accidentally let her out thinking she was an outdoor cat but didn’t let us know.
Cumming
Lost: 3/19/2019
ID: 10873
Name: Bear
Type: Dog
Color: white
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Young
130th-Warren Ave, Cumming IA
West Des Moines
Lost: 3/19/2019
ID: 10789
Name: Margot
Type: Cat
Color: white bottom, gray/black on top, black mustache on left side of mouth
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
In Valley Junction area of West Des Moines, Iowa Mix of tabby and calico. Calico on bottom and Tabby on back.
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