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
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
West Des Moines
Lost: 11/1/2018
ID: 9938
Name: Cocoa
Type: Cat
Color: Black orange tan
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Senior
She is not kind to strangers, untrusting of people she does not know. Do not attempt to pick her up or she may attack your face. If spotted please contact me.
West Des Moines
Lost: 11/1/2018
ID: 9937
Name: Cocoa
Type: Cat
Color: Black orange tan mix
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Senior
Escaped out the door Thursday night and she has not been seen since
Newell
Lost: 11/1/2018
ID: 9915
Name: scraps
Type: Dog
Color: white with brown patches
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen on our family farm on hwy 7 near newell iowa
Madrid
Lost: 11/1/2018
ID: 9909
Name: Biscuits
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Got out while moving from s Kennedy Ave
Des Moines - South
Lost: 10/31/2018
ID: 9917
Name: Diamond
Type: Cat
Color: Black, gold, a little white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She will respond to her name she doesn't like water or the cold she's an indoor cat... She is my service animal