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>='1613865600')) ORDER BY pm1.meta_value DESC, post_date DESC
Marshalltown
Lost: 11/25/2020
ID: 15572
Name: Hennessy
Type: Dog
Color: White
Breed: Pit Bull
Gender: Unknown
Fixed: Not Neutered
Age: Young
Has been spotted twice On Underwood Road and near Wolf Ranch.
Des Moines - South
Lost: 11/25/2020
ID: 15556
Name: KarmaBoo
Type: Dog
Color: Blonde
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Karma has a red 40 lease still attached to her collar. I’m afraid she’s got hung up on something
Marshalltown
Lost: 11/24/2020
ID: 15768
Name: henesy
Type: Dog
Color: white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 11/24/2020
ID: 15549
Name: Steven
Type: Cat
Color: Grey and white
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Baby
He is not chipped or neutered (we have an appointment set up for him soon) please help us bring him home.
St. Marys
Lost: 11/23/2020
ID: 15588
Name: Chrisp
Type: Cat
Color: Gray and White
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Outside of Saint Mary, Iowa Clipped ear Very friendly to our family shy around stranger at times
Ankeny
Lost: 11/23/2020
ID: 15562
Name: Frankie
Type: Dog
Color: Tan and black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen on state and first st
Ankeny
Lost: 11/23/2020
ID: 15557
Name: Shiro
Type: Cat
Color: Black/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 11/23/2020
ID: 15548
Name: Madden
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in the East Lake area. Scares easily as he is an inside kitty.
Iowa City
Lost: 11/23/2020
ID: 15546
Name:
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
Yesterday
Cumming
Lost: 11/23/2020
ID: 15545
Name: Pooter
Type: Dog
Color: Brown and white
Breed: Basset Hound
Gender: Male
Fixed: Neutered
Age: Young
Last seen at home around 10pm.
Ankeny
Lost: 11/23/2020
ID: 15543
Name: Shiro
Type: Cat
Color: Black/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Lost around Applebee's on 1st street in Ankeny
Des Moines - North
Lost: 11/22/2020
ID: 15840
Name: Sasha
Type: Dog
Color: Purple
Breed: Australian Shepherd
Gender: Unknown
Fixed: Neutered
Age: Young
All pets hospital 2nd ave Des Moines Iowa
Des Moines - North
Lost: 11/22/2020
ID: 15839
Name: Sasha
Type: Dog
Color: Black tan
Breed: Australian Shepherd
Gender: Unknown
Fixed: Neutered
Age: Young
All pets hospital 2nd ave Des Moines Iowa
Urbandale
Lost: 11/21/2020
ID: 15544
Name: Lucy
Type: Dog
Color: Black and white
Breed: Jack Russell Terrier (Parson Russell Terrier)
Gender: Female
Fixed: Neutered
Age: Senior
122nd and Airline Urbandale
New Virginia
Lost: 11/21/2020
ID: 15539
Name: Kevin
Type: Dog
Color: Black with some grey and white on his chest, neck, chin and paws
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Senior
Des Moines - South
Lost: 11/21/2020
ID: 15532
Name: Tex
Type: Dog
Color: White/black brown spots/brown face
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Very very friendly. Loves car rides so will more than likely get into a car with anyone.
Conrad
Lost: 11/20/2020
ID: 15537
Name: Denver
Type: Dog
Color: Black Tri Colored (Black/Brown/White)
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Friday 11/20 in the afternoon on Newby Ave East of Liscomb. Denver is very friendly, and knows his name well! He is smart, so he could be keeping warm in an outbuilding or shelter. He is used to being an indoor/outdoor dog.
Colfax
Lost: 11/20/2020
ID: 15536
Name: Opie
Type: Cat
Color: Tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He darted out of our home that is the 400 S. Ryan St. area of Colfax. He was hiding & we couldn't get him, he was not there in the morning & has never returned.
Bondurant
Lost: 11/20/2020
ID: 15531
Name: Gunnet
Type: Dog
Color: Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
608 37th st saw Bondurant
Webster City
Lost: 11/20/2020
ID: 15529
Name: Major
Type: Dog
Color: Tan and Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
Can open doors and got out over night. 303 oak street in webster city. Very friendly.
West Des Moines
Lost: 11/20/2020
ID: 15526
Name: Sammy
Type: Cat
Color: Orange Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Sammy dug under the fence early this morning. He is orange with white markings on his face, chest and has white toes on all four feet. He is wearing blue collar on with a phone number on it and and collar has a bell. He is microchipped. Sammy is 2 years old. Lost around EP True Pkway and 33rd St. area.
Dubuque
Lost: 11/19/2020
ID: 15552
Name: Decker
Type: Cat
Color: Bi color tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Was wearing a bell collar with navy and orange and aqua fish
Des Moines - West
Lost: 11/19/2020
ID: 15514
Name: Miko
Type: Dog
Color: Tan and black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
He and our other dog tux/tiger were stolen out of their outdoor kennel this morning/late last night. We wanted to let them enjoy the good weather before its over.. Our girls are devastated right now.
Des Moines - North
Lost: 11/19/2020
ID: 15512
Name: Unknown
Type: Dog
Color:
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Unknown
Age: Adult
They are in backyard of 2411 60th Street. DSM
Shenandoah
Lost: 11/18/2020
ID: 15510
Name: Christine
Type: Cat
Color: Tortoiseshell grey
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Last saw her Thursday the 18th at 4 pm. Never came home last night like she always does responds to Christine maybe a little shy but she is very vocal and if you pick her up she'll tell you all about it she loves to talk with people. Please help find my baby I miss her.