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
Des Moines - North
Lost: 9/7/2017
ID:
Name: Smokey
Type: Cat
Color: Bluish grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Name: Smokey Color: bluish gray Eye color: Green Color color: Green and Blue Age: 2-3 years old Breed: Russian blue Gender: Male Last Seen: September 7th, 2017 Microchipped: yes @ All Pets Hospital City Tag: Yes Tabbies: Yes I'm looking for my loveable cat, he got a couple days ago and hasn't been home since. I'm worried because 3 men tried hurting him before and I'm praying he just got lost and nothing bad happened to him. He is a therapy cat, sweet, loveable, well token care of and I just want him home safely if anyone sees or has him please call or text me anytime @ show contact info . Thank you for the help Kate
Des Moines - North
Lost: 9/7/2017
ID: 6745
Name: Smokey
Type: Cat
Color: Bluish grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Name: Smokey Color: bluish gray Eye color: Green Color color: Green and Blue Age: 2-3 years old Breed: Russian blue Gender: Male Last Seen: September 7th, 2017 Microchipped: yes @ All Pets Hospital City Tag: Yes Tabbies: Yes I'm looking for my loveable cat, he got a couple days ago and hasn't been home since. I'm worried because 3 men tried hurting him before and I'm praying he just got lost and nothing bad happened to him. He is a therapy cat, sweet, loveable, well token care of and I just want him home safely if anyone sees or has him please call or text me anytime @ show contact info . Thank you for the help Kate
Des Moines - East
Lost: 9/7/2017
ID: 6735
Name: Scrappy
Type: Dog
Color: White with tan ears
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
This is my father's companion. My dad is lost without his Scrappy. Scrappy likes women mainly. He is wearing a blue collar with a white flea collar. The blue collar has a little zip tie where his name tag should go. Please help me find my father's dog.
Des Moines - East
Lost: 9/7/2017
ID: 6725
Name: Jax
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
E39th st
Des Moines - East
Lost: 9/7/2017
ID: 6724
Name: Cash
Type: Dog
Color: White and Black
Breed: Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Johnston
Lost: 9/7/2017
ID: 6719
Name: Dolly
Type: Dog
Color: Apricot
Breed: Poodle Standard
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen at Mansions at Hemingway Apartments
Des Moines - Central
Lost: 9/7/2017
ID: 6716
Name: Exene
Type: Cat
Color: Grey and white
Breed: Poodle Standard
Gender: Female
Fixed: Unknown
Age: Baby
My fiance decided to take her on the porch of our apartment and she suddenly darted into the alley behind our apartment on 23rd and Forest (Des Moines, drake neighborhood) The alley she ran into is between 23rd and 24th. She may run if you approach her too abruptly. Please help us get her home. She has a family that is worried sick about her.
Des Moines - Central
Lost: 9/7/2017
ID: 6715
Name: Exene
Type: Cat
Color: Grey and white
Breed: Poodle Standard
Gender: Female
Fixed: Not Neutered
Age: Baby
My fiance decided to take her on the porch of our apartment and she suddenly darted into the alley behind our apartment on 23rd and Forest (Des Moines, drake neighborhood) The alley she ran into is between 23rd and 24th. She may run if you approach her too abruptly. Please help us get her home. She has a family that is worried sick about her.
Des Moines - South
Lost: 9/6/2017
ID: 6738
Name: Ashy
Type: Cat
Color: Black and gray stripes with white feet, a white chest and partial white tummy
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Front paws are declawed. She's very friendly and rolls around on the ground in front of you for attention. She always stays in the back yard or house, it's not like her to leave, especially for days. Beautiful greenish eyes, purrs loudly and is talkative.
Clive
Lost: 9/6/2017
ID: 6727
Name: Rose
Type: Cat
Color: white, brown spot on back , around base of ears. Multi color tail
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Senior
Lincoln Ave., Indian Hills neighborhood near greenbelt
Dubuque
Lost: 9/5/2017
ID: 6827
Name: Eli
Type: Cat
Color: Black and Whit
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
Woods behind Rosedale Ave between Locust and Glen Oak - Dubuque, IA He's very shy and scared. I desperately want him home.
Urbandale
Lost: 9/5/2017
ID: 6713
Name: Bella
Type: Cat
Color: Grey with a white stomach
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is declawed on her front paws and she is extremely friendly and trusting. We live in Urbandale at 86th and Hickman. She got out sometime in the afternoon while we were having work done on our home. She loves wet cat food.
Des Moines - South
Lost: 9/5/2017
ID: 6712
Name: Boogie
Type: Dog
Color: Red and white
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Between sw 9th and south union on porter ave
Ankeny
Lost: 9/5/2017
ID: 6701
Name: Siena
Type: Dog
Color: Red
Breed: Dachshund Standard
Gender: Female
Fixed: Unknown
Age: Senior
Around my house at 9 pm, she had a cyst on her back leg left leg the size of a ping pong ball. Maybe even smaller. She is Frighten of men. Is friendly other than that.
Des Moines - East
Lost: 9/5/2017
ID: 6700
Name: Caprice
Type: Dog
Color: White
Breed: Pit Bull
Gender: Unknown
Fixed: Not Applicable
Age: Baby
Someone took her out of the fenced yard on e.28th and Maple
Altoona
Lost: 9/4/2017
ID: 6764
Name: Finley
Type: Dog
Color: White
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
Altoona
Lost: 9/4/2017
ID: 6737
Name: Harley
Type: Cat
Color: Calico split face
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Young
Indoor outdoor never been gone this long last seen in country club crossing
Pleasant Hill
Lost: 9/4/2017
ID: 6705
Name: Gracie
Type: Cat
Color: Gray and tan
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Her tip of her tail is crooked like it's broke
Oskaloosa
Lost: 9/4/2017
ID: 6702
Name: Addie Bug
Type: Dog
Color: Brindle. Brown, white and black
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly. Wont bite but does bark when scared
Altoona
Lost: 9/4/2017
ID: 6694
Name: Finley
Type: Dog
Color: White with black brown spot around eye
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Corner of 9th Ave Circle and 4th St Sw...very skittish do not approach
Des Moines - North
Lost: 9/3/2017
ID: 6688
Name:
Type: Dog
Color: Brown and black
Breed: Beauceron
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - North
Lost: 9/3/2017
ID: 6687
Name:
Type: Dog
Color: Brown and black
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Baby
Beaverdale area and Being kept safe by people who found him until ARL opens on Tuesday.
Ankeny
Lost: 9/2/2017
ID: 6746
Name: Baby Ace
Type: Cat
Color: Tiger stripe down white belly
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Saw 9/1 around 9pm in our shed. He has been gone since. Live out by Saylorville and the bike path.
Marion
Lost: 9/2/2017
ID: 6704
Name: Mazeu
Type: Cat
Color: Brown, black, little tint of orange
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
West Des Moines
Lost: 9/1/2017
ID: 6979
Name: Celeste
Type: Dog
Color: White with redish brown
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Baby
Lost her on 4th and Elm st in west Des Moines