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>='1560988800')) ORDER BY pm1.meta_value DESC, post_date DESC
Le Mars
Lost: 11/11/2018
ID: 9988
Name: (4) Seven (female)- Trouble (male) Crook (male) Cracker (male)
Type: Dog
Color: 2 blond, 1 brown, 1 black/brown
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
4th Ave NW please, please call me at 515-835-7139 my name is Kimberley
Ankeny
Lost: 11/11/2018
ID: 9985
Name: Charlie
Type: Dog
Color:
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Hospers
Lost: 11/10/2018
ID: 9999
Name: Zara
Type: Dog
Color:
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Clive
Lost: 11/10/2018
ID: 9987
Name: slash
Type: Cat
Color: orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
4402 nw 165th st Clive, Ia 515-205-0816
West Des Moines
Lost: 11/10/2018
ID: 9976
Name: Luna
Type: Dog
Color: Blonde
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Adult
50th street
Colesburg
Lost: 11/9/2018
ID: 9984
Name: Milo
Type: Dog
Color: Brown
Breed: Dachshund
Gender: Male
Fixed: Unknown
Age: Adult
Last Seen at Shell Ultra City Colesberg around 08H30
Ankeny
Lost: 11/9/2018
ID: 9979
Name: Luke
Type: Cat
Color: Dark Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Luke is an extremely sweet and friendly cat. He will let you pick him up and snuggle him and pet him. When we adopted him from the ARL he had no front claws but did have his back claws. He also gets along with friendly dogs since his best bud at home is a dog.
Des Moines - West
Lost: 11/8/2018
ID: 9971
Name: Honey
Type: Dog
Color: Sable/Black/White
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Neutered
Age: Adult
10:30p.m. let her out for last potty before bedtime and she never returned....totally out of character. She may bark at first, but then morphs into friendly tail wagging. Loves treats.
Des Moines - Central
Lost: 11/8/2018
ID: 9969
Name: Honey
Type: Dog
Color: Sheltie
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Unknown
Age: Adult
Cedar Rapids
Lost: 11/8/2018
ID: 9965
Name: Mozzie
Type: Dog
Color:
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
1068 27th Street NE, Cedar Rapids, Iowa
Des Moines - East
Lost: 11/7/2018
ID: 10005
Name: PC
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen outside by sidewalk. He's an indoor and outdoor cat. He looks just like that cat pictured above and is a male not a female. The picture above thought was my cat turns out that cat is a female :(
Ankeny
Lost: 11/7/2018
ID: 9957
Name: Rajah
Type: Cat
Color: Black/brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Super friendly
Des Moines - East
Lost: 11/7/2018
ID: 9953
Name: Rex
Type: Dog
Color: Light beige
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen near Sheridan park
Des Moines - East
Lost: 11/6/2018
ID: 9947
Name: Bandit
Type: Dog
Color: White with black spots
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Bandit got out of the fence in our backyard when I let him and his brother out to go to the bathroom. We back up to a bunch of corn fields along Douglas/Hubbell Ave.
Ames
Lost: 11/5/2018
ID: 9941
Name: Mercy
Type: Dog
Color: Back is black and chest and part face is white.
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
Last seen at near 245 North Hyland. She is very scared and does not have a collar on. Please notify us if you have seen her or know where she is. Thank you.
Graf
Lost: 11/4/2018
ID: 9933
Name: Ebenezer the Sneezer… Ebby
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
When the creeks were flooding from all the rains.. Has golden eyes and long fangs-but has a hairlip, so his front teeth are usually all broken looking.
Harpers Ferry
Lost: 11/4/2018
ID: 9927
Name: Polly
Type: Dog
Color: Reddish brown
Breed: GoldenDoodle
Gender: Female
Fixed: Not Applicable
Age: Baby
We are just visiting and staying at a cabin in the woods. Buck Lane, 52146. The neighbor is Deer Tracks
Urbandale
Lost: 11/3/2018
ID: 9964
Name: Keta
Type: Cat
Color: Black with white and calico spots
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She’s very friendly and sweet!
Des Moines - East
Lost: 11/3/2018
ID: 9925
Name: Unknown
Type: Cat
Color: Multi
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Third time our family has seen him in the neighborhood E.25t and Boyd
Des Moines - South
Lost: 11/3/2018
ID: 9923
Name: Gato
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
40th Street around Park Ave
Ankeny
Lost: 11/2/2018
ID: 10004
Name: Yondu
Type: Cat
Color: Black with a little bit of white on the belly
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen SE Grant St in Ankeny Iowa. $100.00 reward for a SAFE and UNHARMED return (does not include if have to pick up from a shelter) We are really missing him.
Ankeny
Lost: 11/2/2018
ID: 9936
Name: Yondu
Type: Cat
Color: Black with only white on the belly
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
SE Grant St, Ankeny, Iowa
Des Moines - South
Lost: 11/2/2018
ID: 9929
Name: Katniss
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
Sw 14th st
Thayer
Lost: 11/2/2018
ID: 9918
Name: Ace
Type: Dog
Color: Grey
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
Ace was last home on our farm South of Thayer, Iowa on Friday November 2. Please help us bring our baby home!
Des Moines - South
Lost: 11/2/2018
ID: 9914
Name: fez
Type: Dog
Color: Black and white
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Sw 12th and Park