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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 10/11/2015
ID: 1659
Name: monster
Type: Cat
Color: black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 76th and Townsend avenue. All black with yellow eyes. 9-10lbs. Front declawed.
Des Moines - South
Lost: 10/11/2015
ID: 1646
Name: Millie
Type: Dog
Color:
Breed: Hound
Gender: Female
Fixed: Not Neutered
Age: Baby
Des Moines - East
Lost: 10/11/2015
ID: 1643
Name: Harley
Type: Dog
Color: Brindle
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in the morning
Ames
Lost: 10/10/2015
ID: 1661
Name: leo
Type: Cat
Color: gray and white strips
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen 6th and Douglas around downtown. He is super curious and is always meowing. Will walk up to almost everyone he meets.
Des Moines - South
Lost: 10/9/2015
ID: 1673
Name: Butterball
Type: Cat
Color: Orange/tan
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
He was last seen in my back yard. He usually comes home every morning but has been missing almost a week he is 14 years old and very missed.
Des Moines - Central
Lost: 10/9/2015
ID: 1640
Name: Chubz
Type: Dog
Color: Black
Breed: Labradoodle
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen 10/10/15 in the North East 14th st University/ Guthrie St. around 2:00
West Des Moines
Lost: 10/9/2015
ID: 1639
Name: Chewy/Chewbacca
Type: Dog
Color: Brown and black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Young
Let him out to potty in our fenced in yard-must have squeezed out somehow and got loose-valley junction
Des Moines - South
Lost: 10/9/2015
ID: 1637
Name:
Type: Cat
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
He has been missing for almost a week and my family and I miss him dearly.
Des Moines - West
Lost: 10/8/2015
ID: 1631
Name: Tug
Type: Dog
Color: brindle color - mostly brown and black with spots of white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
He escaped from our yard that has Invisible Fence. Very friendly and loves people so comes up to them. Has Basset-like bark. He is a Basset Hound/Blue Heeler mix. Picture a Bassett with a hound dog face. Really.
Owasa
Lost: 10/7/2015
ID: 2290
Name: Maggie May
Type: Dog
Color: Black, white, tiny bit of tan in ears
Breed: Australian Shepherd
Gender: Female
Fixed: Not Applicable
Age: Young
let out with other dog to pee in middle of night, called and she'd gone. She's NEVER Left our farm except to my mother in laws next door. VERY tame, will come to you, get in the car, loving, sweet, gentle, PLEASE call if you see her or have ANY information.. REWARD!!!
Owasa
Lost: 10/7/2015
ID: 2128
Name: Maggie May
Type: Dog
Color: Black and White
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen on our farm. Black body, white paws, white chest and all around neck and muzzle, white goes around muzzle and up her forehead in between eyes, small bits of brown in her ears, and slightly visible spots of black in the white on her muzzle. We let her and our other dog out to potty in the middle of the night. The one came back, but Maggie didn't. She's never done that before. They were barking, but more like a playful bark. PLEASE help. We and our kids miss her dearly!!! She's VERY friendly, loving, and vocal. She loves people and is an indoor dog. Snickers her best buddy misses her dearly too. NOT spayed. LIGHT PINK collar when left, but if someone has had her they could've changed the collar by now. REWARD!!!
Waterloo
Lost: 10/7/2015
ID: 1627
Name: Bella
Type: Dog
Color: white/tan
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Baby
Waterloo, ia
Waterloo
Lost: 10/7/2015
ID: 1626
Name: Bella
Type: Dog
Color:
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
Waterloo, IA
Davenport
Lost: 10/6/2015
ID: 1674
Name: Moose
Type: Cat
Color: Grey ans White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Senior
Last seen on West 13th St. Davenport.
Sioux City
Lost: 10/6/2015
ID: 1633
Name: Happy Feet
Type: Cat
Color: White and Orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Ramada Inn Sioux City Iowa - Reward - loving friendly cat family cat
Des Moines - North
Lost: 10/6/2015
ID: 1608
Name: Allie
Type: Dog
Color: light brown with dark brown spots
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
Puppy was in a fenced yard, was left unattended in locked fenced yard for 30 minutes. When owner went to check on her, the gate was forced open and puppy was gone. Search of the area yielded no results. Fairly sure dog was kidnapped.... pedigree bit bull puppy 6 weeks old.
Des Moines - East
Lost: 10/6/2015
ID: 1602
Name: Ellie
Type: Dog
Color: Light brown and white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Around 8:30am, blue eyes we do know her marking on her back which are special and tail.
Des Moines - South
Lost: 10/5/2015
ID: 2151
Name: Butterball
Type: Cat
Color: light tan striped
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Senior
Scar on pink nose, unusual meow, kink at the end of his tail
Des Moines - South
Lost: 10/5/2015
ID: 2150
Name: Butterball
Type: Cat
Color: light tan striped
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Senior
Scar on pink nose, unusual meow, kink at the end of his tail
Des Moines - East
Lost: 10/5/2015
ID: 1681
Name: Lilly
Type: Cat
Color: All white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
By taco Johns on Hubble ave. And she has six toes.
Altoona
Lost: 10/5/2015
ID: 1615
Name: Chief
Type: Dog
Color: Brown and Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Baby
Altoona - 17th Ave SW and 8th ST SW Please call 515-371-1449
Menlo
Lost: 10/5/2015
ID: 1612
Name: Bobo
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
He's tiny and I know he's scared. He wants to come home to me and his Basset Hound friend Tank and my children!! Please, Please help. He was last seen on my door step waiting to be let in. 515-577-3501. We have walked cornfields, pastures, looked in ditches, other peoples doorsteps, posted on many sites. For whatever reason I cannot upload pics of him Baby chocolate lab. I'm sure he's so scared and alone. Even if he was stolen, he needs His family. 515-577-3501 any time of day or night!!
Altoona
Lost: 10/5/2015
ID: 1609
Name: chief
Type: Dog
Color: black and tan
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Young
Willowbrook circle
Des Moines - West
Lost: 10/5/2015
ID: 1603
Name: Arnie
Type: Dog
Color: Tan with a white chest and black face.
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Young
Escaped from under the gate in our backyard (39th St. in Beaverdale, IA). He was with our other dog that was found on 34th St. and Franklin in Beaverdale. I think he must have been lost somewhere in between.
Harlan
Lost: 10/4/2015
ID: 1616
Name: Dadoong
Type: Cat
Color: Grey and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He's skittish and won't usually let strangers approach him, he has all 4 white paws with a black and grey striped tail, weighs 15-16 lbs, and has bright yellow eyes.