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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 10/31/2016
ID: 4204
Name: Maggie
Type: Dog
Color: Red
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Adult
About 8:00pm tied out in yard
Urbandale
Lost: 10/31/2016
ID: 4201
Name: Oscar
Type: Cat
Color: Brown Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He has white paws and he also has some white under his neck, the rest of him is brown. He is very friendly and has a loud unique meow.
Johnston
Lost: 10/30/2016
ID: 4268
Name: Tyga
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
it was beggers night in northwood in Johnston, my cat got out when the first set of kids came to the door. he usually goes out but comes back when i call for him and doesnt usually stay out longer than a day.
Ames
Lost: 10/29/2016
ID: 5087
Name: Rummy
Type: Dog
Color: (Liver) brown and white
Breed: Dalmatian
Gender: Female
Fixed: Unknown
Age: Young
Have been no sightings since she went missing. She loves everyone. Her birthday is coming up soon and I can't bare to not have my baby back!
Runnells
Lost: 10/29/2016
ID: 4186
Name: Max
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
He is probably with our other dog minnie she is a white boxer
Runnells
Lost: 10/29/2016
ID: 4185
Name: Minnie
Type: Dog
Color: White
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Baby
She is probably with our dog max he is black and a lab mix
Des Moines - Central
Lost: 10/28/2016
ID: 4182
Name: Callie
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
Lost last night Special needs cat Needs medication on a daily basis for seizures. Never been outdoors until now
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 .