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: 7/4/2019
ID: 11771
Name: Winnie
Type: Dog
Color: Brown tan
Breed: Black Mouth Cur
Gender: Unknown
Fixed: Not Applicable
Age: Adult
SHE HAS BEEN FOUND 7/5/19
Grand Junction
Lost: 7/4/2019
ID: 11770
Name: Sarah
Type: Dog
Color: Brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
She has no teeth, very scared if fireworks and thunder.
Des Moines - East
Lost: 7/4/2019
ID: 11763
Name: Duke
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Young
Not aggressive at all, very hyper though
West Des Moines
Lost: 7/4/2019
ID: 11762
Name: Seven
Type: Dog
Color: Black/white
Breed: Alaskan Malamute
Gender: Male
Fixed: Neutered
Age: Senior
Wearing black harness
Colfax
Lost: 7/3/2019
ID: 11781
Name: Joplin
Type: Dog
Color: Brindle w/ white on neck
Breed: Boxer
Gender: Female
Fixed: Not Applicable
Age: Young
Reward can be given. She is very friendly, especially with other dogs and children. I just need her home with us.
Johnston
Lost: 7/3/2019
ID: 11779
Name: Frank
Type: Cat
Color: White gray brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
Around Pioneer Parkway Very friendly Just 2 years old
Altoona
Lost: 7/3/2019
ID: 11766
Name: Rose/Rosie
Type: Dog
Color: Tan with brown ears and a white front paw
Breed: Fox Terrier
Gender: Unknown
Fixed: Neutered
Age: Senior
July 3rd. She is very friendly, partly blind. Loves people and kids.
Des Moines - Central
Lost: 7/3/2019
ID: 11759
Name: Sailor
Type: Dog
Color: Black and white
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Young
Sailor tore down fence panels and disappeared from my back yard. He is a gentle soul and is seeet as can be. Sailor is terrified of loud noises and storms!
West Des Moines
Lost: 7/3/2019
ID: 11752
Name: Tucker
Type: Dog
Color: Brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
He was just groomed, he got out this morning sometime.
Dallas Center
Lost: 7/2/2019
ID: 11746
Name: Gizmo
Type: Dog
Color: White and brown
Breed: Maltese
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen with male golden retriever running around Dallas center
Dallas Center
Lost: 7/2/2019
ID: 11745
Name: Shadow
Type: Dog
Color: Golden Blond
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Dallas Center he is running around with another dog that is a male Teddy Bear dog
Des Moines - North
Lost: 7/2/2019
ID: 11744
Name: Bob
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on East Douglas Avenue. Bob has unique characteristics such as fur on his nose, a short broken tail and he is declawed. Please contact with any information. It is very hot outside and we are very concerned.
Des Moines - North
Lost: 7/1/2019
ID: 11785
Name: Koba
Type: Dog
Color: Brown
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Young
My mom sold him to someone leaving the ARL without me knowing, I just want him back. Please help me.
Berwick
Lost: 7/1/2019
ID: 11747
Name: Pelusa
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen at SunnyBrook Mobile Homes
Pleasant Hill
Lost: 7/1/2019
ID: 11743
Name: Peanut
Type: Dog
Color: Black and white
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Baby
Dog lost in pleasant hill near the Deery brothers Chevy dealership. Female, named peanut. Was watching her for my parents so she doesn’t know her way around. If found, please call 712-887-1299
Des Moines - North
Lost: 7/1/2019
ID: 11741
Name: Shorty
Type: Dog
Color: Brown
Breed: Dachshund-Miniature
Gender: Male
Fixed: Unknown
Age: Senior
Motel 6 Room214. The people gave my dog to someone else, who is ignoring my calls
Victor
Lost: 6/30/2019
ID: 11944
Name: Milo
Type: Cat
Color: White with grey tiger
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
I-80W rest area by Victor. Has white tip on tail and white heart shape on back by hips. Only 1 year old. Squeaky low meow.
Des Moines - East
Lost: 6/30/2019
ID: 11738
Name: Ella
Type: Dog
Color: Black and white
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Crooked ear Call and text if you find her (515)-306-3391
West Des Moines
Lost: 6/30/2019
ID: 11737
Name: Jasper
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
At home the evening of June 30th
Asbury
Lost: 6/30/2019
ID: 11736
Name: JAZZEBELL
Type: Dog
Color: Black/white/gray
Breed: Poodle Miniature
Gender: Unknown
Fixed: Not Applicable
Age: Senior
9 am June 30th. Brook hollow drive. Hard of hearing. Tiny , petite, special food diet. Almost 16 years old.
West Des Moines
Lost: 6/30/2019
ID: 11726
Name: Oliver
Type: Dog
Color: Tan and white
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Neutered
Age: Young
8 am in our back yard. He got through the electric fence
Des Moines - East
Lost: 6/29/2019
ID: 11761
Name: Coco
Type: Cat
Color: White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Corner of 27 and Capitol
Panama
Lost: 6/29/2019
ID: 11753
Name: coco
Type: Dog
Color: light brown and white
Breed: Corgi
Gender: Female
Fixed: Neutered
Age: Adult
North 2nd Street in Panama, Iowa
Altoona
Lost: 6/29/2019
ID: 11734
Name: Mor
Type: Dog
Color: Brown & White
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Service Dog. Was wearing handler tags
Des Moines - East
Lost: 6/28/2019
ID: 11784
Name:
Type: Cat
Color: Grey and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on 255th and Elizabethg