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>='1610928000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - North
Lost: 6/26/2019
ID: 11693
Name: Jr
Type: Dog
Color: White , with black spots
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Last seen Walking on ovid by him self .
Des Moines - North
Lost: 6/26/2019
ID: 11681
Name: Dolly
Type: Dog
Color: Tan with black snout and bits of black on body
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
4900 block of Lyndale Drive about 4:00-4:30 pm
Ankeny
Lost: 6/26/2019
ID: 11678
Name: Louie
Type: Dog
Color: White and brown
Breed: Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Got out of house on NW 26th St. recently moved so he doesn’t know his surroundings
Altoona
Lost: 6/25/2019
ID: 11757
Name: Fozzie
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near 2600 Adventureland Dr