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
Mingo
Lost: 10/27/2016
ID: 4311
Name: Max
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Baxter
Lost: 10/27/2016
ID: 4195
Name: Max
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Super nice and docile.
Urbandale
Lost: 10/27/2016
ID: 4189
Name: Hayden
Type: Cat
Color: Tan, white, and black
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Boston Ave in Urbandale! Please please help!! 443-995-8847
Des Moines - South
Lost: 10/26/2016
ID: 4172
Name: Lucy
Type: Dog
Color: Tan and brown
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Young
Very shy but very loving. Last seen my Wright Elementary School.
Des Moines - Central
Lost: 10/25/2016
ID: 4168
Name: Angel
Type: Dog
Color: Black with white paws and white chest
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Senior
Last seen around Drake university area on forest She has patches where fur is missing/is loosing fur due to a skin condition
Des Moines - Central
Lost: 10/25/2016
ID:
Name: Angel
Type: Dog
Color: Black with white paws and chest
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Senior
Last known location, around Drake university. She has some patches on her back end that don't have fur due to a skin condition. She may itch alot. She will follow you if you call her name and get her attention without a leash.
Des Moines - South
Lost: 10/24/2016
ID: 4181
Name: Mermel
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
She has a white spot on her chin and white feet, and a white lightning bolt on her tummy. She meows very loudly. Otherwise all black, shorthair, and petite. Last seen on River Ridge Road on the southeast side of Des Moines.
Adel
Lost: 10/24/2016
ID: 4155
Name: Noodle Garrett
Type: Dog
Color: Black and White
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Senior
Last seen at Adel Acres Nursing Home in Adel. May be heading to Waukee where the deceased owner lived. Would welcome contact no matter how later or early. Noodle needs her heart medicine and she's dragging a leash so finding Noodle quickly is key.
Des Moines - North
Lost: 10/24/2016
ID: 4154
Name: Ash
Type: Dog
Color: Brown and White
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Adult
He answers to his name, and is very friendly, yet timid. I adopted him one year ago, and he had been abused.
Urbandale
Lost: 10/24/2016
ID: 4152
Name: ZuZu
Type: Cat
Color: Black, orange & white
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
Our cat jumped over the backyard fence at 14109 Briarwood Lane in Urbandale, IA. She is smaller adult cat, totally declawed, no collar, microchipped through the ARL. May come when called. Calico with black and orange- white paws and chest. This is the first time she has jumped the fence. She is probably scared. Please help bring her home!
Urbandale
Lost: 10/24/2016
ID: 4151
Name: ZuZu
Type: Cat
Color: Black, orange & white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Our cat hopped the backyard fence. She usually plays in the backyard but comes in when called. This is the first time she's escaped. She is gentle and may come when called. Declawed both front and back. Smaller for an adult. Her tail curls all the way to the tip. Microchipped through the main ARL.
Des Moines - North
Lost: 10/24/2016
ID: 4146
Name: Bella
Type: Dog
Color: Bridle dark brown light brown
Breed: Cairn Terrier
Gender: Unknown
Fixed: Unknown
Age: Baby
Last Fareway parking lot on Euclid ave. Jumped out of truck older owner tried to locate unable to. Very friendly does bark slot with strangers but never aggressive or mean. Has been her owners older retired vetenern. Companion love and joy for the six great years! Please contact if found No collar happy beautiful and friendly
Des Moines - North
Lost: 10/23/2016
ID: 4595
Name: Cassie
Type: Dog
Color: white w/ red streaks on her ears
Breed: English Setter
Gender: Female
Fixed: Neutered
Age: Senior
last seen E 14th and Euclid, DEAF, 13 yrs old, super friendly, loves to hunt, especially cats ,doesn't hurt them, just watches them.
Altoona
Lost: 10/23/2016
ID: 4188
Name: Sammy
Type: Cat
Color: Charcoal and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Went out on sunday and never returned. He has a white spot on his back and front declawed.
Altoona
Lost: 10/23/2016
ID: 4187
Name: Sammy
Type: Cat
Color: Charcoal and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Went outside sunday and never returned.
Des Moines - North
Lost: 10/23/2016
ID: 4177
Name: Cassie
Type: Dog
Color: white w/ red streaks on her ears
Breed: English Setter
Gender: Female
Fixed: Neutered
Age: Senior
cash saver e14th and euclid, Cassie is DEAF! very friendly, will go up to anyone
Lacona
Lost: 10/23/2016
ID: 4149
Name: Rainee
Type: Dog
Color: Tan & White
Breed: Cocker Spaniel
Gender: Female
Fixed: Neutered
Age: Senior
Last seen October 23rd. She takes heart medicine twice a day & needs the Asap!
Urbandale
Lost: 10/22/2016
ID: 4421
Name: Oliver
Type: Cat
Color: Black and white
Breed: Cocker Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
$$!! Reward offered for his return to his family . They miss him so much!!! He has a lil freckle on his nose and big yellow eyes and loves the outdoors but also loves to cuddle with a family member . plz help us find our lil buddy Oliver $$$ reward is offered for his return .
Urbandale
Lost: 10/22/2016
ID: 4420
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
$$!! Reward offered for his return to his family . They miss him so much!!! He has a lil freckle on his nose and big yellow eyes and loves the outdoors but also loves to cuddle with a family member . plz help us find our lil buddy Oliver $$$ reward is offered for his return .
Urbandale
Lost: 10/22/2016
ID: 4419
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Westpoint apts . Canterbury rd . He is very friendly big yellow eyes & a lil black freckle on his nose. I am offering a reward for his return , his family misses him so much . he loves the outdoors and loves to climb all the way to the top of trees to show off, but i know he is lookin for his family but cant find his way back plz help $$$ is offered for his return .
Urbandale
Lost: 10/22/2016
ID: 4262
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He has a lil black freckle on his nose...down his back within his spots it maybe looks like the letter J. Big beautiful yellow eyes and offering a reward. He doesnt like collars but loves to climb all the way to the top of tree to show off ..$$$ reward plz help
Urbandale
Lost: 10/22/2016
ID: 4261
Name: Oliver
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He has a lil black freckle on his nose...down his back within his spots it maybe looks like the letter J. Big beautiful yellow eyes and offering a reward. He doesnt like collars but loves to climb all the way to the top of tree to show off ..$$$ reward plz help
Cedar Rapids
Lost: 10/22/2016
ID: 4240
Name: Mina
Type: Cat
Color: Black/white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
At home, she had a calico spot on her back left leg
Ankeny
Lost: 10/22/2016
ID: 4208
Name: Smokey
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
No front claws and has a little notch in one of his ears.
West Des Moines
Lost: 10/22/2016
ID: 4178
Name: Cheotos
Type: Cat
Color: Tiger Grey with Dark Stripes
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Green Eyes