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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Truro
Lost: 7/4/2018
ID: 9084
Name: Katie
Type: Dog
Color: Black
Breed: Basset Hound
Gender: Unknown
Fixed: Neutered
Age: Adult
She has a chip but for Tampa Florida area. She now lives in Truro, ia
Des Moines - South
Lost: 7/4/2018
ID: 9070
Name: Myla
Type: Dog
Color: Black & Brown
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Applicable
Age: Young
Myla was last seen south of Des Moines around 50320 area. Visiting family around Easter lake- Avon Cemetary area. We think she was frightened by fireworks and ran off. She is not familiar with that area.
Pleasant Hill
Lost: 7/4/2018
ID: 9067
Name: Ollie
Type: Cat
Color: brown and gray striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
St. Marys
Lost: 7/4/2018
ID: 9062
Name: Ruby
Type: Dog
Color: Reddish/golden
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen east of St.Marys, got scared by the fireworks and took off running west towards St.Marys.
Ankeny
Lost: 7/4/2018
ID: 9060
Name:
Type: Cat
Color: Black, white patch
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Young
2 black cats
Cambridge
Lost: 7/4/2018
ID: 9040
Name:
Type: Cat
Color: Dark brown withe a mix of tan
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Last seen in the White Oak Neighborhood
Des Moines - North
Lost: 7/4/2018
ID: 9038
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
“LOST “ dog . Part German Sheperd that answers to the name of CHIEF. He busy through a window because of all the fireworks and is bleeding . Lost in the 1600 block of Hull. He is a friendly dog. If found, please message me ASAP! Thank you 515 669 7100
Des Moines - North
Lost: 7/4/2018
ID: 9037
Name: Cheif
Type: Dog
Color: Brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
1600 block hull ave. “LOST “ dog . Part German Sheperd that answers to the name of CHIEF. He busy through a window because of all the fireworks and is bleeding . Lost in the 1600 block of Hull. He is a friendly dog.