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
Waukee
Lost: 6/30/2017
ID: 6146
Name: Bailey
Type: Dog
Color: Black
Breed: Mix
Gender: Female
Fixed: Not Applicable
Age: Baby
She ran out of our backyard due to fireworks nearby. We live on SE Florence Dr. (Behind South Middle School) in Waukee.
Des Moines - Central
Lost: 6/30/2017
ID: 6097
Name: Foulan
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
1305 3rd street
West Des Moines
Lost: 6/30/2017
ID: 6083
Name: Adamas
Type: Cat
Color: Striped grey, tan, black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He's very friendly and sweet.
Norway
Lost: 6/30/2017
ID: 6042
Name: Hairlip and Waddles
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Carlisle
Lost: 6/30/2017
ID:
Name: Macie
Type: Dog
Color: White
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Monmouth
Lost: 6/30/2017
ID: 6026
Name: Lucy
Type: Dog
Color: Dark Brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Senior
last seen at 5pm we were gone 2 hours came home and neighbors were shooting off fireworks and she was gone from fenced in yard...west of Maquoketa Iowa (Canton)
Des Moines - South
Lost: 6/29/2017
ID: 6025
Name: Gatsby
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is very skittish and scared of strangers, I am sure it would be hard to catch him. I just am trying everything I can.
Des Moines - West
Lost: 6/29/2017
ID: 6011
Name:
Type: Dog
Color: White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Found on corner of Shawnee and Cornell. Very friendly and has a playmate with my pup until relocated to his home.
Grimes
Lost: 6/28/2017
ID: 6032
Name: Gorgeous
Type: Cat
Color: White, brown, and black
Breed: Calico
Gender: Male
Fixed: Not Applicable
Age: Adult
I believe she may have gotten out the house, while we were taking out trash. She has never been out of the house, she only eats dry name brand cat food and she is declawed. She has a collar with my name and phone number on it.
Ankeny
Lost: 6/28/2017
ID: 6016
Name: Hermes
Type: Cat
Color: Black/White/Brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is very skiddish and will not come to you easily.
Des Moines - Central
Lost: 6/28/2017
ID: 6007
Name: Minnie
Type: Dog
Color: White and tan,some black
Breed: Fox Terrier
Gender: Female
Fixed: Not Applicable
Age: Adult
Scared of storms
Des Moines - South
Lost: 6/28/2017
ID: 6001
Name: Panda
Type: Dog
Color: Blondish
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on the 400 block of scandia ave near the post office.
West Des Moines
Lost: 6/27/2017
ID: 6116
Name: Kool
Type: Cat
Color: Yellow
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 6/27/2017
ID: 6115
Name:
Type: Cat
Color: Yellow
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 6/27/2017
ID: 6029
Name: Sugar
Type: Dog
Color: White
Breed: American Shorthair
Gender: Unknown
Fixed: Not Neutered
Age: Senior
Sugar is going blind she has a wound on her left side by her hip. Shes a very sweet dog
Des Moines - South
Lost: 6/27/2017
ID: 6028
Name: Sugar
Type: Dog
Color: White
Breed: Maltese
Gender: Unknown
Fixed: Not Neutered
Age: Senior
Sugar is going blind she has a wound on her left side by her hip. Shes a very sweet dog
Des Moines - South
Lost: 6/26/2017
ID: 6137
Name: SYLVEE
Type: Cat
Color: Black/white
Breed: Tuxedo
Gender: Female
Fixed: Not Applicable
Age: Adult
She is fixed, a little shy and doesn't like to be picked up. Loves being pet though.
Nashua
Lost: 6/26/2017
ID: 6015
Name: Big Sal
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly. Lost near Akron Way Road Nashua Iowa Please call with any sign of him. He is very important to someone. Thank you
Des Moines - North
Lost: 6/26/2017
ID: 5998
Name: Onyx
Type: Cat
Color: Mostly black. White chest and paws. Random white hair sprinkled throughout.
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
He's never been outside. 5th and Madison.
Iowa City
Lost: 6/26/2017
ID: 5995
Name: Sunday
Type: Cat
Color: Black w/orange and white
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Near Twain in Iowa City. Never been outside. We'll be scared and hard to catch. Call if you see her. 319-541-7392
Ankeny
Lost: 6/26/2017
ID: 5988
Name: Gary
Type: Dog
Color: Brown black white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Fletcher estates ne ankeny
Des Moines - South
Lost: 6/25/2017
ID: 6908
Name: Linc
Type: Cat
Color: Tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Less than a year old. White begins under his chin. Pink paws with a few black markings on bottom feet. Last seen on the 300 block of Hartford Ave.
Mitchellville
Lost: 6/25/2017
ID: 6136
Name: MoMA ki
Type: Cat
Color: Black and White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Thomas Mitchell Park, kids scared her , I miss her very much , I was not allowed to catch her where she was hiding
Mitchellville
Lost: 6/25/2017
ID: 6135
Name: MoMA ki
Type: Cat
Color: Black and White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
She is at Thomas Mitchell Park and was hiding at camp host , they did not allow me to catch her , said they would, then said she has moved on. But I think she is still hiding under their very low deck and happy but she has never had fleas or ticks and was not treated , she gets scared around kids
Redfield
Lost: 6/25/2017
ID: 6047
Name: Cheech
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult