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>='1560384000')) ORDER BY pm1.meta_value DESC, post_date DESC
Huxley
Lost: 4/17/2017
ID: 5332
Name: Molly
Type: Dog
Color: Brindle/Black/White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
May come off as aggressive. Do not approach, let her come to you. She can be bribed with food. Once comfortable with you, she is very lovey. Her head is brindle, as well as her hips and shoulders. The rest of her body is black and white. She has a black saddleback. She has a white spot on back of her head that looks similar to an upside down heart.
Des Moines - South
Lost: 4/17/2017
ID: 5324
Name: Scarlett
Type: Dog
Color: White and brindle
Breed: American Staffordshire Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
Southside by fleur, very friendly dog, energetic, has a scar on her belly from being fixed. No tags on collar. Knows sit, kick it down, stay and roll over.
Des Moines - North
Lost: 4/17/2017
ID: 5318
Name: Chico
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 1st & Tiffin 4/7/17. If you have any information on where he maybe please contact me at (515)721-4215 or (515)991-0566
Des Moines - South
Lost: 4/16/2017
ID:
Name: Lawrence
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
se 14th and maury
Des Moines - South
Lost: 4/16/2017
ID: 5322
Name: Lawrence
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
se 14th and maury
Des Moines - South
Lost: 4/16/2017
ID: 5321
Name: Lawrence
Type: Dog
Color: White
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
Last seen as 14tg and mairy
Ames
Lost: 4/16/2017
ID: 5316
Name: Simba
Type: Cat
Color: Striped top, white underbelly and paws
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
West Ames Not declawed Loves west food
Ankeny
Lost: 4/15/2017
ID:
Name: Jewel
Type: Cat
Color: Black and brown
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Senior
Last seen east of briarwood park at a neighbors house on mission ct. she is very shy so will need to be approached gently or she will run away.
Clive
Lost: 4/15/2017
ID: 5310
Name: Dallas
Type: Dog
Color: Black and White
Breed: Tabby
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.
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.