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
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
West Liberty
Lost: 8/14/2018
ID: 9393
Name: Monk
Type: Cat
Color: Black with a white spot on front of neck
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Last seen at 7AM on August 14. 9-10 years old and about 8 lbs. Monk has a thyroid disorder (that's why he's pretty small right now) and needs his medicine! He has a small notch on the tip of his right ear from an injury when he was a kitten. Extremely friendly (so, he may have willingly gone off with someone!).
Des Moines - North
Lost: 8/14/2018
ID: 9388
Name: Oreo
Type: Dog
Color: Black white, little brown on face
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
By park fair mall.
Pleasant Hill
Lost: 8/13/2018
ID: 9414
Name: Oakley
Type: Dog
Color: Black
Breed: Rat Terrier
Gender: Female
Fixed: Neutered
Age: Young
Pleasant Hill
Lost: 8/13/2018
ID: 9413
Name: Oakley
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Urbandale
Lost: 8/13/2018
ID: 9392
Name: Juicy
Type: Cat
Color: Grey, white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Friendly, likes to be outside.
Clive
Lost: 8/13/2018
ID: 9382
Name: Unknown
Type: Cat
Color: Charcoal Gray with White Socks
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
At Boston Parkway and NW 164th Street, Clive.
Ankeny
Lost: 8/13/2018
ID: 9370
Name: Max
Type: Dog
Color: Tan and Black
Breed: Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
In Ankeny near Georgetown Blvd and Ankeny Blvd. He is friendly and has the energy of a 6 month old pup.
Des Moines - East
Lost: 8/12/2018
ID: 9427
Name: Arya
Type: Cat
Color: Grey tortie
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Last seen at 19th st and Capitol Avenue. I let the dogs out at 3am and she bolted. Normally she hangs around and comes back so far I have not found her. She hates to be held but very loving cat. Will rub up on you. Has a fat roll underneath. She's an inside cat and just recently started trying to escape all the time. She will be 2 in September and her twin is very sad without her. 515-494-8852
Audubon
Lost: 8/12/2018
ID: 9410
Name: Phoenix “Callie” Phantom Phyllis
Type: Dog
Color: Black & Tan/Brown Phantom Color
Breed: Poodle Toy
Gender: Female
Fixed: Unknown
Age: Young
Last seen near Chicago St, Audubon, IA. Last appearance with unfinished haircut, no collar. About 7lbs, 8inches tall from head to toe. She survived the fire with us so she really haa a sentimental value for my family. I can't sleep good thinking about her and I am so worried about her... Please help us find her. I am willing to give a reward to anyone who can find and bring her back to us safe and sound... Thank you so much...
Ogden
Lost: 8/12/2018
ID: 9400
Name: Sammy
Type: Cat
Color: White/striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He's a very large cat. Hes probably scared but when he's comfortable he's super friendly. He was lost at 214 E Walnut St in Ogden.