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>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
Cedar Rapids
Lost: 7/10/2018
ID: 9121
Name: Dubnyk
Type: Cat
Color: Brown spotted tabby
Breed:
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.
Ellsworth
Lost: 7/5/2018
ID: 9066
Name: Lilly
Type: Dog
Color: White and tan
Breed: Old English Bulldog
Gender: Male
Fixed: Unknown
Age: Senior
Wilson ave in Ellsworth
Stanwood
Lost: 7/5/2018
ID: 9061
Name: Erza
Type: Cat
Color: Multi
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Baby
Des Moines - East
Lost: 7/5/2018
ID: 9048
Name: Storm
Type: Dog
Color: Black amd white
Breed: Great Dane
Gender: Unknown
Fixed: Neutered
Age: Young
Corner of capitol and 19th street. I put them outsode to go to the bathroom took a phone call went out 20 min later and they are gone. They are together. He has blue collar and is fixed and chipped too. They are NOT outside dogs so the heat will be to much for them today. My number is 5154948852 they have tags with info on them also. Very hyper but friendly dogs.
Donnellson
Lost: 7/4/2018
ID: 9268
Name: Tal
Type: Cat
Color: Orange and cream, stripes. Has claws.
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
South of Donnellson in Lee county. Possibly and hopefully making his way northwest towards Henry, van buren, or Jefferson county where our farm is near Lockridge.
Collins
Lost: 7/4/2018
ID: 9188
Name: Maggie
Type: Dog
Color: liver
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
july4th. scared of fireworks. Ran off
Fairfield
Lost: 7/4/2018
ID: 9161
Name: Tal
Type: Cat
Color: Orange and cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen following car accident at 255th Street and 27 south of Donnellson, IA