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
Clive
Lost: 4/15/2017
ID: 5309
Name: Dallas
Type: Dog
Color: Black and White
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Young
Last seen around neighborhood of University and 81st street in Clive Iowa. Dallas is a young dog, 8 months old. Dallas has curved front legs very distinguishable. He is friendly and full of energy.
Ankeny
Lost: 4/15/2017
ID: 5304
Name: Meisa
Type: Dog
Color: Salt and pepper
Breed: Schnauzer
Gender: Female
Fixed: Neutered
Age: Young
Meisa is very skittish and shy. She won't go up to people so if you see her please just call so we can come and get her. 515-210-5603 Thank you so much for your time!!! We really miss her!!!
Des Moines - South
Lost: 4/14/2017
ID: 5296
Name: Shadow
Type: Cat
Color: Grey and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Taco johns on sw 9th. He chip is NOT updated with current owner info and will come back as his name being Tony.
Des Moines - South
Lost: 4/14/2017
ID: 5286
Name: Roxy
Type: Dog
Color: Brown/white
Breed: Saint Bernard
Gender: Unknown
Fixed: Neutered
Age: Adult
Sioux City
Lost: 4/13/2017
ID: 5438
Name: Joey
Type: Cat
Color: cream
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
last seen at 1475 110th st
Sioux City
Lost: 4/13/2017
ID: 5432
Name: Joey
Type: Cat
Color: cream
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
last seen at 1475 110th st in sioux city.
Davenport
Lost: 4/12/2017
ID: 5312
Name: Shitbutt
Type: Cat
Color: gray and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He is in heat, and I just want him home. I will pay you if you find him.
Windsor Heights
Lost: 4/12/2017
ID: 5266
Name: Unknown
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Marshalltown
Lost: 4/11/2017
ID: 5455
Name: Dante
Type: Cat
Color: black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
He escaped from his house sometime in the early afternoon. He isn't in the best of health and with all this rain we're getting very worried about him. He's very sweet but shy with strangers, and very good at hiding.
Des Moines - South
Lost: 4/11/2017
ID: 5365
Name: Cooper
Type: Dog
Color: Black gray
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
Cases ecovaley,my dauthers miss him, help us please
Des Moines - South
Lost: 4/11/2017
ID: 5363
Name: Cooper
Type: Dog
Color:
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
Ecovaley caseys,he don't have his plates, please help us we have everything
Runnells
Lost: 4/10/2017
ID: 5262
Name: Gracie
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 4/10/2017
ID: 5246
Name:
Type: Dog
Color: Black
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Baby
Last seen in closed in back porch at 6pm
Urbandale
Lost: 4/9/2017
ID: 5269
Name: MILLIE
Type: Cat
Color: SHORT HAIR MED GRAY
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Millie is fairly small for her age. She is very friendly and will rub up against you and climb around your shoulders and wrap around your neck and rub on your face with her face. She loves that! I have had Millie for almost five years and she is like my child. I know she is scared and misses her mommy; Actually her mommy misses her more. Please keep an eye out for Millie... Please help me get her home. Thank you very much!
Cumming
Lost: 4/9/2017
ID: 5256
Name: Panther
Type: Dog
Color: Black Lab
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen on 155th street heading north into timber with our beagle who is also missing.
Cumming
Lost: 4/9/2017
ID: 5255
Name: Echo
Type: Dog
Color: Tri color
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on 155th Street going North into timber.
Ankeny
Lost: 4/9/2017
ID: 5227
Name: Chandler
Type: Cat
Color: all black with white patch on chest
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Has long tail with distinctive "kink" in end, cannot be seen only felt. Answers to Chandler. Last seen early Sunday morning near Prairie Lakes Sports Complex in Ankeny.
Marion
Lost: 4/9/2017
ID: 5226
Name: Blu
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Baby
Last seen at home, she is very lovable and responds to Blu or Baby Blu
St. Marys
Lost: 4/7/2017
ID: 5236
Name: Thor
Type: Dog
Color: Brown and black
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Adult
1 mile east of St Marys
Des Moines - East
Lost: 4/7/2017
ID: 5224
Name: Simone
Type: Cat
Color: Multiple colors
Breed: Torbie
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in east des monies she has a pink collar and she is very soft
Des Moines - West
Lost: 4/7/2017
ID: 5223
Name: Nina
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
Merle Hay Rd. and Madison Ave in Des Moines, shes been walked as far as Hoover high school.
Bondurant
Lost: 4/7/2017
ID: 5210
Name: Luna
Type: Cat
Color: Gray with white
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
LAST SEEN BY FOUNDERS IN BONDURANT
Bondurant
Lost: 4/7/2017
ID: 5209
Name: Luna
Type: Cat
Color: Gray with white
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
LAST SEEN BY FOUNDERS IN BONDURANT
Bondurant
Lost: 4/7/2017
ID: 5208
Name: Luna
Type: Cat
Color: Gray with white
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen by Founders in bondurant
Des Moines - South
Lost: 4/6/2017
ID: 5214
Name: Lovely
Type: Dog
Color: Black brown one white leg
Breed: Siberian Husky
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen park ave. And sw 13th pl.