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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
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,
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
Des Moines - North
Lost: 8/18/2018
ID: 9516
Name: Taffy
Type: Cat
Color: white & orange
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen off of Franklin and 2nd Ave
Wheatland
Lost: 8/18/2018
ID: 9425
Name: Archie
Type: Dog
Color: Reddish/Brown
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Archie broke off of his collar which was connected to a tie out inside of our fenced in yard.
Des Moines - Central
Lost: 8/18/2018
ID: 9420
Name: Jackson
Type: Dog
Color: Tri-color
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
2724 Mondamin Ave. DM 50310 near Drake If found please call Doug at 319-512-1569. Thanks!
Dexter
Lost: 8/17/2018
ID: 9433
Name: Cowboy
Type: Dog
Color: Black and white
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Lost near Dexter elementary Cowboy is hard of hearing and has trouble seeing in the dark. He weighs approx 17 lbs has a nice built despite his age, tail is docked, he is black and white with some very faint faded tan on his face due to aging.
Mediapolis
Lost: 8/17/2018
ID: 9426
Name: Larenzo
Type: Dog
Color: White
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Mediapolis, Iowa. His collar slipped off of him, that’s how he got away. 6months old. Please call or text 515-341-7414
Walford
Lost: 8/17/2018
ID: 9418
Name: Bullet
Type: Dog
Color: Black/white
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
Last seen near trinity lutheran church in walford
Kensett
Lost: 8/17/2018
ID: 9409
Name: Penny
Type: Dog
Color: Tan
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
At the Kensett trash place and she jumped out of the window. We adopted her 3 years ago and she is very skiddish, hard to approach. If you see her, please call us at 303-995-2174 or 303-995-2098. We love her!
Runnells
Lost: 8/17/2018
ID: 9408
Name: Pawbella
Type: Dog
Color: Gray
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
She is friendly to anyone maybe shy at first She was last seen with her brother patron If seen please call 515-803-3923
Runnells
Lost: 8/17/2018
ID: 9407
Name: Petron
Type: Dog
Color: Light brown/dark brown
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
They are friendly to anyone. Maybe a little scared at first. He was last seen in runnels elementary school with his sister pawbella If seen please call 515-803-3923
Waukee
Lost: 8/16/2018
ID: 9405
Name: Ella
Type: Dog
Color: White, black and brown spots
Breed: Bluetick Coonhound
Gender: Female
Fixed: Neutered
Age: Adult
Last seen August 16th around 7 pm
Des Moines - Central
Lost: 8/16/2018
ID: 9398
Name:
Type: Dog
Color: White
Breed: Wheaten Terrier
Gender: Female
Fixed: Unknown
Age: Adult
34th st and Franklin ave
Carlisle
Lost: 8/15/2018
ID: 9416
Name: Stormie
Type: Cat
Color: White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Trailer court in carlisle
Des Moines - Central
Lost: 8/15/2018
ID: 9415
Name: Cotton
Type: Cat
Color: white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 8/15/2018
ID: 9406
Name: Zoom
Type: Cat
Color: Pure white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
920 E Jefferson Ave he can walk on a leash he is deaf, knows 5 tricks, shakes hands, kisses nose with his nose, lays down with hand flat on floor, sits pretty but will only do it for temptations treats can mimic yes and no by doing the motion with him.
Allison
Lost: 8/15/2018
ID: 9396
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Cute little kitty roaming on HWY 3 in country not near a home. Between Allison & Dumont. No colllar.
Des Moines - Central
Lost: 8/14/2018
ID: 9956
Name: Rosco y primo
Type: Dog
Color: Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Young
Hi they left from my yard and they were rescued and the animal rescue asked for 400$ for vaccines es when they did have vaccinated until 2019 instead or help ppl they are ripping ppl off and my daughter is suffering she doesn't want to go to school she is mad a me etc.so pleae I beg you if you see them location or the new temporary owner call me at 917-284-5336 so we can come to some aggreement.thank you Alberto