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
Altoona
Lost: 9/8/2019
ID: 5901
Name: Ginger
Type: Cat
Color: White with black & orange spots
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Ginger is a small, friendly cat. We miss her bunches!
Des Moines - North
Lost: 9/7/2019
ID: 12321
Name: GrayC
Type: Cat
Color: Gray
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Does not have a tail
Des Moines - East
Lost: 9/7/2019
ID: 12299
Name: Rose
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Baby
On E 22ct near Dairy Zone. She isn't collared currently bc she doesn't wear a collar inside. She has a distinctive limp from trauma as a puppy.
Altoona
Lost: 9/6/2019
ID: 12339
Name: Takao
Type: Cat
Color: Tan with white stripes
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
West Des Moines
Lost: 9/6/2019
ID: 12303
Name: Bella
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
09/06/19
Waukee
Lost: 9/6/2019
ID: 12302
Name: Cleo
Type: Cat
Color: Black white brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She was walking around 156th and Meredith.
Mount Pleasant
Lost: 9/5/2019
ID: 12313
Name: Luna
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Later in the afternoon near old threshars grounds. Shes thin but healthy. Affectionate outdoors cat
Cedar Rapids
Lost: 9/5/2019
ID: 12300
Name: Maggi
Type: Dog
Color: Black and white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
She snuck out of the fence when she was let out
Des Moines - East
Lost: 9/5/2019
ID: 12292
Name: Sammie
Type: Dog
Color: Black
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
Sweet dog loves kids and is an indoor dog.
Des Moines - Central
Lost: 9/4/2019
ID: 12281
Name:
Type: Cat
Color: Light brown tiger strip
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
On 53rd st between Urbandale ave and Hickman rd
Des Moines - South
Lost: 9/3/2019
ID: 12317
Name: Taz Devil
Type: Cat
Color: Gray with white on chest
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen 9/03/2019 he will box with you if you use your thumb and pinkie finger and he will also run and jump on your arm and he will talk to you and he loves to cuddle when ready to lay down.
Des Moines - South
Lost: 9/3/2019
ID: 12291
Name: Charlie
Type: Cat
Color: Brown Siamese
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
East Marion St. - Indianola Ave.
Des Moines - South
Lost: 9/3/2019
ID: 12289
Name: KiKi
Type: Cat
Color: Torrie/calico
Breed: Dilute Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Adult
Escape from the house in the morning before we could catch her and has not returned
Grimes
Lost: 9/3/2019
ID: 12283
Name: Baloo
Type: Dog
Color: White/orange spot
Breed: Greyhound
Gender: Male
Fixed: Neutered
Age: Young
Last seen by lion park in grimes , near NE 8th and highway 141, black collar no tags but is microchipped.
Altoona
Lost: 9/3/2019
ID: 12278
Name: Zorro
Type: Cat
Color: Black and White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
I saw him on the found pet page. It’s too late to call and it won’t let me leave a message. He is the Tuxedo with the big yellow eyes. I will be there first thing in the morning after I know what location he’s at.
Des Moines - South
Lost: 9/2/2019
ID: 12363
Name: Jeter
Type: Dog
Color: White and Tan
Breed: Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
SE 6th and Scandia. He had just had a bath and his collar was removed.
Atlantic
Lost: 9/2/2019
ID: 12275
Name: Sally
Type: Cat
Color: White and Grey
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Call 249 9616
Des Moines - West
Lost: 9/2/2019
ID: 12261
Name: Sugar
Type: Dog
Color: Brown
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 9/1/2019
ID: 12670
Name: Rocko
Type: Dog
Color: Tan and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
Last seen by Lincoln. High school
Ankeny
Lost: 9/1/2019
ID: 12627
Name: Kiara
Type: Dog
Color: Light brown
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Ankeny area
Oelwein
Lost: 9/1/2019
ID: 12322
Name: Buster
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Baby
Last seen in the NW area of Oelweinites
Des Moines - South
Lost: 9/1/2019
ID: 12284
Name: Luna
Type: Cat
Color: Gray/Striped
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
South east side of des moines. Very friendly.
Urbandale
Lost: 9/1/2019
ID: 12256
Name: Rory
Type: Dog
Color: White
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Young
Rory was last seen by 100th street in Urbandale.
Urbandale
Lost: 9/1/2019
ID: 12255
Name: Rory
Type: Dog
Color: White
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Young
Near 100th street in Urbandale
Ames
Lost: 9/1/2019
ID: 12253
Name: Burgie
Type: Cat
Color: White chest multi-colored everywhere else.
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
Inside the house off of Duff and O’Neil