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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 9/27/2019
ID: 12454
Name: Sky
Type: Dog
Color: Black/white
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Young
No I let them out and somebody left the gate open and they ran
Boone
Lost: 9/27/2019
ID: 12453
Name: Trigger
Type: Dog
Color:
Breed: Great Dane
Gender: Male
Fixed: Unknown
Age: Young
Trigger was last seen in the Boone/Woodward area! He is very friendly!
Des Moines - North
Lost: 9/27/2019
ID: 12452
Name: Unknown
Type: Dog
Color: White and gray
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
Last seen by park fair mall with older husky
Des Moines - East
Lost: 9/26/2019
ID: 12507
Name: Hinami
Type: Cat
Color: Gray
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Young
By Tiffany avenue. She’s friendly but runs from strangers unless tempted by food.
Des Moines - West
Lost: 9/26/2019
ID: 12449
Name: Shorty
Type: Dog
Color: Black and white
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
SW 31st street and Park Ave
Ankeny
Lost: 9/26/2019
ID: 12445
Name: Mitzi
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Possibly 6pm in neighborhood
Ankeny
Lost: 9/25/2019
ID: 12494
Name: Mitzi
Type: Cat
Color: Black & White
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Adult
(Spade) In Prairie Trail backed up to SW Irvinedale. Indoor cat. Super friendly. Black spot on her nose. Declawed.
Defiance
Lost: 9/25/2019
ID: 12456
Name: Dragunov
Type: Dog
Color: Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Will prob be with a German shorthair
Defiance
Lost: 9/25/2019
ID: 12455
Name: Dance
Type: Dog
Color: White
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Not Neutered
Age: Adult
2200th and ironwood Will prob be with a German Shepard
Des Moines - North
Lost: 9/25/2019
ID: 12439
Name: Rocky
Type: Dog
Color: Fawn
Breed: Mountain Cur
Gender: Male
Fixed: Unknown
Age: Adult
Last seen on Lower Beaver area
Urbandale
Lost: 9/25/2019
ID: 12435
Name:
Type: Dog
Color: Black and white
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Baby
Ankeny
Lost: 9/25/2019
ID: 12433
Name:
Type: Dog
Color:
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Young
This fella was almost hit on the highway east of saylorville on way to Ankeny. He’s super sweet. I took him to the arl.
Boxholm
Lost: 9/24/2019
ID: 12450
Name: Ryder
Type: Dog
Color: Blue Merle
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen running down 130th st and hwy 169 near Boxholm. Ryder has one eye that is half blue/brown.
Altoona
Lost: 9/24/2019
ID: 12429
Name: Zeta
Type: Dog
Color: Tan/black
Breed: Belgian Shepherd
Gender: Unknown
Fixed: Unknown
Age: Young
She was in the house when we left for work. Have dog door that goes out into fenced yard. She will bark a lot at people she does not know but friendly.
Des Moines - South
Lost: 9/23/2019
ID: 12476
Name: Tigra
Type: Cat
Color: Calico...black and tan
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Senior
Very friendly
Des Moines - East
Lost: 9/23/2019
ID: 12446
Name: Trixie
Type: Dog
Color: Brown and tan
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen in the area of 28th and Walnut St. It was bout 1130pm she is a great dog and the kids and I miss her dearly please do the right thing and give her back. She also is got some hair missing on her back due to dry skin also because she is older 8yrs she has some gray patches of hair on her back
Clive
Lost: 9/23/2019
ID: 12434
Name: Merlin
Type: Cat
Color: Black and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Senior
Blind
Des Moines - East
Lost: 9/23/2019
ID: 12427
Name: Trixie
Type: Dog
Color: Brown and
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Baby
Purple collar got some patches of hair missing on back it's a chihuahua terrier mix
Ankeny
Lost: 9/23/2019
ID: 12425
Name: Ruby
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
She was last seen at our home in Ankeny (Delaware Crossing) she is very friendly and will come to her name Ruby.
Des Moines - East
Lost: 9/23/2019
ID: 12423
Name: Cheif
Type: Dog
Color: Beige n white
Breed: Blue Heeler
Gender: Male
Fixed: Unknown
Age: Young
Indianola
Lost: 9/22/2019
ID: 12708
Name:
Type: Cat
Color: Black/ orange/white
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
She comes by daily. Very friendly. She is beautiful.
Sumner
Lost: 9/22/2019
ID: 12462
Name: Huck
Type: Dog
Color: Tan/white
Breed: Foxhound
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 9/22/2019
ID: 12428
Name: Lucy
Type: Dog
Color: Fawn
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Senior
She is very old (17) and deaf
Weldon
Lost: 9/22/2019
ID: 12426
Name: Miesha
Type: Dog
Color: Red and White
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
She normally explore the wood behind the house but, she hasn't came home. If you see her it may be easier to catch her with a hot dog
West Des Moines
Lost: 9/22/2019
ID: 12418
Name:
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
22nd and Westown West Des Moines