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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - South
Lost: 9/1/2017
ID: 6663
Name: Rella
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Around park sw 9th
Des Moines - East
Lost: 8/31/2017
ID: 6706
Name: Migo
Type: Cat
Color: Mostly white some orange
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Has ear and upper neck problems, roughly 12 yrs old. Very nice but skittish upon first meeting likes his fheeks pet softly and down his head and neck but only in the middle because it irritates him. His full name is amigo but we call him migi or migo. He is trained and weve had him his whole life almost.
Des Moines - East
Lost: 8/31/2017
ID: 6665
Name: Jubilee
Type: Dog
Color: White/black
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 8/31/2017
ID: 6660
Name: Willis
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Waterbury area by Roosevelt High School. Has green-yellow eyes. He is a house cat and not used to being outside! Declawed.