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>='1560988800')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Lost: 6/11/2017
ID: 5862
Name:
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Lost: 6/11/2017
ID: 5857
Name: William
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
William was last seen in our backyard. He's a very friendly, affectionate cat who can be chatty. He's not aggressive at all but doesn't like to be picked up.
Clive
Lost: 6/11/2017
ID: 5849
Name: SHADOW
Type: Cat
Color: GREY
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
VERY SHY. LAST SEEN AT WOODLANDS CREEK SENIOR RESIDENCE AT 12655 WOODLANDS PKW, CLIVE, IA
Clive
Lost: 6/11/2017
ID: 5843
Name: SHADOW
Type: Cat
Color: GREY
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
WOODLANDS CREEK PKWY AREA WOODLANDS SENIOR RESIDENCE
Clive
Lost: 6/11/2017
ID: 5840
Name: Shadow
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Huxley
Lost: 6/11/2017
ID: 5839
Name: Maverick
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Huxley
Lost: 6/11/2017
ID: 5838
Name: Maverick
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Des Moines - North
Lost: 6/11/2017
ID: 5834
Name: Charlie
Type: Dog
Color: blackish brown
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Baby
5112 Hickman Rd, 50315, very, very very friend...
Des Moines - South
Lost: 6/10/2017
ID: 5851
Name: Poe
Type: Cat
Color: Black with a white patch on cheat and manhood
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Ankeny
Lost: 6/10/2017
ID: 5832
Name: Melody
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Clip in left ear, yellow eyes,not declawed
Johnston
Lost: 6/10/2017
ID: 5831
Name: Rex
Type: Dog
Color: White with brown sports
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Senior
Lost in green meadows west, Johnston Iowa
Des Moines - Central
Lost: 6/10/2017
ID: 5824
Name: ?
Type: Cat
Color: White long hair
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Found in the Polk Blvd neighborhood of Des Moines. This kitty has been ok our stoop the past few days. Not afraid of humans, pretty chatty, when I picked the cat up seemed pretty skinny under fluffy fur. We gave food and water. If this is your cat please contact!
Des Moines - East
Lost: 6/9/2017
ID: 5933
Name: Mr love
Type: Cat
Color: stripped
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
skiddish but loveable 106 E. 29th Ct. Des Moines Iowa 5157219411
Cedar Rapids
Lost: 6/9/2017
ID: 5825
Name: Chole
Type: Dog
Color: Black white
Breed: Shih Tzu
Gender: Unknown
Fixed: Not Neutered
Age: Baby
She was in our backyard at around 11am I went to check at 11:30am and she wasn't there. There was no way for her to gt out there so we feel that someone TOOK her. WE JUST WANT HER HOME :(
Dubuque
Lost: 6/8/2017
ID: 5836
Name: Coconut
Type: Cat
Color: Tortoiseshell (mostly black with brown mix)
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Last seen on Jessica Lane, off Old Dubuque Rd in Dubuque County south of Dubuque. She is a very curious, friendly, petite young cat.
West Des Moines
Lost: 6/8/2017
ID: 5812
Name: Casper
Type: Cat
Color: White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Accidentally let outside from Hamlet Apartments
Des Moines - North
Lost: 6/8/2017
ID: 5809
Name: King
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Baby
Over by Walgreens in Euclid and Cambridge
Des Moines - Central
Lost: 6/7/2017
ID: 6190
Name: Watermelon
Type: Cat
Color: Gray Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She's part of a barn and she's lost. Anything could have happened in the woods but we're hoping someone just thought she was lost and picked her up. Extremely friendly.
Altoona
Lost: 6/7/2017
ID: 5829
Name: Chopper Houdini
Type: Dog
Color: Brindle
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Wilton
Lost: 6/7/2017
ID: 5797
Name: Paulie
Type: Dog
Color: white
Breed: French Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
around 3:30 2146 Spicer Ave $500 reward
West Des Moines
Lost: 6/7/2017
ID: 3447
Name: Dezzie
Type: Dog
Color: Tan
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Dezzie has been missing since 7/17/16 Sunday morning early hours 3-5 AM. West of Valley Junction - Grand & Railroad. Pit bull mix, female, 2 years, light gold/yellow short-hair. Friendly, sweet and thinks she's a husky (like her house-dog-pal Gage) and mimics-howls at sirens. Gage and Dezzie got out our back fence and Gage came back alone. We have her collar and tags, so she is without any ID and does not have a chip. We really miss her. If you have any information, please let us know.
Altoona
Lost: 6/6/2017
ID: 5796
Name: Bear
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
Bear is 10 months old. Last seen in altoona behind medicap
Des Moines - East
Lost: 6/5/2017
ID: 5821
Name: Suzy Snowflake
Type: Cat
Color: Off white with dark ears
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Young
Photo shows cat younger, she's about a year older now
West Des Moines
Lost: 6/5/2017
ID: 5792
Name: Ronnie
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
805 28th street
Des Moines - East
Lost: 6/5/2017
ID: 5780
Name: Annie
Type: Dog
Color: Black
Breed: Cockapoo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on lay st behind hyvee. She's a runner. Unless she wants to come to you if you run at her she will run. She loves car rides and food. Easiest way to get her to come. She's loving and loves children