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
Clive
Lost: 11/29/2020
ID: 15581
Name: Betty
Type: Dog
Color: Tan and white
Breed: Havanese
Gender: Female
Fixed: Neutered
Age: Senior
She got out in the neighborhood around 75th and Harbach. She is mostly deaf and partially blind.
Des Moines - South
Lost: 11/28/2020
ID: 15632
Name: Unknown
Type: Cat
Color: Gray with stripes
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Found on Southside. Came out of woods on Evergreen Ave behind Hy-Vee on Se 14th and Park.
Des Moines - South
Lost: 11/28/2020
ID: 15593
Name: Barbara
Type: Cat
Color: Silver/grey
Breed: Siamese
Gender: Unknown
Fixed: Not Neutered
Age: Young
Nervous with strangers. Very light in colors. Blue eyes
Winterset
Lost: 11/28/2020
ID: 15591
Name: Bellatrix
Type: Cat
Color: Grey and black striped
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 11/28/2020
ID: 15583
Name: Cupid
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 11/28/2020
ID: 15579
Name: Sasha
Type: Dog
Color: Tan and dark brown
Breed: Yorkie Poo
Gender: Female
Fixed: Neutered
Age: Adult
Last seen 1108 NE 47th Street, Ankeny. Sasha walks and runs with a limp. Offering a reward
Johnston
Lost: 11/28/2020
ID: 15577
Name: Remy
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
Remy is shy and has never been out overnight.
Ankeny
Lost: 11/28/2020
ID: 15573
Name: Sasha
Type: Dog
Color: Tan and golden
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Baby
Seen by 1108 NE 47th
Waterloo
Lost: 11/27/2020
ID: 15654
Name: Gray Baby Smokey
Type: Cat
Color: Gray/Blue
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Was taken from archer ave and dropped off by burton and e parker
Des Moines - South
Lost: 11/27/2020
ID: 15576
Name: Buddha
Type: Cat
Color: cream/brown
Breed: Himalayan
Gender: Male
Fixed: Neutered
Age: Adult
Val-Vista mobile home park, 6901 se. 14th st
Ankeny
Lost: 11/27/2020
ID: 15567
Name: George
Type: Cat
Color: White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Got out of the house in the area of NW 36th St and NW Westwood
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
Pleasant Hill
Lost: 11/26/2020
ID: 15582
Name: elvis
Type: Dog
Color: tricolor
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Baby
he got out of the yard on Thursday around 330 in the afternoon
Des Moines - South
Lost: 11/26/2020
ID: 15564
Name: Ker K’pu
Type: Cat
Color: White, Black, Orange-Yellow
Breed: Corgi
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.
Marshalltown
Lost: 11/25/2020
ID: 15641
Name: Hennessy
Type: Dog
Color: White brown spots
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
Wolf lake, possobly grinnell
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.
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