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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Slater
Lost: 11/6/2016
ID: 4321
Name: Marty (Mar-Mar)
Type: Cat
Color: Browns and black
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Is wary of people and hates to be confined.
West Des Moines
Lost: 11/6/2016
ID: 4247
Name:
Type: Bird
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Baby
Marion
Lost: 11/6/2016
ID: 4246
Name: Mimi
Type: Cat
Color: Black and White
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
Very friendly, only has back claws
Des Moines - East
Lost: 11/5/2016
ID: 4389
Name: Toby
Type: Dog
Color: White
Breed: Yorkie Poo
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 11/5/2016
ID: 4242
Name: Piper
Type: Dog
Color: White/tan
Breed: Shar Pei
Gender: Female
Fixed: Neutered
Age: Adult
Se 28th st and scott ave/Mlk . Should be with yellow lab "max"
Des Moines - East
Lost: 11/5/2016
ID: 4241
Name: Max
Type: Dog
Color: Yellow/white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Senior
Se 28th st and scott ave/MLK. Needs meds.
Des Moines - South
Lost: 11/4/2016
ID: 4274
Name: Tom aka: Itchy
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Found him earlier today, he got into a neighbors garage and had been shut in since last Friday night/Saturday morning. Jim was out working in yard and kept hearing a meow and found it coming from the garage. He was pretty dirty and very hungry and thirsty but seems to be OK.
Des Moines - South
Lost: 11/4/2016
ID: 4272
Name: Tom aka: Itchy
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Neighbors had party night he went missing, not sure if he was picked up, got into the back of someones truck or was scared off. He avoids people he is not familiar with. Is not declawed. Comes to you if you clap. Reward
Des Moines - Central
Lost: 11/4/2016
ID: 4266
Name: Lottie
Type: Cat
Color: Calico with White V on Chest
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
2700 block of 61st street, in between New York and Sheridan. Near DSM First on Merle Hay. Lottie is declawed in the front and has a white tip on his tail.
Waukee
Lost: 11/3/2016
ID: 4252
Name: Stryker
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, indoor/outdoor cat, up to date on vaccines. Also, comes to Kiki. Lost around Corene Avenue in Waukee. Usually comes home every morning after venturing out. Hasn't come home since 11/3/16.
Des Moines - South
Lost: 11/3/2016
ID: 4245
Name: Boots (Boo)
Type: Cat
Color: Grey and White stripe
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
Snuck out window. All white feet. Recently fixed. Missing back left claw. Paying a reward for return!
Des Moines - South
Lost: 11/3/2016
ID: 4244
Name: Boots. (Boo)
Type: Cat
Color: Grey and White stripe
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
Has all white feet. Very loud howler. Extremely friendly. Recently fixed missing one claw back foot recent.
Bondurant
Lost: 11/3/2016
ID: 4235
Name: Mitzy
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Black with white paws, belly, and whiskers
Des Moines - South
Lost: 11/3/2016
ID: 4226
Name: Simba
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
By townhomes by earl may on south side
Des Moines - South
Lost: 11/2/2016
ID: 4217
Name: Daisy
Type: Dog
Color: Black,brown and white
Breed: Doberman Pinscher
Gender: Unknown
Fixed: Not Neutered
Age: Young
Backyard, she is a miniature Doberman Pinscher, greatly missed please contact with any information
Waukee
Lost: 11/1/2016
ID: 4232
Name: Bobcat
Type: Cat
Color: Black with white spot on chest
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Young
Bobcat has green eyes; one of his eyes looks a little blurry compared to the other. You can see the difference when you look at his face. He is VERY friendly. He was last seen at the Springs apartments in Waukee (behind the Hyvee on Hickman Road).
Waterloo
Lost: 11/1/2016
ID: 4215
Name: Chance an chance
Type: Dog
Color: Both tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Riehl still Waterloo Ia I miss him alot an I just want him then to come home now one had a tagtag on his collar with address an the number is wrong 3194043744 an he he's a scar above his eye
Ankeny
Lost: 11/1/2016
ID: 4203
Name: Frankie
Type: Dog
Color: Black and White
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Clover Ridge Dr, large scar on right leg from recent surgery
Ankeny
Lost: 10/31/2016
ID: 4204
Name: Maggie
Type: Dog
Color: Red
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Adult
About 8:00pm tied out in yard
Urbandale
Lost: 10/31/2016
ID: 4201
Name: Oscar
Type: Cat
Color: Brown Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He has white paws and he also has some white under his neck, the rest of him is brown. He is very friendly and has a loud unique meow.
Johnston
Lost: 10/30/2016
ID: 4268
Name: Tyga
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
it was beggers night in northwood in Johnston, my cat got out when the first set of kids came to the door. he usually goes out but comes back when i call for him and doesnt usually stay out longer than a day.
Ames
Lost: 10/29/2016
ID: 5087
Name: Rummy
Type: Dog
Color: (Liver) brown and white
Breed: Dalmatian
Gender: Female
Fixed: Unknown
Age: Young
Have been no sightings since she went missing. She loves everyone. Her birthday is coming up soon and I can't bare to not have my baby back!
Runnells
Lost: 10/29/2016
ID: 4186
Name: Max
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
He is probably with our other dog minnie she is a white boxer
Runnells
Lost: 10/29/2016
ID: 4185
Name: Minnie
Type: Dog
Color: White
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Baby
She is probably with our dog max he is black and a lab mix
Des Moines - Central
Lost: 10/28/2016
ID: 4182
Name: Callie
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
Lost last night Special needs cat Needs medication on a daily basis for seizures. Never been outdoors until now