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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - East
Lost: 6/22/2018
ID: 8904
Name: Unknown
Type: Dog
Color: Reddish tan/ black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Turned in to Des Moines arl Found on Osceola Ave.
Des Moines - East
Lost: 6/21/2018
ID: 8974
Name: Tiger
Type: Cat
Color: Yellow and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly cat! No claws. Disappeared right after we moved. Reward given upon return.
Des Moines - South
Lost: 6/21/2018
ID: 8963
Name: Shelby or Baby Girl
Type: Bird
Color: Green with blue flight feathers and yellow and green tail feathers.
Breed: Quaker Parakeet
Gender: Female
Fixed: Unknown
Age: Adult
MISSING QUAKER PARROT / Des Moines south side; Shelby is bright green with gray cheeks and gray chest. Blue flight feathers and yellow and blue tail feathers. She has a band on her leg. Shelby was lost in the 200 blk. of E. Rose Ave. When she is hungry she may come to you if you are holding a banana and say "come get some" or "want some?." Shelby loves grapes, cucumbers, bell peppers, hard cooked eggs, chicken, peas, just about anything you are eating. Shelby talks, she says; Love you, Nite-Nite, Come here, Come back, Yeah (when you ask her a question), I Know-I Know-I Know-IT! David-David, Branny-Dog-Dog. Please call anytime: David & B.J. at 515-249-0714 or 515-971-5383
Des Moines - Central
Lost: 6/21/2018
ID: 8925
Name: Shelby or Baby Girl
Type: Bird
Color: Green
Breed: Quaker Parakeet
Gender: Female
Fixed: Not Applicable
Age: Adult
6-21-18. She is a Quaker Parrot.
Des Moines - West
Lost: 6/21/2018
ID: 8919
Name: Patches
Type: Cat
Color: Black orange white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is very friendly and small.
Des Moines - West
Lost: 6/21/2018
ID: 8918
Name: Patches
Type: Cat
Color: Black orange white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is very friendly and small.
Des Moines - Central
Lost: 6/21/2018
ID: 8909
Name: Chunk
Type: Cat
Color: yellow and white
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
1 or 2 in the afternoon by the pool at Westin Park Apartments...4200 Park Ave. Des Moines IA 50321
Des Moines - Central
Lost: 6/21/2018
ID: 8908
Name: Chunk
Type: Cat
Color: yellow and white
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
1 or 2 in the afternoon by the pool at Westin Park Apartments...4200 Park Ave. Des Moines IA 50321