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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Milo
Lost: 4/18/2017
ID: 5337
Name: Rizzo
Type: Cat
Color: orange white tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Outside Town and Country Vet Clinic, he was a stray up to a few weeks ago, got neutered and his shots last Thursday. He injuried his back left paw and was headed to the vet when he escaped from the car, he gets very nervous in a kennel so my brother was trying to comfort him tell til he jumped from his arms.
West Des Moines
Lost: 4/18/2017
ID: 5336
Name: Winnie
Type: Dog
Color: Tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Young
Very skittish. Call 515-554-2333. May run if approached.
Altoona
Lost: 4/17/2017
ID: 5408
Name: Meow
Type: Cat
Color: Orange with a little bit of white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
In Altoona
Monticello
Lost: 4/17/2017
ID: 5340
Name: toto
Type: Dog
Color: brown/black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen at 430pm at our house in scotch grove. was gone by 830pm very shy.
Ankeny
Lost: 4/17/2017
ID: 5338
Name: Jewel
Type: Cat
Color: Black and Tan
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Senior
Jewel is incredibly shy but very sweet. She may hiss if scared but never is mean. She's always been a house cat. She has a tan diamond marking between her shoulder blades.
Huxley
Lost: 4/17/2017
ID: 5333
Name: Lucy
Type: Dog
Color: Black with White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
She is mostly black with a white chest and white spots on a couple of her paws. She is very sweet and will come to her name. Food is always a yes.
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