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>='1579219200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - South
Lost: 7/6/2018
ID: 9078
Name: Gordo
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
On south side he is friendly won’t bite please call 5154414375 with info
Ankeny
Lost: 7/6/2018
ID: 9072
Name: King
Type: Cat
Color:
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
1010 SE Lowell Drive, Ankeny. He is microchipped. No collar is on.