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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 6/26/2018
ID: 8957
Name: Dash
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 6/26/2018
ID: 8956
Name: Dash
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
He got off his leash and was running down Sw 14th st
Des Moines - South
Lost: 6/25/2018
ID: 8975
Name: Chaos
Type: Dog
Color: Black and white
Breed: American Bulldog
Gender: Male
Fixed: Not Applicable
Age: Young
On 1199 mason st. Also Amos, St. Southside des moines he can't be out in the heat very long ,he'll have heatsroke and could die....is that he is very much missed and is probably wondering where I'm at ...please bring him back
Des Moines - South
Lost: 6/25/2018
ID: 8969
Name:
Type: Dog
Color:
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Baby
He’s found .
Dubuque
Lost: 6/25/2018
ID: 8961
Name: Rosie
Type: Cat
Color: Black and white with orange by eyes
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Downtown Dubuque apartment by Post Office and Art Museum.
Des Moines - Central
Lost: 6/25/2018
ID: 8951
Name: Unknown
Type: Cat
Color: Black and white / tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Young
Reposting with pics because I could not edit the original. Very friendly intact male cried outside our door to come in from the storm. Obviously well loved and cared for, just got clean bill of health from our vet but no microchip. Please email myjennaration@gmail.com. Will likely take him to furry friends later today if cannot find his owner.
Cumberland
Lost: 6/25/2018
ID: 8939
Name:
Type: Dog
Color:
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Senior
Today
Des Moines - South
Lost: 6/24/2018
ID: 8937
Name: Jack
Type: Dog
Color: He’s white and has a brown faded spot on top of his head .
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Last seen by Howe elementary school he is a mean dog because he’s old and only listens to family so don’t try to pick him up if you see him just call ARl so they can get him if you see him or have heard anything please let me know !
Elkhart
Lost: 6/24/2018
ID: 8934
Name: mac
Type: Dog
Color: orange and white
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Adult
last seem 9am 6/24 with a husky. Both very friendly. and both have had there rabies shots. ( the black dog is NOT lost). mac is mircochipped5
Des Moines - North
Lost: 6/24/2018
ID: 8933
Name: MILO
Type: Dog
Color: White and blonde
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Senior
He is very old and frail but he's a good boy. He is on medication and needs it as soon as possible. His mommy and daddy and his little humans miss him very much.
Des Moines - North
Lost: 6/24/2018
ID: 8932
Name: MILO
Type: Dog
Color: White and blonde
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
He is very old and frail but he's a good boy. He is on medication and needs it as soon as possible. His mommy and daddy and his little humans miss him very much.
Des Moines - North
Lost: 6/24/2018
ID: 8930
Name: MILO
Type: Dog
Color: White and blonde
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
He is very old and frail. He is is on medication daily but didnt get it today so he really needs his medication.
Des Moines - North
Lost: 6/24/2018
ID: 8929
Name: MILO
Type: Dog
Color: White and blonde
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
He is very old and frail. He is is on medication daily but didnt get it today so he really needs his medication.
Des Moines - Central
Lost: 6/23/2018
ID: 8960
Name: Zen
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 25th and University.
Elkhart
Lost: 6/23/2018
ID: 8946
Name: Mack
Type: Dog
Color: Fawn/White
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
Last seen Saturday morning around 10a.m. he is very friendly he ran of with my Husky the husky was found this morning and is home safe He is microchip if seen please call 515-250-2908
New Virginia
Lost: 6/23/2018
ID: 8944
Name: Maggie
Type: Dog
Color: Brindle with White on face, chest, and paws
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Young
80th Ave New Virginia Iowa
Des Moines - West
Lost: 6/23/2018
ID: 8928
Name: Poo Poo
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Female
Fixed: Neutered
Age: Adult
10:30 A.M.
Des Moines - East
Lost: 6/23/2018
ID: 8926
Name: Bootsie
Type: Dog
Color: black and white
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Senior
he was left out front of our house to go to the bathroom, he never walks away from home and even if he did he can’t get very far he is old, slow and lazy. he doesn’t respond well when you call his name but he doesn’t run away from people, he will let you hold him, pet him without any problem because he is super nice and not scared of other people. but he gets homesick easily.
Des Moines - Central
Lost: 6/23/2018
ID: 8920
Name: Xena
Type: Dog
Color: Black
Breed: Rat Terrier
Gender: Female
Fixed: Neutered
Age: Adult
37th and Unvirsity by Drake University.
Bondurant
Lost: 6/22/2018
ID: 8976
Name: Lilly
Type: Cat
Color: Black/white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Lilly has two almost diamond like white spots on the nose and front paws look like they have white gloves.
Redfield
Lost: 6/22/2018
ID: 8923
Name: Rosie or Rosita
Type: Dog
Color: brown
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Young
On Thomas Street during Old Settlers
Des Moines - South
Lost: 6/22/2018
ID: 8917
Name: Cleo
Type: Cat
Color: Hairless
Breed: Sphynx (Hairless Cat)
Gender: Female
Fixed: Unknown
Age: Adult
Last seen at Weston park apartments at Park ave and SW 42nd in Des Moines
New Virginia
Lost: 6/22/2018
ID: 8912
Name: Opie
Type: Dog
Color: Brown
Breed: American Bulldog
Gender: Male
Fixed: Not Applicable
Age: Baby
Squaw Creek, Liberty area
Redfield
Lost: 6/22/2018
ID: 8911
Name: Rosie Leyva
Type: Dog
Color: Brown
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Unknown
Age: Young
Last seen in Redfield Iowa on Thomas street. She gets cold and scared when she hears loud noises. Please help me find her.
Des Moines - Central
Lost: 6/22/2018
ID: 8910
Name: Skyler
Type: Dog
Color: Tan and black
Breed: Yorkie Poo
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen at 4093 NE 46th street in Des Moines. She’s very skiddish, and shy