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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 7/7/2021
ID: 17170
Name: Sadie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Very friendly Purple collar 812 Creston
Norwalk
Lost: 7/7/2021
ID: 17169
Name: Sassy
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
In Norwalk.
West Des Moines
Lost: 7/6/2021
ID: 17182
Name: Chanel
Type: Dog
Color: Black gray brown
Breed: Bichon Frise
Gender: Unknown
Fixed: Neutered
Age: Adult
Pleasant Hill
Lost: 7/6/2021
ID: 17159
Name: Willow
Type: Cat
Color: Diluted Calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
She went missing today while we were having a new AC unit installed. She is an indoor fan that has never been outside. She will be skittish. She is a polydactyl and has extra toes on each foot.
Holland
Lost: 7/5/2021
ID: 17254
Name: Oscar
Type: Dog
Color: Golden
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
He may not come up to you especially men please if you see him just call me I’ll come Get him
Des Moines - West
Lost: 7/5/2021
ID: 17190
Name: Mr. Prickles
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He can act mean/ scared but is a very loved and well taken care of cat. He just needs to come home where he belongs! ♥️
Waterloo
Lost: 7/5/2021
ID: 17153
Name: Keano
Type: Cat
Color: Black/grey
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Is friendly, whines/cries very loudly when scared! Last seen by Hubbard St in Waterloo IA
Waterloo
Lost: 7/5/2021
ID: 17148
Name: Lloyd
Type: Dog
Color: Light brown with black eyebrows
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
1600 block of E. 4th Street Waterloo. He is very scared of everything Thing fireworks scared him while I was inside
Luzerne
Lost: 7/4/2021
ID: 17217
Name: Penny
Type: Dog
Color: Blue merle
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen around 3pm in our back yard.
Luzerne
Lost: 7/4/2021
ID: 17216
Name: Penny
Type: Dog
Color: Blue merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen around 3pm in our back yard.
Bondurant
Lost: 7/4/2021
ID: 17189
Name: Bindy
Type: Dog
Color: Mixed color
Breed: Blue Heeler
Gender: Female
Fixed: Neutered
Age: Young
She's smaller in height. Around 40lbs has a natural cropped tail. Has tags on with her name my address and phone number
Des Moines - East
Lost: 7/4/2021
ID: 17181
Name: Archie
Type: Cat
Color: Orange and white
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Adult
He always comes home after being outside and haven’t seen him since the 4th
Des Moines - East
Lost: 7/4/2021
ID: 17180
Name: Archie
Type: Cat
Color: Orange and white
Breed: Blue Heeler
Gender: Male
Fixed: Neutered
Age: Young
I live in the four mile area. He goes out often but always comes home to eat, sleep, etc. We usually see him everyday and haven't seen him since the 4th. Please let me know if you've seen him.
Boxholm
Lost: 7/4/2021
ID: 17156
Name: Heather
Type: Dog
Color: White and brown
Breed: Shih Tzu
Gender: Unknown
Fixed: Neutered
Age: Adult
Responds to Heather or Heather Russell. Really friendly
Traer
Lost: 7/4/2021
ID: 17140
Name: Harley aka squirt
Type: Dog
Color: rust/reddish brown
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Young
was at 2270 Ridge Rd west of traer.
Des Moines - Central
Lost: 7/4/2021
ID: 17138
Name: Mercury
Type: Cat
Color: Long hair gray
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Senior
Plainview Drive
Charles City
Lost: 7/4/2021
ID: 17128
Name: Sasha
Type: Dog
Color: Black,brown,white on chest
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Near hartwood Hotel in Charles City Iowa very friendly my kids miss her so much please call me 6419039186
Charles City
Lost: 7/4/2021
ID: 17127
Name: Sasha
Type: Dog
Color: Black,brown,white
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by hartwood motel in Charles city
Winterset
Lost: 7/4/2021
ID: 17125
Name:
Type: Dog
Color: Black and gray
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
Urbandale
Lost: 7/3/2021
ID: 17238
Name: Kali
Type: Cat
Color: White, orange, gray
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last seen Kali eve of July 3rd around 10pm. She has a freckle on the top of her nose, has back claws, and is a bit large for being 3 yrs. She is desperately missed.
Ankeny
Lost: 7/3/2021
ID: 17157
Name: Keet keet
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Baby
Dubuque
Lost: 7/3/2021
ID: 17144
Name: Skye
Type: Cat
Color: gray tabby
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Altoona
Lost: 7/3/2021
ID: 17131
Name: Louie
Type: Cat
Color: Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen sleeping on our porch at 19th St. SW
Fairfield
Lost: 7/3/2021
ID: 17129
Name: Kika
Type: Cat
Color: Tabby
Breed: Abyssinian
Gender: Unknown
Fixed: Neutered
Age: Adult
She was seen in a white and tan pick up truck with a 30 something father and early teens daughter.
Des Moines - South
Lost: 7/3/2021
ID: 17122
Name: Diva
Type: Dog
Color: Black
Breed: Pug
Gender: Unknown
Fixed: Unknown
Age: Baby
She was in our back yard at 10:30 pm last night and disappeared shortly around that time.