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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Knoxville
Lost: 2/11/2016
ID: 2330
Name: Jager
Type: Dog
Color: Brindle and white
Breed: English Bulldog
Gender: Male
Fixed: Unknown
Age: Young
Traveling with a black lab named Robbie who is also missing
Des Moines - East
Lost: 2/10/2016
ID:
Name: Fluffy
Type: Dog
Color: White /apricot
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Senior
Fluffy was last seen around 1030/1100 am on Brook Run Drive on the east side.He was wearing a teashirt that had studs on it that said bling ,bling.He is a senior dog.Very sweet and likes to cuddle.He is an inside dog and not use to the cold.Please if you see him please give me a call.Hes my running buddy.Thanks!
Martensdale
Lost: 2/8/2016
ID: 2320
Name: Anakin
Type: Dog
Color: black and tan
Breed: Bichon Frise
Gender: Male
Fixed: Not Neutered
Age: Adult
White spot on his chest, ears aren't docked, arthritis in his leg, still has his duclaws, and he belongs to my brother whom is half blind
Des Moines - North
Lost: 2/7/2016
ID: 2322
Name: Finn
Type: Cat
Color: orange tabby
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Sunday afternoon at home in Beaverdale/Drake neighborhood.
Des Moines - East
Lost: 2/6/2016
ID: 2398
Name: Kit-Kat
Type: Cat
Color: Gray w Brownish & White w Black Tiger Stripes
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen at home 4152 E 32nd St. Round 4:45 pm. 3 month old kitty female. Please contact me if you have seen her know where she is or even if you found her and kept her please let me know she's alright. She's my baby and need to find her or know she's okay. Thank You, (515)991-0566 (515)556-9038
Des Moines - East
Lost: 2/6/2016
ID: 1843
Name: Titan
Type: Dog
Color: Light brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Very friendly will come if name is called.
Winterset
Lost: 2/5/2016
ID: 2423
Name: Cassie Ann
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
6 miles north of Winterset highway 169
Winterset
Lost: 2/5/2016
ID: 2309
Name: Cassie Ann
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Winterset highway 169
Winterset
Lost: 2/5/2016
ID: 2308
Name:
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Winterset highway 169
Des Moines - East
Lost: 2/4/2016
ID: 2334
Name: KITTY / KIT-KAT
Type: Cat
Color: GRAY WITH BLACK TIGER STRIPES LITTLE BIT OF BROWN & WHITE AROUND MOUTH
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Baby
LAST SEEN AT 4152 E 32ND. ST. SHE'S VERY SKITTISH OF PEOPLE. SHE'S MY BABY VERY IMPORTANT PART OF MY FAMILY. PLEASE CONT TACT ME IF YOU KNOW WHERE SHE IS. (515)991-0566 THANK YOU.
Newton
Lost: 2/4/2016
ID: 2305
Name: Bailey
Type: Dog
Color: Brown & white with blue eyes
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Senior
Bailey is a 9 yr old retired momma. Very friendly. Appoximately 15" at shoulder. Believe she was taken from our front yard. Last seen in our yard approximately 10:00 a.m. on February 4, 2016.
Des Moines - East
Lost: 2/4/2016
ID: 2301
Name: Pooh Bear
Type: Dog
Color: Tri Gray
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
Jumped out of the truck to chase a dog at East 15th and Walnut. Wearing id with contact info and address, rabies and City tag
Des Moines - North
Lost: 2/4/2016
ID: 2297
Name: Molli
Type: Dog
Color: White with brown spots
Breed: Australian Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen was at Hull Ave. She is very friendly and loving and is our world and we just want her home. Call 515-447-3322 or 515-650-7031.
Des Moines - East
Lost: 2/2/2016
ID: 2299
Name: Elliott
Type: Cat
Color: grey tiger
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
At 2912 Dean ave fairground area
Des Moines - East
Lost: 2/2/2016
ID: 2298
Name: Elliott
Type: Cat
Color: grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
On back step at 2912 Dean ave fairgrounds in des Moines is
Oskaloosa
Lost: 2/1/2016
ID: 4623
Name: Myer
Type: Dog
Color: White/Red
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Last seen using the bathroom in the yard off highway 92.
Des Moines - East
Lost: 2/1/2016
ID: 2288
Name: fajita
Type: Cat
Color: orange striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
last seen late 1/31/16. he didn't come in when called like usual. he has all his claws, is fat, and a huge lover cat. he may have been fighting with a coon.
Des Moines - West
Lost: 1/31/2016
ID: 2377
Name: Cookie
Type: Dog
Color: Blackish brown
Breed: Poodle Toy
Gender: Female
Fixed: Not Neutered
Age: Adult
Beaverdale area.
Des Moines - West
Lost: 1/31/2016
ID: 2376
Name: Swagger
Type: Dog
Color: White and brown
Breed: Yorkie Poo
Gender: Male
Fixed: Unknown
Age: Adult
Beaverdale area.
Des Moines - West
Lost: 1/31/2016
ID: 2282
Name: Swagger
Type: Dog
Color: White
Breed: Yorkie Poo
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - West
Lost: 1/31/2016
ID: 2281
Name: Cookie
Type: Dog
Color: Blackish brown
Breed: Poodle
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen in the house. She has four puppies who need her so please help me find my dog. We miss and love her.
Des Moines - Central
Lost: 1/31/2016
ID: 2274
Name: Romeo
Type: Dog
Color: Black
Breed: Poodle
Gender: Male
Fixed: Neutered
Age: Adult
Sherman Hill area. MLK and Woodland/Ingrosoll Ave.
Klemme
Lost: 1/30/2016
ID: 2287
Name: Duke
Type: Dog
Color: Brindle (brown with black stripes)
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
There was a green pickup truck loitering around our farm the morning he didn't come home. I am offering a reward - no questions asked. I just need him back.
Des Moines - East
Lost: 1/30/2016
ID: 2273
Name: Ginger
Type: Dog
Color: Gold/Yellow
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Baby
By 14th and Guthrie, very friendly dog. 15 years old
Mason City
Lost: 1/30/2016
ID: 2272
Name: Garbo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
217 6th street