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>='1562803200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - Central
Lost: 6/21/2018
ID: 8907
Name: Chunk
Type: Cat
Color: yellow and white
Breed: Tabby
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 - East
Lost: 6/21/2018
ID: 8903
Name: Mila
Type: Dog
Color: White with brown ears
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
Between E 16th and Guthrie.
Des Moines - East
Lost: 6/21/2018
ID: 8902
Name: Rocky
Type: Dog
Color: Tan and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
06/21/2018 6Pm. Very friendly
Des Moines - East
Lost: 6/20/2018
ID: 8916
Name: Birdie
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - West
Lost: 6/20/2018
ID: 8888
Name: Patty
Type: Dog
Color: Fawn/ brown w black mussle
Breed: Bull Terrier
Gender: Unknown
Fixed: Neutered
Age: Senior
She will be with a black dog she's friendly.
Des Moines - West
Lost: 6/20/2018
ID: 8887
Name: Chase
Type: Dog
Color: Black
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Senior
He's blind in one eye and shoukd be with our other dog a brown n black nosed terrier
Des Moines - West
Lost: 6/20/2018
ID: 8886
Name: Chase
Type: Dog
Color: Black
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Neutered
Age: Senior
He's blind in one eye and shoukd be with our other dog a brown n black nosed terrier
Des Moines - South
Lost: 6/20/2018
ID: 8885
Name: Chipper
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Last seen 05/25/2018 Posting a picture of what he looks like when he is sick and stops eating.. he slipped out of his collar and got out. He does look like a stray so I’m unsure if someone took him in to care from him. I’ve had him for 12 years and would really love to have him home. He has a cataract or discoloration in one eye and freckles on his nose and mouth. Please help. He is dearly missed and needs to see his vet for his thyroid problem.
Johnston
Lost: 6/19/2018
ID: 8949
Name: Mrs Norris
Type: Cat
Color: Black, gray and brown tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
We just moved to Iowa from California. She’s very shy but friendly. Last seen around Enfield Dr and 93rd in Johnston