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
Ankeny
Lost: 7/13/2018
ID: 5311
Name: Oliver
Type: Cat
Color: Grey/White
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
The kids said that he was around this weekend. We were gone this weekend and we got home on Monday and we haven't seen him since. We live in the south west part of Ankeny south of Oralabor on NW 16th St.
Clinton
Lost: 7/12/2018
ID: 10411
Name: Elsa
Type: Dog
Color: White
Breed: Tuxedo
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Supposedly given to a lady outside of the humane society.
Des Moines - East
Lost: 7/12/2018
ID: 10031
Name: Jose
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on 43rd ct and Hubble Des Moines he was wearing a color but he likes to take it off he is not fixed and has a big Freckle on his lip and a scar on his ear we think he might have been stolen and dropped off in another neighborhood please help us bring him home
Ankeny
Lost: 7/12/2018
ID: 9168
Name: Blackie
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Lost in SW 24th Court - Ankeny Missing with her sister Rosie who is black and white. :(
Ankeny
Lost: 7/12/2018
ID: 9167
Name: Rosie
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near SW 24th Court Ankeny. Was with her sister Blackie. Also missing. :(
Schleswig
Lost: 7/12/2018
ID: 9154
Name: Charlie
Type: Dog
Color: golden red
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Young
Newton
Lost: 7/12/2018
ID: 9141
Name: Nyah
Type: Dog
Color:
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
She slipped out of her collar and took off late last night. She was last seen in Newton, IA on S 3rd Ave.
West Des Moines
Lost: 7/11/2018
ID: 9163
Name: Juliet
Type: Cat
Color: Mostly White tips of brown
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Baby
Off Stonebridge Drive West Des Moines By Meadow Chase Apartments. Blue Eyes. Beautiful. Will bite and scratch still kind of wild. Catch with a towel blanket etc.
Waukee
Lost: 7/11/2018
ID: 9124
Name: Venus
Type: Cat
Color: Gray w/ black stripes
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Very curious, and gentle. Her collar is purple and has her name (Venus) on it. She has long hair on her face that makes her look bigger.
Des Moines - West
Lost: 7/11/2018
ID: 9119
Name: Scarlet
Type: Cat
Color: Brown and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Not Neutered
Age: Young
Normandy Terrance Apartments
Johnston
Lost: 7/10/2018
ID: 9133
Name: IVY
Type: Dog
Color: Tan-brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Seen yesterday at 86th and NW 62nd street in Johnston
Ankeny
Lost: 7/10/2018
ID: 9130
Name: Emerald
Type: Cat
Color: Black & White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
District Brownstones 1606 SW Westview Drive. She got out of our new townhouse while we were moving in. She is de-clawed on the front only.
Cedar Rapids
Lost: 7/10/2018
ID: 9121
Name: Dubnyk
Type: Cat
Color: Brown spotted tabby
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Baby
Contact Dana at 319-389-0587. Large cash reward.
Cedar Rapids
Lost: 7/10/2018
ID: 9120
Name: Dubnyk
Type: Cat
Color: Brown spotted tabby
Breed: American Curl
Gender: Male
Fixed: Neutered
Age: Baby
Contact Dana at 319-389-0587. Large cash reward.
Norwalk
Lost: 7/8/2018
ID: 9125
Name: Sophie
Type: Dog
Color: Tri
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Senior
Last seen near Warren and Grimes on west side of Hwy 35.
Ankeny
Lost: 7/8/2018
ID: 9117
Name: Nugget originally was ollie
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen early morning yesterday he has 6 toes on his two front paws he is very shy and dont usually come up to people really skiddish
Ankeny
Lost: 7/8/2018
ID: 9110
Name: Arya
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
She ran out when we let the dog out and hasn't yet come back. It's been 24 hours, and she's never been gone this long.
Des Moines - Central
Lost: 7/7/2018
ID: 9114
Name: Sassy
Type: Cat
Color: Gray/brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Some where in the woods by broadlawns medical center
Winterset
Lost: 7/7/2018
ID: 9111
Name: Peanut Butter
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Between Holliwell valley court and Norwood Ave
Ankeny
Lost: 7/7/2018
ID: 9085
Name: Tobey
Type: Dog
Color: White with little tan
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Off SE Trilein Drive he got out of backyard. Recently shaved ears and tail long.
Cedar Rapids
Lost: 7/6/2018
ID: 9144
Name: Riley Mae
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Went missing from 11th ave Sw by Kingston Stadium in Cedar Rapids. Riley was being watched by a friend, her home is in Montplier, Iowa.
Des Moines - East
Lost: 7/6/2018
ID: 9098
Name: Diamond
Type: Dog
Color: White
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 7/6/2018
ID: 9096
Name: Diamond
Type: Dog
Color: White
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Young
Waterloo
Lost: 7/6/2018
ID: 9088
Name: Frea
Type: Dog
Color: Black/tan
Breed: Pinscher-Miniature
Gender: Female
Fixed: Neutered
Age: Baby
On 716 W 8th street
Ankeny
Lost: 7/6/2018
ID: 9083
Name: Dexter
Type: Cat
Color: Gray and black
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult