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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Pleasant Hill
Lost: 6/12/2017
ID: 5870
Name: Kenneth
Type: Cat
Color: Brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Osceola
Lost: 6/12/2017
ID: 5865
Name:
Type: Dog
Color: Dapple white, black and tan
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Adult
Very friendly
Grimes
Lost: 6/12/2017
ID: 5858
Name: Chester
Type: Cat
Color: taffy/orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
around 9th ct/Shawver Dr,Grimes,IA,very friendly has a collar and an if found tag ,with his address .All 4 declawed.Very loud meow.
Des Moines - East
Lost: 6/11/2017
ID: 5871
Name: Gizmo aka baby girl
Type: Cat
Color: Black with white spot on chest and belly
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Very loving will come up to you and rub on you
Clive
Lost: 6/11/2017
ID: 5864
Name: Unknown
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
80th Ct and Harbach
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