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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 2/19/2017
ID: 4935
Name: Rocky
Type: Cat
Color: Black & white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at sw reunion drive, Ankeny Iowa
Des Moines - West
Lost: 2/19/2017
ID: 4882
Name: Schnitzel
Type: Dog
Color: Brown and White
Breed: Schnauzer Miniature
Gender: Female
Fixed: Neutered
Age: Adult
63rd street and University. She is deaf and very friendly. You will have to use a hand signal to get her to come or a treat. She was just groomed today.
Des Moines - South
Lost: 2/18/2017
ID: 4926
Name: Fluffy
Type: Dog
Color: White and black
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
He's small and fluffy
West Des Moines
Lost: 2/18/2017
ID: 4919
Name: Brad
Type: Cat
Color: White and gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 2/18/2017
ID: 4896
Name: Rosie
Type: Dog
Color: Black/white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
vicinity of 6th and Hickman. She is a therapy dog and also has health issues and needs a special diet. It is SO important we get her back. REWARD!
Des Moines - North
Lost: 2/18/2017
ID: 4885
Name: cree
Type: Dog
Color: all white with brown and black spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
he was let out to go potty and he chewed threw the leash .. 8th ave and Madison was where he was last seen
Des Moines - Central
Lost: 2/18/2017
ID: 4883
Name: Wanda
Type: Cat
Color: White and Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Somebody took her on Friday night and I believe she was dumped on the side of the road somewhere. She has claws on all four paws, she is long and slender and she is pregnant. I need to find her soon because she could have her kittens at any moment and I am worried and frightened that I will never see her again. Please if you see a cat of that description please call me at (515) 681-8207 and let me know the general area she was seen or if you found her.
Des Moines - East
Lost: 2/18/2017
ID: 4876
Name: Wally
Type: Dog
Color: gray/some white
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Lost in the area of E 42nd and Ovid Ave Des Moines. He is very friendly and sweet dog, If found please call 515 201-7765
Des Moines - Central
Lost: 2/17/2017
ID: 4868
Name: Snickers
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
Missing since on or about 10/17/16 Des Moines area. Was entrusted to friend to watch while in the process of moving and was scammed/traded out. If seen, please notify immediately.
Des Moines - East
Lost: 2/16/2017
ID: 4855
Name: Felix
Type: Cat
Color: White with gray stripes in patches
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very shy light green eyes.
Clive
Lost: 2/15/2017
ID: 4864
Name: Julia or Bouncer
Type: Cat
Color: Brown tiger/tabby with two orange paws on the left side.
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Baby
I adopted her last week from the ARL. She is new to my household. I left my apartment (west winds apartments) around 7:15pm 02/15. I was gone for approximately a half hour. When I returned she was gone. The door was locked, so she must've escaped as I was leaving the apartment and I didn't notice. She is very social. Offering $100 reward for her return.
Urbandale
Lost: 2/15/2017
ID: 4857
Name: Cash
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Will come for any type of food. Friendly
Des Moines - North
Lost: 2/14/2017
ID: 4852
Name: Panther
Type: Cat
Color: Black w black stripes
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
He had breakfast on 214. Was not home for dinner or breakfast after that. He's got a little white spot on his belly. He is bigger then he was in this picture. He gets very anxious being inside the house. His name is panther but sometimes I call him little Mr. he's a sweet cat and I miss him very much. I have his siblings also so we have a nice little family here. If you have him or have seen him feel free to call my cell at 865-3405
West Des Moines
Lost: 2/14/2017
ID: 4851
Name: Kitt
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
At maple grove villas. Not 100% sure when he got outside.
Des Moines - East
Lost: 2/12/2017
ID: 4841
Name: Cricket
Type: Dog
Color: Reddish Tan
Breed: Coonhound
Gender: Female
Fixed: Neutered
Age: Adult
Around NE 56th and Douglas. She was hit by a car and may be in a corn field. Last seen near Archery Field and Sports (3725 E 56th St, Altoona, IA).36
Anita
Lost: 2/12/2017
ID: 4840
Name: Franklin
Type: Dog
Color: Brown
Breed: Bloodhound
Gender: Male
Fixed: Unknown
Age: Young
He is very friendly and loves other dogs. He doesn't like to get in vehicles and he is afraid of plastic bags. Call 515-441-3020
Des Moines - East
Lost: 2/12/2017
ID: 4837
Name: Rocco
Type: Dog
Color: White
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Adult
1700 block East Grand
Des Moines - East
Lost: 2/11/2017
ID: 4839
Name: Indigo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
E Seneca by radio city trailer court on E 14th St in des moines
Des Moines - East
Lost: 2/10/2017
ID: 4832
Name: Scruffy
Type: Dog
Color: Black
Breed: Poodle Standard
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 1544 royer st des moines iowa 50316 a poodle mix
Des Moines - East
Lost: 2/10/2017
ID: 4831
Name: Scruffy
Type: Dog
Color: Black
Breed: Poodle Standard
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 1544 royer st des moines iowa 50316 a poodle mix
Des Moines - South
Lost: 2/9/2017
ID: 4830
Name: Marley
Type: Dog
Color: Tan Reddish
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near SE 14th Street and Indianola Ave in Des Moines. He got out of his yard to chase a rabbit and didn't come back. He hates being out in the cold for long and doesn't know to stay out of roads so we're very worried. The picture attached is not Marley but as close as I could find to what he looks like, size and color. He's a very sweet boy!
Des Moines - South
Lost: 2/9/2017
ID: 4829
Name: Charlie
Type: Dog
Color: Black and White
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Senior
Charlie was last seen on 2-9-17 in Easter Lake on 26th court at 2:00pm. He has a collar with blue tags. He doesn't know to stay out of the street, and he doesn't do well out in the cold. His family is very worried about him, and have been looking for him for the last 24 hours. If you have him, have seen him, or have any information please call 952-200-1416.
Des Moines - South
Lost: 2/8/2017
ID: 4824
Name: Heaven
Type: Dog
Color: Light brown
Breed: Chihuahua
Gender: Unknown
Fixed: Neutered
Age: Young
She is my emotional support animal I have depashion and anxiety she helps me so please if you have found her please bring her to me
Windsor Heights
Lost: 2/7/2017
ID:
Name: Hoover
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Has cataracts and hard of hearing. Very friendly.
Windsor Heights
Lost: 2/7/2017
ID:
Name: Hoover
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Has cataracts and hard of hearing. Very friendly.