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>='1555545600')) ORDER BY pm1.meta_value DESC, post_date DESC
Kelley
Lost: 4/19/2015
ID: 380
Name: Rocket
Type: Cat
Color: orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 2 am west of Kelley (rural location). Rocket is a kid-friendly barn cat of ~12 lbs. He was neutered on 4/18 and upon return home the other cats tried to chase him off (scent of vet clinic?). It is possible he is scared and in pain. His underside is almost all white as are three paws. One leg is nearly all white.
Des Moines - East
Lost: 4/19/2015
ID: 379
Name: coco
Type: Cat
Color: white, tan & black
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Young
Very people social if you see him, coco is less than a year old and call his name like your someone that knows him he should or most likely will come right up to you and he's non-agressive and extremely missed and worried about. His owner and best friend is an elderly man that's really worried and missing his close friend and child, please help find coco. If any information on coco and his where about please call or text (515) 783-8337 or (515)639-5295 ask for Cortney or Terrie.
Des Moines - East
Lost: 4/19/2015
ID: 367
Name: bentley
Type: Dog
Color: black and tan with
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Applicable
Age: Young
9th and buchanan very friendly comes to name bentley
Burlington
Lost: 4/18/2015
ID: 378
Name: Smokey
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She was last seen Saturday morning. She is super friendly so if you call for her she's surely to come. She is not declawed.
Perry
Lost: 4/18/2015
ID: 371
Name: pogo
Type: Dog
Color:
Breed: Redbone Coonhound
Gender: Male
Fixed: Unknown
Age: Baby
he is injured cause he took off do to being hit by a truck on 144 on north edge of perry right infront of crossroads church
Des Moines - East
Lost: 4/18/2015
ID: 369
Name: Sweeney
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Male
Fixed: Not Neutered
Age: Young
E. 26 th
Des Moines - West
Lost: 4/17/2015
ID: 436
Name: baby
Type: Dog
Color: brindle
Breed: Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
she dose not like a lot of people so she will bark and growl but shes a very nice and loving dog, we have her registered, she has had all her shot
Perry
Lost: 4/15/2015
ID: 802
Name: Jason
Type: Dog
Color: Brown and Black
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Baby
He is a puppy. He was very friendly. He was last seen around the Red Carpet Inn and John Deere back in April. He ran off after a bunny with his mom, but his mom came back. He is half yorkie half chihuahua.
Des Moines - West
Lost: 4/15/2015
ID: 382
Name: Paris
Type: Dog
Color: Black, Tan, White
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Young
1600 block Carpenter Ave
Des Moines - Central
Lost: 4/15/2015
ID: 361
Name: Paris
Type: Dog
Color: Brown black tan
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Young
1600 Carpenter long hair
Charles City
Lost: 4/15/2015
ID: 353
Name: Beezy
Type: Cat
Color: Tortoiseshell (Black with patches of orange and white)
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen in our home, she escape during the night or early morning hours. We live in Maple Heights and are hoping she is still in the general area. She's very sweet, although she may be wary of strangers.
Des Moines - Central
Lost: 4/15/2015
ID: 337
Name: Hermione
Type: Cat
Color: Black with green eyes
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen evening of Friday 4/10 near corner of Beaver and Forest. Hermione is strictly an indoor cat and very shy. She may be micro-chipped, but registration not current. Heartbroken, so please call if seen. 515-423-7523.
Des Moines - Central
Lost: 4/14/2015
ID: 347
Name: Paris
Type: Dog
Color: Black brown
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Baby
1600 block Carpenter
Ames
Lost: 4/14/2015
ID: 331
Name: Unknown
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
He was found roaming around my backyard, I live in Gilbert and i asked around my neighborhood but no one had seen the cat before! it is so so sweet and i hope it finds its home.
Des Moines - West
Lost: 4/14/2015
ID: 330
Name: Bentley
Type: Dog
Color: White with light tan
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Neutered
Age: Adult
He was in our fenced yard. He went missing between 3:00 and 3:15 in the afternoon. He is very energetic and friendly.
Ankeny
Lost: 4/14/2015
ID: 329
Name: Batman
Type: Dog
Color: Tan
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Young
last seen at the Ankeny dog park, was told he was taken by a couple and they were going to see if he had a chip..... he does not.... He is a Morkie (Maltese and Yorkie Mix), His hair is a bit longer now, than in this picture.
Cambridge
Lost: 4/14/2015
ID: 319
Name: Sammie
Type: Dog
Color: black
Breed: Maltese
Gender: Female
Fixed: Unknown
Age: Adult
4 am Cambridge she was in my home. Came home work she's gone
Des Moines - South
Lost: 4/12/2015
ID: 325
Name: No
Type: Cat
Color: orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
He is orange with white paws, white chest and white chin
Des Moines - South
Lost: 4/12/2015
ID: 321
Name: No
Type: Cat
Color: orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
He is orange with white paws, white chest and white chin
Des Moines - East
Lost: 4/12/2015
ID: 309
Name: Molly
Type: Dog
Color: blonde
Breed: Poodle
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen at 1909 E Walnut Des Moines Iowa
Bondurant
Lost: 4/12/2015
ID: 301
Name:
Type: Dog
Color:
Breed: Pekingese
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - East
Lost: 4/11/2015
ID: 306
Name: Roxy
Type: Dog
Color: Grey, white paws
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
If she is found please contact me on my cell phone. I miss her and want to bring her home. She was microchipped by the ARL but I am not sure if it has current information. She is very friendly and loves attention.
Fairfax
Lost: 4/11/2015
ID: 300
Name: Rocky
Type: Dog
Color:
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Senior
Des Moines - South
Lost: 4/11/2015
ID: 297
Name: Dyna
Type: Dog
Color: dark brendell
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines south side just south of the airport, Fleur and Army Post my kids and I live at 7306 Sw 17th Street south of Army Post, she wondered off while we were grilling out and playing she's a sweet dog, doesn't bite, loves kids, loves to fetch sticks and will come to her name Dyna especially for a stick or treat, please contact Joe at 515 770-1433 my kids are so sad right now please help.
Des Moines - South
Lost: 4/11/2015
ID: 296
Name: Dyna
Type: Dog
Color: dark brendell
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines south side just south of the airport, Fleur and Army Post my kids and I live at 7306 Sw 17th Street south of Army Post, she wondered off while we were grilling out and playing she's a sweet dog, doesn't bite, loves kids, loves to fetch sticks and will come to her name Dyna especially for a stick or treat, please contact Joe at 515 770-1433 my kids are so sad right now please help.