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>='1606003200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 10/9/2022
ID: 15170
Name: Charlie
Type: Cat
Color: White with black spots/tail
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
At home address. Comes to “Ki Ki”. Friendly
Des Moines - Central
Lost: 11/27/2020
ID: 15565
Name: Mickey
Type: Dog
Color: White and black
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in mondamin residential area
Des Moines - South
Lost: 11/26/2020
ID: 15564
Name: Ker K’pu
Type: Cat
Color: White, Black, Orange-Yellow
Breed: Chihuahua
Gender: Female
Fixed: Not Applicable
Age: Young
Please help me find her way back home.
Des Moines - East
Lost: 11/26/2020
ID: 15561
Name: Blue
Type: Dog
Color: Black Brown White
Breed: Cattle Dog
Gender: Male
Fixed: Unknown
Age: Baby
Blue, went missing around 2 today on the east side near university between Williams and East 33rd. He is around 30 lbs with a brown leather collar on! Please call 515-205-0902. If found or seen! Thank you!
Pleasant Hill
Lost: 11/26/2020
ID: 15559
Name: Elvis
Type: Dog
Color: Tri color
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Baby
Backyard.
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
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.
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 - Central
Lost: 11/21/2020
ID: 15550
Name: Biscuit
Type: Cat
Color: Brown and Black
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Last seen 30th and Euclid Ave by the VA
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.
Des Moines - East
Lost: 11/20/2020
ID: 15525
Name: Poppy
Type: Cat
Color: Grey and white
Breed: Unknown
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen in the morning around East 40th Street, Des Moines, 50317
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.