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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
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/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
Nashua
Lost: 6/29/2019
ID: 12236
Name: Jake
Type: Dog
Color: Black with a white speck on his chest
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Jake has the most beautiful sad golden eyes......we are heartbroken! There is a $500.00 reward for his safe return. 641-228-0579
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
Ankeny
Lost: 6/28/2019
ID: 11730
Name: Kyara
Type: Cat
Color:
Breed: Tiger
Gender: Unknown
Fixed: Unknown
Age: Adult
She is an indoor/ outdoor cat. she has beautiful green eyes.
Des Moines - South
Lost: 6/28/2019
ID: 11728
Name: Brownie
Type: Dog
Color: Brown and white
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
SW 13th St
Carlisle
Lost: 6/27/2019
ID: 11758
Name: shasta
Type: Dog
Color: red/drown/white
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Adult
walking toward flooded field
Polk City
Lost: 6/27/2019
ID: 11723
Name: Thelma
Type: Cat
Color: White, gray, and orange
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is and indoor/outdoor cat. Thelma loves to hunt and is very friendly. She likes to go over by Prarie Flower campground in Saylorville area.
Polk City
Lost: 6/27/2019
ID: 11722
Name: Thelma
Type: Cat
Color: White, gray, and orange
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is and indoor/outdoor cat. Thelma loves to hunt and is very friendly. She likes to go over by Prarie Flower campground in Saylorville area.
Polk City
Lost: 6/27/2019
ID: 11721
Name: Thelma
Type: Cat
Color: White, gray, and orange
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
She is and indoor/outdoor cat. Thelma loves to hunt and is very friendly. She likes to go over by Prarie Flower campground in Saylorville area.
Des Moines - Central
Lost: 6/27/2019
ID: 11697
Name: Pogo
Type: Cat
Color: White black brown
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
This morning while moving
Des Moines - North
Lost: 6/27/2019
ID: 11692
Name: Tilly
Type: Dog
Color: Black and white
Breed: Maltipoo
Gender: Male
Fixed: Not Applicable
Age: Young
2715 59th st Des Moines, Ia
Des Moines - North
Lost: 6/26/2019
ID: 11699
Name: Black kitty of Des Moines
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
Very friendly cat with a few white hairs on her front chest/lower neck.
Des Moines - North
Lost: 6/26/2019
ID: 11698
Name: Black kitty of Des Moines
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
A very friendly cat with a few white hairs on her lower front chest/ lower neck.