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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Kellogg
Lost: 10/16/2015
ID: 1716
Name: Luna
Type: Dog
Color: Cream/Beige
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Adult
Luna disappeared from my mother's farm (two miles south of Kellogg). She is a two-year-old Husky-German Shepard mix. She is shy and uncertain around new people, but is otherwise very friendly. She has a collar, but no tags. Please contact me if you have seen her. Thank you!
Des Moines - Central
Lost: 10/15/2015
ID: 1715
Name: Blair
Type: Cat
Color: grey black white
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
Lost from Sherman Hill Two months pregnant by my other cat.
Des Moines - Central
Lost: 10/15/2015
ID: 1714
Name: Blair
Type: Cat
Color: grey black white
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
Lost from Sherman Hill Two months pregnant by my other cat.
Des Moines - Central
Lost: 10/15/2015
ID: 1713
Name: Blair
Type: Cat
Color: grey black white
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Adult
Lost from Sherman Bill Two months pregnant by my other cat.
Des Moines - East
Lost: 10/14/2015
ID: 1710
Name: Gypsy
Type: Cat
Color:
Breed: Snowshoe
Gender: Male
Fixed: Neutered
Age: Adult
Altoona
Lost: 10/13/2015
ID: 1734
Name: Snowball
Type: Cat
Color: White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen across street from Prairie meadows by the great western bank
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.