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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - Central
Lost: 7/6/2018
ID: 9069
Name: Captain
Type: Dog
Color: Brown/black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Lost German Shepherd male puppy. 7months old. Not yet neutered. Tall and skinny. Long skinny tail. Very loving.
Des Moines - Central
Lost: 7/6/2018
ID: 9068
Name: Captain
Type: Dog
Color: Brown/black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Lost 7month old puppy. Not yet nurtured. Tall and skinny. Very loving
Atlantic
Lost: 7/5/2018
ID: 9135
Name: Chewy
Type: Dog
Color: Reverse Brindle
Breed: Old English Bulldog
Gender: Female
Fixed: Not Neutered
Age: Adult
My dog was taken from my driveway 70222 630th St, Griswold, IA right on highway 71. She is my baby and my kids miss her terribly a
Des Moines - South
Lost: 7/5/2018
ID: 9097
Name: Opal
Type: Cat
Color: Black and white
Breed: Old English Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Escaped out the door when I let my dog out. Usually he wonders off and comes home in the morning. Haven't seen him since.