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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Altoona
Lost: 10/13/2015
ID: 1733
Name: Snowball
Type: Cat
Color: White
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen across street from Prairie meadows by the great western bank
Altoona
Lost: 10/13/2015
ID: 1732
Name: Willow
Type: Cat
Color: Calico and is a darker calico almost a tabby
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Very friendly cat just want her to come home last seen Altoona mobile home park over by Walmart
Sioux City
Lost: 10/13/2015
ID: 1719
Name: Dog
Type: Dog
Color: Black, Tan
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Horizon Resturant $500 reward, no questions asked.
Ankeny
Lost: 10/13/2015
ID: 1701
Name: Sam
Type: Cat
Color: Orange/White
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Baby
He likes to hang around the Watercress development area. He wondered away and has not returned. He is very friendly and has a few distinctive black dots on his bottom lip. He is declawed and an indoor cat. He is on a special diet due to urinary issues and has lack of blood cells making his nose white/light pink. We are greatly worried.
Seymour
Lost: 10/13/2015
ID: 1682
Name: Toad
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen October 13th. I apologize for lack of details. I'm posting from Minnesota. This dog belongs to my brother and his wife. There is a phone number included on the photo if someone should have any information on his whereabouts, please call the number in the photo (608 498 0254), and not the 507.. number listed on this post. If I recall correctly, he is not neutered, completely black with maybe a little white on his muzzle, and possibly a red (?) Collar. They live in the unionville, Missouri area. Hoping someone has seen him, so we're trying to check southern Iowa too. Thank you so much!
Des Moines - Central
Lost: 10/12/2015
ID: 1729
Name: Nova
Type: Dog
Color: Blonde and white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
My son let her out to go potty and she ran off by sheridan and hull, she's a very friendly dog, just likes to run. She was my daughters dog and she is devastated..
Des Moines - North
Lost: 10/12/2015
ID: 1667
Name: Saint
Type: Dog
Color: Black and Tan
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
loves to go for rides in car an loves to eat. very friendly plays a lil rough we miss him so much
Urbandale
Lost: 10/12/2015
ID: 1663
Name: Monster
Type: Cat
Color: black
Breed: Rottweiler
Gender: Male
Fixed: Neutered
Age: Baby
Last seen around 76th and Townsend Avenue in Urbandale. Front declawed. Loves people. 10-11lbs
Urbandale
Lost: 10/12/2015
ID: 1662
Name: Monster
Type: Cat
Color: black
Breed: Rottweiler
Gender: Male
Fixed: Neutered
Age: Baby
Last seen around 76th and Townsend Avenue in Urbandale. Front declawed. Loves people. 10-11lbs
Mason City
Lost: 10/12/2015
ID: 1651
Name:
Type: Dog
Color:
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Baby
near stebens childrens theatre. a brindle color friendly pitbull mix? wearing a red harnass and collar
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