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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 4/12/2018
ID: 8335
Name: Luna
Type: Cat
Color: White/grey
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Senior
Ankeny
Lost: 4/12/2018
ID: 8334
Name: Luna
Type: Cat
Color: White/gray
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Senior
Ankeny
Lost: 4/12/2018
ID: 8333
Name: Luna
Type: Cat
Color: White/gray
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Senior
Estherville
Lost: 4/12/2018
ID: 8299
Name: Spot
Type: Dog
Color: Brindle
Breed: Welsh Corgi Cardigan
Gender: Male
Fixed: Unknown
Age: Young
4 miles south of Estherville near Hwy. 4
Indianola
Lost: 4/12/2018
ID: 8296
Name: Scout/Jade
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Adult
Scout- 11 y/o male, Jade- 3 y/o female. Both friendly, though Jade can be timid.
Des Moines - West
Lost: 4/12/2018
ID: 8289
Name:
Type: Dog
Color: Black and Tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Senior
With me
Mason City
Lost: 4/11/2018
ID: 8297
Name: Koko
Type: Dog
Color: Black and white
Breed: Poodle
Gender: Female
Fixed: Neutered
Age: Young
She is very energetic and likes to bark.
Des Moines - East
Lost: 4/11/2018
ID: 8288
Name: Pepperd
Type: Cat
Color: brown tiger stripped with black down his back & tail
Breed: Poodle
Gender: Male
Fixed: Neutered
Age: Adult
brown tabby with a lot of black, has a nick in one ear, very friendly, his name is Peppers
Des Moines - South
Lost: 4/11/2018
ID: 8285
Name: Brooklyn
Type: Dog
Color: Black
Breed: Maltese
Gender: Unknown
Fixed: Unknown
Age: Adult
Lost on southeast side of Des Moines by SE 27th and Pine. She has a white spot on her left front paw and gray whiskers around her face.
Marshalltown
Lost: 4/10/2018
ID: 8300
Name: Trouble, Formerly Akira
Type: Dog
Color: White and Black
Breed: Alaskan Husky
Gender: Female
Fixed: Neutered
Age: Adult
Lost around the fairgrounds. Had been recently added to our family from the ARL. They said she was found as a stray originally.
Des Moines - East
Lost: 4/10/2018
ID: 8298
Name: Titan
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
He slipped out the house approximately around 12am. He hasn’t been seen since. We reside by the AE cows. He has all his claws and is not neautured. He is pretty large in size but normal in weight.
Blakesburg
Lost: 4/9/2018
ID: 8311
Name: Paisley
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Adult
Running around with neighbor dogs and our other dogs.
Des Moines - Central
Lost: 4/9/2018
ID: 8274
Name:
Type: Cat
Color: White, black, brown
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Baby
8th and Washington ave
Des Moines - East
Lost: 4/8/2018
ID: 8342
Name: Lola/laly
Type: Dog
Color: White
Breed: Maltese
Gender: Female
Fixed: Unknown
Age: Adult
She have long nail, she is missing from east 17th. She need her medication
West Des Moines
Lost: 4/8/2018
ID: 8268
Name: Emmett
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
very nice social cat. no front claws
Des Moines - Central
Lost: 4/8/2018
ID: 8267
Name: Lola
Type: Dog
Color: White
Breed: Maltese
Gender: Female
Fixed: Not Applicable
Age: Adult
17th court and University. She is sick and in need of daily medication. If seen or found, please contact Susana at 515-441-4693. Thank you so much
Story City
Lost: 4/7/2018
ID: 8319
Name: Chloe
Type: Dog
Color: Black with 2 white front paws
Breed: Dachshund-Miniature
Gender: Female
Fixed: Unknown
Age: Adult
At trailer court in story city, she took off after s rabbit
Des Moines - North
Lost: 4/7/2018
ID: 8266
Name: Alice
Type: Dog
Color: Brindle
Breed: Dachshund-Miniature
Gender: Female
Fixed: Not Neutered
Age: Young
Saylor Township NW 66th Place South of Ankeny, west of 2nd Ave.
Des Moines - North
Lost: 4/7/2018
ID: 8265
Name: Alice
Type: Dog
Color: Brindle
Breed: Basenji
Gender: Unknown
Fixed: Not Neutered
Age: Young
Saylor Township NW 66th Place south of Ankeny west of 2nd Avenue
Bondurant
Lost: 4/7/2018
ID: 8261
Name:
Type: Dog
Color: Tan and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 4/7/2018
ID: 8258
Name: Sadie
Type: Dog
Color: blk and tan
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Senior
Stanton and 22nd by the airport
Des Moines - East
Lost: 4/6/2018
ID: 8262
Name: Sally
Type: Cat
Color: Black and white
Breed: Beagle
Gender: Unknown
Fixed: Neutered
Age: Senior
She ran outside and usually comes back, on east side near Kmart
Des Moines - South
Lost: 4/5/2018
ID: 8277
Name: Lilo
Type: Cat
Color: Black, brown, tan, white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Dema dr. Des Moines, IA
Des Moines - East
Lost: 4/5/2018
ID: 8270
Name: Spots
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 4/5/2018
ID: 8254
Name: Kitty
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
5th and grand west des moines