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>='1599955200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - Central
Lost: 9/1/2017
ID: 6723
Name: Lil Buddy
Type: Cat
Color: Dark gray and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen at 28th in Brattleboro by Drake. He always walks neighborhood he's a 1 years old and his sister has been crying for him. He is never gone more then couple hours so I believe someone may have found him and took him. He belongs to my boyfriend who is worried about him. Funny to say but it's his Lil buddy and he needs him home.
Ames
Lost: 9/1/2017
ID: 6690
Name: Spud
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
North Ames, Somerset
Des Moines - West
Lost: 9/1/2017
ID: 6678
Name: Puppy
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Waukee
Lost: 9/1/2017
ID: 6664
Name: Ryder
Type: Cat
Color: Black
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He snuck outside the house around 10pm on August 31st. He is declawed and an indoor cat. Last seen at 720 6th Street. Please call or text (515) 490-1440