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>='1585785600')) ORDER BY pm1.meta_value DESC, post_date DESC
De Soto
Lost: 1/5/2020
ID: 13198
Name: Brixton
Type: Dog
Color: Blue
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Cumberland
Lost: 1/4/2020
ID: 13291
Name: Jake
Type: Dog
Color: Black and white
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Super friendly and dearly missed by his family
Des Moines - Central
Lost: 1/4/2020
ID: 13197
Name: Blue
Type: Dog
Color: Blue (dark gray)
Breed: Weimaraner
Gender: Male
Fixed: Neutered
Age: Senior
Last seen on Boulevard Place near Roosevelt high school. Loves food so would be by trash cans and the like. Is very nice but might not come if called.
Des Moines - East
Lost: 1/4/2020
ID: 13196
Name: zuse
Type: Dog
Color: white brown patch over left eye
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
1030
Urbandale
Lost: 1/3/2020
ID: 13205
Name: Louie
Type: Cat
Color: Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Marion
Lost: 1/3/2020
ID: 13192
Name: Cooper Farrell
Type: Cat
Color: Black and tan with black stripes and silver on the head.
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Please spread the word! Cooper was LOST on January 3, 2020 in Marion, IA 52302 near Douglas Ct and Henderson Dr Marion, IA Message From Owner: Cooper was found in a window well at the age of 7 days. He has been hand fed and raised solely by me. He does not know other people and he is timid and will hide under anything nearby. Please take a minute to look in your yard, garage or under your car. Description: Long haired black and tan striped male cat. Bottom of all feet is black fur. Age is 8 months old and he weighs 11 or 12 lbs. Cooper is an indoor cat so would be timid around strangers. He is neutered, has all shots including rabies and has a microchip # AVID*604*072*796.
Des Moines - East
Lost: 1/3/2020
ID: 13187
Name: Molly
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Adult
She was in our back yard but got out of the fence.
Des Moines - West
Lost: 1/2/2020
ID: 13188
Name: Pilchard
Type: Cat
Color: Light grey
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
She is a scaredy cat. She will be nervous but not mean.
Dubuque
Lost: 1/2/2020
ID: 13186
Name: Waffle
Type: Cat
Color: Black grey and orange
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Baby
Des Moines - Central
Lost: 1/2/2020
ID: 13180
Name: June
Type: Dog
Color: Black/Brown
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 1/2/2020
ID: 13178
Name:
Type: Dog
Color: Chocolate Brown & grey
Breed: Cairn Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Two very sweet boys carin maybe Scottish terriers. One thin brown and chubby black and grey on Park near 14th
Altoona
Lost: 1/1/2020
ID: 13210
Name: Aurora
Type: Cat
Color: Tortoiseshell
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen NE 56th st Altoona country living mobile home park.
Des Moines - East
Lost: 1/1/2020
ID: 13168
Name:
Type: Dog
Color: White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Applicable
Age: Adult
Red harness fluffy white dog
Des Moines - Central
Lost: 1/1/2020
ID: 13163
Name:
Type: Dog
Color: Black white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Davenport
Lost: 1/1/2020
ID: 13161
Name: Angel
Type: Dog
Color: off white
Breed: Lhasa Apso
Gender: Male
Fixed: Neutered
Age: Senior
in my back yard....went to potty...blind...
Davenport
Lost: 1/1/2020
ID: 13160
Name: Angel
Type: Dog
Color: off white
Breed: Lhasa Apso
Gender: Male
Fixed: Neutered
Age: Senior
In my back yard...went to potty..He is very old ...blind...please contact me ...he is my baby
Thurman
Lost: 12/31/2019
ID: 13395
Name: Copper
Type: Dog
Color: White with brown and black
Breed: Basset Hound
Gender: Male
Fixed: Not Neutered
Age: Senior
His name is Copper and last seen in Thurman, Iowa. He is a basset/beagle mix and he's 12. He is super friendly and loves car rides and other animals except SOMETIMES cats. He lost his collar, has arthritis and some hearing loss. We believe someone took him but may have dropped him off once they figured out his age.
Des Moines - South
Lost: 12/31/2019
ID: 13177
Name: June
Type: Dog
Color: Light brown body with dark black nose, forehead, black on ears and some dark through her fur.
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Not Neutered
Age: Adult
She just had puppies so she still has milk still coming in and her nipples are enlarged and sore.
Carlisle
Lost: 12/31/2019
ID: 13166
Name: Zoey
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Adult
Johnston
Lost: 12/31/2019
ID: 13164
Name: Gizzy (Gizmo)
Type: Cat
Color: Black, orange, white
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at Providence pointe apartments Johnston around 5-6pm
West Des Moines
Lost: 12/31/2019
ID: 13157
Name: Sheba
Type: Dog
Color: Red
Breed: Shiba Inu
Gender: Unknown
Fixed: Neutered
Age: Senior
Waukee
Lost: 12/30/2019
ID: 13151
Name: Luke
Type: Cat
Color: Light Gray with White Chest and Toes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is very timid, please do not chase! He will run. Please text or call me if you see him! He was last seen in the mobile home court (Midwest Country Estates) on Collins Drive and Dartmoor.
Des Moines - North
Lost: 12/30/2019
ID: 13150
Name: Winston
Type: Bird
Color: Gray/white
Breed: Cockatiel
Gender: Male
Fixed: Unknown
Age: Young
Near Grandview College in Des Moines
Des Moines - Central
Lost: 12/30/2019
ID: 13149
Name: Unknown
Type: Dog
Color: Black and tan
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Adult
Found E 22nd Street bear Guthrie
Ankeny
Lost: 12/29/2019
ID: 13145
Name: Elsie
Type: Cat
Color: White/Brown
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young