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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 7/24/2019
ID: 11951
Name: Blue
Type: Dog
Color: White with black and brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Lost: 7/24/2019
ID: 11947
Name: Salem
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen this morning on 13th and Laurel over by dmacc urban kinda when I left kids left back door open and she got out she's huge and pregnant if anybody sees her please call reward offered
Des Moines - Central
Lost: 7/23/2019
ID: 11977
Name: Lilly
Type: Dog
Color: Brown and white long haired
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly will come to her name
Des Moines - North
Lost: 7/23/2019
ID: 11939
Name:
Type: Dog
Color: Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Adult
Found dog on Lower Beaver and VILURA Parkway
Ankeny
Lost: 7/23/2019
ID: 10709
Name: Lil Chubs AKA Monster Man
Type: Cat
Color: Brown, black tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
This little guy went missing on 1/11/19 from SW Reunion Cir, Ankeny. (Near the Kum & Go on Oralabor) We still have not found him and we miss him terribly! . He is microchiped, so not at the ARL. If seen please call 515-974-7443
Des Moines - East
Lost: 7/22/2019
ID: 11927
Name: gypsy rose
Type: Cat
Color: gray and off white
Breed: Tiger
Gender: Female
Fixed: Unknown
Age: Young
got out the back door without us knowing it. 3mo old and small
West Des Moines
Lost: 7/21/2019
ID: 11989
Name: Bosco
Type: Dog
Color: White with tan patches
Breed: Great Pyrenees
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 7/21/2019
ID: 11973
Name: Harley
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
MLK
Jamaica
Lost: 7/21/2019
ID: 11945
Name: Mater
Type: Dog
Color: Red
Breed: Red Heeler
Gender: Male
Fixed: Not Neutered
Age: Senior
He is microchipped but the address might either be Australia or Missouri. He likes people and loves kids. He is deaf and half blind. Not friendly with other male dogs. Reward if returned home safe. Please contact Cherise at 515-991-9723
Ionia
Lost: 7/21/2019
ID: 11938
Name: ROSCO
Type: Dog
Color: White, With brown spots
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
Was last seen at chickasaw state park quarry! Pretty sure someone in a matte black BMW With red rims took him.
Ankeny
Lost: 7/21/2019
ID: 11930
Name: Snuggles
Type: Cat
Color: Brown tabby
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Adult
She was last seen at 1005 SE Belmont Dr in Ankeny and she’s very skittish
Ames
Lost: 7/21/2019
ID: 11922
Name: Remi
Type: Dog
Color: Liver Roan
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
Last seen on the south side of Ames. She has an odd bump on the top of her head. She is small and very skinny she would be mistaken for hungry or malnourished.
West Union
Lost: 7/21/2019
ID: 11921
Name: Ryder and Tucker (both missing)
Type: Dog
Color: Black lab and brown Shepard mix
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Last seen on the north edge of town in West Union on Hall Street. Seen by both neighbors, but no one else. Good chance they went north into the fields.
Ames
Lost: 7/21/2019
ID: 11920
Name: River
Type: Dog
Color: Black
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
River has severe epilepsy & could die without her medications. She will start having cluster seizures tonight without her 2 meds & 3 supplements.
Des Moines - North
Lost: 7/20/2019
ID: 11986
Name: Pancake
Type: Cat
Color: Tan, white, black calico longhair
Breed: Calico
Gender: Unknown
Fixed: Not Neutered
Age: Young
Lost from home on the border of Ankeny/Saylorville/N Des Moines area. May be skittish to strangers but is friendly. Black color surrounding one eye
Pleasant Hill
Lost: 7/20/2019
ID: 11953
Name: Zyla
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
Last seen Saturday, July 20. Very friendly pet. Shedding a lot. Has a regular collar and electric fence collar.
Des Moines - Central
Lost: 7/20/2019
ID: 11952
Name: Jasper
Type: Cat
Color:
Breed: Dilute Tortoiseshell
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 9am on july 20th 2019. In the 2400 block of East Capitol. He has a white flea collar on.
Redfield
Lost: 7/20/2019
ID: 11937
Name: Maggie
Type: Dog
Color: BLK/BRN
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Young
Earlham
Lost: 7/20/2019
ID: 11936
Name: Maggie
Type: Dog
Color: Reverse Brindle
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Adult
Maggie is very friendly but can be aggressive with other dogs.
Ankeny
Lost: 7/20/2019
ID: 11933
Name: Pete
Type: Cat
Color: Tortoise shell
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Missing from the NE side of Ankeny off Ankeny Blvd
Des Moines - Central
Lost: 7/20/2019
ID: 11931
Name: Karma
Type: Dog
Color: Brindle
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
29th/cottage grove
Ankeny
Lost: 7/20/2019
ID: 11928
Name: Finn
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 7/20/2019
ID: 11926
Name: Aslan
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
He is very cuddly and loves people. He has a poofy tail and is larger than your regular house cat.
Adel
Lost: 7/20/2019
ID: 11914
Name: Babe
Type: Dog
Color: Tan and Black
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 7/20/2019
ID: 11911
Name: Salem
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Just about an hour ago but he got outside and now he can't be found. He is not supposed to be outside and is declawed by previous owners.