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>='1610928000')) ORDER BY pm1.meta_value DESC, post_date DESC
Spencer
Lost: 7/30/2019
ID: 12113
Name: Cooper
Type: Dog
Color: Chestnut
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Very friendly 3-year old dog. His favorite thing to do is play fetch, literally is always bringing something to you to throw for him. Last seen north of Spencer, Iowa.
Grand Mound
Lost: 7/30/2019
ID: 12027
Name: Max
Type: Dog
Color: Yellow
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
With other dog ash who was found this afternoon. last seen on 225th. very loveable and friendly tends to be very timid around men
Des Moines - North
Lost: 7/30/2019
ID: 12008
Name: Skippy
Type: Cat
Color: Black, grey belly
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Black, long hair, fluffy tail, grey fur on belly
Des Moines - East
Lost: 7/30/2019
ID: 12005
Name: Levi
Type: Dog
Color: Brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Missing from the AE Dairy area. Very good with other Dogs and Cats, not good with younger children.
Ames
Lost: 7/30/2019
ID: 12003
Name: Iro
Type: Cat
Color: White and Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen out of SUV Complex in North Ames
Ames
Lost: 7/29/2019
ID: 12373
Name: Suerte
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Baby
Yellow eyes. Dark pigmentation on iris on left eye. Long canines. 3 white whiskers on right side, 1 on left side. Grayish hair on underside. castrated 10 year old male cat. bushy tail, loves flicking his tail. Name is Suerte really loves softcan food. He is microchipped. Suerte is very loved and missed! He doesn't like being held but appreciated being scratched under chin and behind ear.
Des Moines - West
Lost: 7/29/2019
ID: 12037
Name: Skittles
Type: Cat
Color: Tan multi
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Pleasant Hill
Lost: 7/29/2019
ID: 12032
Name: Buddy
Type: Dog
Color: Golden
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Wilton
Lost: 7/29/2019
ID: 12017
Name: Orion
Type: Cat
Color: White and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen around the rest stop he ran in the bushes near the fence area
Ankeny
Lost: 7/29/2019
ID: 12001
Name: Josie
Type: Cat
Color: White/black/gold. calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
Courtyards of Rock Creek Ankeny
Casey
Lost: 7/29/2019
ID: 11999
Name: Stanford
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He got out late in the afternoon. He is an indoor cat and doesn’t know his way around the neighborhood. Very friendly but he may be scared since he has never done this before.
Des Moines - West
Lost: 7/29/2019
ID: 9684
Name: Kiara
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Reposting this to see if anyone has seen this guy. Has been missing since 09/28/2018. Around Merle Hay and Holcomb. He is chipped. You can call or text me. Or email f.lynn@mchsi.com
North Liberty
Lost: 7/28/2019
ID: 11985
Name: Dahli
Type: Dog
Color: White w/ brown spots
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in west lake area of north liberty. SUPER friendly.
Ankeny
Lost: 7/28/2019
ID: 11983
Name: Jonah
Type: Dog
Color: Tan
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Jonah was found and returned to us. Thank you all for your sincere help with his safe return. THANKS SO MUCH
Des Moines - Central
Lost: 7/28/2019
ID: 11982
Name: Bonnie
Type: Dog
Color: Brown with some black on face and stuff
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on 13th and Laurel kinda by dmacc urban and cheatom park
Bondurant
Lost: 7/27/2019
ID: 12096
Name: Ashes
Type: Cat
Color: Grey brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Last seen in kadin trl bondurant got out when where moving trying shes a lil standoffish and comes off mean but shes has alot a family missing her
Story City
Lost: 7/27/2019
ID: 12031
Name:
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Lost near Doolittle Prairie south of Story City. House cat that escaped.
Story City
Lost: 7/27/2019
ID: 12030
Name:
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
House cat that found an open door. Was not wearing her collar. Lost south of Story City near Doolittle Prairie.
Orange City
Lost: 7/27/2019
ID: 11990
Name: Frank
Type: Dog
Color: Red-brown and white
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
1-2 miles west and north of Orange city.
Des Moines - South
Lost: 7/27/2019
ID: 11988
Name: Rasco
Type: Cat
Color: Black and white
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen at 4200 park ave area
Ames
Lost: 7/27/2019
ID: 11976
Name: Kya
Type: Cat
Color: Brown/Grey
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Kya was last seen roaming our backyard. She always returns especially by meal times. She is typically a friendly non shy cat. She has orange striping on her front and face. She weighs 7.5-8 lbs.
Marion
Lost: 7/27/2019
ID: 11971
Name: Chance
Type: Dog
Color: White with black black ears and a black spot on his back
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Adult
Winslow road Marion
Des Moines - South
Lost: 7/26/2019
ID: 15262
Name: Lucky
Type: Dog
Color: Gray, Black and Tan.
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Adult
My pet was stolen about 1 year and a half ago but I still have hope of finding him . He was around ewing park
Des Moines - Central
Lost: 7/26/2019
ID: 12049
Name: Lucy
Type: Dog
Color: Black & White
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Very friendly but do not chase! She has an underbite and her face is all black.
Ankeny
Lost: 7/26/2019
ID: 12004
Name: Ghostface Killah
Type: Cat
Color: Orange / apricot
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult