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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 8/30/2018
ID: 9482
Name: Ares(Pookie)
Type: Small or Furry
Color: Sable
Breed: Ferret
Gender: Female
Fixed: Neutered
Age: Adult
Ne 6th st ankeny
Des Moines - South
Lost: 8/29/2018
ID: 9485
Name: Mimi
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen in our home on E Bell Ave and King Ave in Des Moines. We were moving and the cats got out on accident and we have found all but Mimi.. she’s really timid but usually comes if you call her and have patience. She might be in the wooded area behind our house, or across the street. She’s not a fan of car noises so I don’t think she’d be by a street..
Des Moines - East
Lost: 8/28/2018
ID: 9521
Name: Kiki/ kiki marie
Type: Cat
Color: Tan white grey stripped
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Kiki or kiki marie was last seen around her house. She enjoys being outside a few times during the day but always loves to come in and end every day with her owners. So this is unusual of her. She is a very friendly cat who is deeply missed by her mom dad and sister and brother. She was last seen on her street Jefferson st. Right off 33rd. If seen or found please contact immediatley. Thank you!
Des Moines - South
Lost: 8/28/2018
ID: 9486
Name: Coal
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is not declawed. Has scars on nose and missing patch of hair near his eyes.
Des Moines - East
Lost: 8/28/2018
ID: 9480
Name: Taz
Type: Cat
Color: Brown, black, and white
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in Primary Healthcare parking lot off of E. 29th street around midnight.
Des Moines - North
Lost: 8/28/2018
ID: 9470
Name:
Type: Dog
Color: Brown
Breed: Vizsla
Gender: Female
Fixed: Not Neutered
Age: Adult
Nursing mother loose in North Des Moines. Dark brown Vizsla-like dog, approximately 55#’s. Keep an eye out for her and her PUPS along the bike trail as she is likely a stray. She has no collar and was initially seen on 2nd Ave. near North High-school. Last seen headed eastbound into Union Park. Dispatch notified.
Iowa Falls
Lost: 8/27/2018
ID: 9473
Name:
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 8/27/2018
ID: 9469
Name: Bailey
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Senior
54th st and Douglas Ave. was out doing chores and she decided to run. She usually don’t go more then a few blocks from home. She has a habit of running towards the north or south of Douglas Ave
Des Moines - East
Lost: 8/27/2018
ID: 9468
Name: Chevy
Type: Dog
Color: Red/Tan
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Chevy went missing about 9pm - She lives in the 4mile/pleasant Hill area. Please help us bring our baby home!!
Des Moines - East
Lost: 8/27/2018
ID: 9467
Name: DJ
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Last seen on east side between east 30th and east 32nd. Please call 515-321-0931 address is 3112 state avenue
Urbandale
Lost: 8/26/2018
ID: 9476
Name: Marshall
Type: Cat
Color: White and grey
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
I found him but can't delete this post!
Des Moines - Central
Lost: 8/26/2018
ID: 9462
Name: Oliver
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Corner of 35th and Woodland Ave by Price Chopper.
Des Moines - Central
Lost: 8/26/2018
ID: 9461
Name: Maxie
Type: Dog
Color: Tan and White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at Starch Pet Hospital. Escaped our kennels by digging her way out on Sunday 8.26.18 at about 8am near Drake University. She is about 15lbs, tan and white. Please call our clinic 515-283-1576 if you have any information.
Johnston
Lost: 8/26/2018
ID: 9454
Name:
Type: Bird
Color:
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Baby
Bondurant
Lost: 8/25/2018
ID: 9477
Name: Meaux
Type: Cat
Color: Orange and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Front declawed, sweet (but shy), used to going outside at night.
Des Moines - South
Lost: 8/25/2018
ID: 9466
Name: Tessie
Type: Cat
Color: Black and tan
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Last seen Sw9th in between McKinley and Frazier Ave. She has blue eyes. I miss her so much! Please help me bring her home! There is a $200 reward for her safe return.
Des Moines - North
Lost: 8/25/2018
ID: 9465
Name: Max
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen 2309 Saylor Road My son and his girlfriend let the dog out and never said anything to me.. Max may not even be wearing his red collar.
Des Moines - South
Lost: 8/23/2018
ID: 9459
Name: Lion Kitty
Type: Cat
Color: Yellow
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen on sw 24th and Thornton ave
Norwalk
Lost: 8/22/2018
ID: 9451
Name: Meisha
Type: Cat
Color: Grey
Breed: Siamese
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on Maplecrest Dr in Lakewood. She has a dark grey spot on each side of her hind legs
Des Moines - Central
Lost: 8/22/2018
ID: 9448
Name: Logan
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
School Street b/t 31st and 35th
Ankeny
Lost: 8/21/2018
ID: 9440
Name: Max
Type: Dog
Color: Mostly Black, Some Brown
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Adult
Shy, will curl up and try to put his foot in front of his face when scared,
Marshalltown
Lost: 8/20/2018
ID: 11176
Name: Jengo
Type: Dog
Color: Tan and whitr
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on w grant st between 2nd and 3rd st. Marshalltown iowa May have been taken and driven out of town
Ottumwa
Lost: 8/20/2018
ID: 10796
Name: Malorie
Type: Dog
Color: White with black patches
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Shelter rescue she is still a little skiddish and don’t like to be locked up. Contact Brittany 641-799-0136
Johnston
Lost: 8/19/2018
ID: 9490
Name: Nellie
Type: Cat
Color: Calico, white face olive shaped eyes
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Johnston
Lost: 8/19/2018
ID: 9475
Name: Nellie
Type: Cat
Color: Calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Young