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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Bondurant
Lost: 4/27/2015
ID: 414
Name: Winston
Type: Dog
Color: fawn
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Adult
Ames
Lost: 4/26/2015
ID: 435
Name:
Type: Dog
Color:
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Lost: 4/26/2015
ID: 421
Name: Ricardo
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Friendly but might be scared and cries a lot. Pointy ears and big eyes. Lost in Ankeny off of SE delaware
Dayton
Lost: 4/26/2015
ID: 412
Name: Maverick
Type: Dog
Color: rust
Breed: Dachshund-Miniature
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Burnside
Sergeant Bluff
Lost: 4/26/2015
ID: 410
Name: Beans
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Buchanan Avenue
Dayton
Lost: 4/26/2015
ID: 408
Name: Maverick
Type: Dog
Color: brown
Breed: Weimaraner
Gender: Male
Fixed: Unknown
Age: Adult
Last seen in Burnside Iowa. Look in Burnside \ Dayton area
Griswold
Lost: 4/26/2015
ID: 407
Name:
Type: Dog
Color: Black and White
Breed: Weimaraner
Gender: Male
Fixed: Unknown
Age: Young
Friendly, well fed, male, clean
Manchester
Lost: 4/25/2015
ID: 772
Name: Salem
Type: Cat
Color: Black (Except for small white match on lower stomach)
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
Around Manchester, Iowa. Has a really bushy tail.
Des Moines - Central
Lost: 4/25/2015
ID: 452
Name: Baby
Type: Dog
Color: Gray/blue
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - West
Lost: 4/24/2015
ID: 396
Name: koda
Type: Dog
Color: black/white
Breed: Mastiff English
Gender: Male
Fixed: Not Neutered
Age: Baby
He is 2 months. He has little short legs and a chunky body. the pic is of him a week ago so that is what he would look like now. He loves to eat especially chicken. He got out of the front gate this morning. Please help find him. He belongs to my child.
Altoona
Lost: 4/23/2015
ID: 401
Name: alfie
Type: Cat
Color: mixed brown
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Milo
Lost: 4/20/2015
ID: 385
Name: eddie
Type: Dog
Color: tan with white and black
Breed: English Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
In the morning after nine and was with my other dog thsthe follow and rsn off but we got him back. We live on mc kinley st in milo.he is very friend ly and i just want my dog back. He also doesnt have a collor on.
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