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>='1571184000')) ORDER BY pm1.meta_value DESC, post_date DESC
Iowa City
Lost: 6/12/2019
ID: 11586
Name: Kris
Type: Dog
Color: gold
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
silver lane
Des Moines - South
Lost: 6/12/2019
ID: 11580
Name: Coco
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
He ran away with Chispa our other dog.
Des Moines - South
Lost: 6/12/2019
ID: 11579
Name: Chispa
Type: Dog
Color: White with black spots
Breed: Akita
Gender: Male
Fixed: Not Neutered
Age: Young
He ran away with our other dog a chocolate lab. The lab responds to "Coco".
Des Moines - South
Lost: 6/11/2019
ID: 11578
Name: Ozzy
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
He is scared of storms. I let them out to pee (him and two other dogs) for just a minute while I used the restroom and went to let them in and he wasn’t there. I searched the neighborhood and called out for him but couldn’t find him last night.
Ankeny
Lost: 6/11/2019
ID: 11575
Name: Tank
Type: Cat
Color: Black/White Tuxedo pattern
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen evening 6/10/19, Ankeny, Delaware and Fountainview Drive. Loves catnip and treats.
Des Moines - North
Lost: 6/11/2019
ID: 11571
Name: Wally
Type: Dog
Color: White
Breed: Maltipoo
Gender: Male
Fixed: Neutered
Age: Adult
6th and aurora ave. At highland Park Christian Church
Des Moines - East
Lost: 6/10/2019
ID: 11569
Name: SHADOW
Type: Dog
Color: Black /some white
Breed: Maltipoo
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 6/9/2019
ID: 11617
Name: Lilly
Type: Small or Furry
Color: gray/white
Breed: Hedgehog
Gender: Female
Fixed: Unknown
Age: Senior
Lilly was lost outside our house while we were cleaning her cage.
Des Moines - Central
Lost: 6/9/2019
ID: 11616
Name: Lilly
Type: Small or Furry
Color: gray/white
Breed: Hedgehog
Gender: Female
Fixed: Unknown
Age: Senior
Lilly was lost outside our house while we were cleaning her cage.
Des Moines - East
Lost: 6/9/2019
ID: 11560
Name: Eyes
Type: Cat
Color: Tabby (Orange and white)
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
I last saw Eyes at home. He was raised on an acreage so I allow him to go outside when he chooses. He always comes home in the evening or in the morning. I have not seen him since the afternoon of Sunday, June 9. He's a very quiet cat and even his meow sounds like a squeak. He does know his name but may be skittish around those he does not know.
Des Moines - East
Lost: 6/9/2019
ID: 11559
Name: Sunny
Type: Cat
Color: Orange
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
My grandfathers cat just came to live with us after he passed last month and she must have gotten out last night so if you find her please let me know as she was my grandfathers best friend and I don’t want to loose her
Woodward
Lost: 6/8/2019
ID: 11583
Name: Athena
Type: Dog
Color: Gold or tan
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen near Woodward Iowa,very friendly,was in the car during auto accident rollover.She may be injured.Very noticable gray,green eyes.
Ankeny
Lost: 6/8/2019
ID: 11556
Name: Kipper
Type: Cat
Color: White with Orange ears and orange shaded tail
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Last seen on NE Windsor Drive in Windsor Village. Friendly, front declawed, blue eyes. Current on shots. Currently losing fur on sides due to medication allergy.
Des Moines - North
Lost: 6/7/2019
ID: 11663
Name: Violet
Type: Cat
Color: Brownish grey splotchy tiger
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
She left home and did not return with the rain. Yes, she is a roamer. She thinks she is a wild animal. >^..^< Tell her to to get back before the snow flies. This picture was taken in the winter. In the summer she appears a bit lighter color.
Algona
Lost: 6/7/2019
ID: 11564
Name: Bear
Type: Dog
Color: Reddish brown with gold eyes
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
He is very special to our family my son misses him terriblely
Algona
Lost: 6/7/2019
ID: 11563
Name: Bear
Type: Dog
Color: Reddish brown with gold eyes
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
East of Algona. He is very friendly
Des Moines - West
Lost: 6/7/2019
ID: 11552
Name: Luna
Type: Cat
Color: Multi
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Luna went missing on June 7, 2019 in Des Moines, IA 50311. Last seen near Dagle Dr (1 block south of University) & 63rd St in Des Moines. She's a declawed (front paws) indoor cat that doesn't go outside. She's sweet but skittish and is likely to hide from strangers.  Please contact immediately if found, she is loved and missed.  A reward is being offered for her safe return. 
Des Moines - Central
Lost: 6/7/2019
ID: 11546
Name: Angel
Type: Dog
Color: Black and white
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Last seen by wrench n go she loves kids very timid around adults especially males vaccinated and registered for the city
Altoona
Lost: 6/7/2019
ID: 11545
Name: Ham (hamlet, hammy)
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Very social and lovable kitty. 4 years old, grey, and big. He has one white spot on his chest. Last seen yesterday afternoon in our backyard when the kids let him out and no one grabbed him to bring him in. If seen, he will be easily approachable and does not mind getting picked up.
Winterset
Lost: 6/6/2019
ID: 11620
Name: Ada
Type: Dog
Color: Liver color with white
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
Last seen in rural area of Macksburg/Winterset Iowa area - she's very friendly but quick. Please please look at this picture closely and call me with any information at any time. Please bring her home! Call Mike at 515 669-3556 or Filomena at 515 669-6968
Des Moines - West
Lost: 6/6/2019
ID: 11608
Name: Tutu
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
At 1805 Merle Hay Rd in aRe A Moines heading for the backyard. She has yellow eyes. She has white hairs in her ears. I think she has a couple of White hairs on her belly. Otherwise she is pure black. She has a short hair tail.
Earlham
Lost: 6/6/2019
ID: 11584
Name: Hercules
Type: Dog
Color: Tan and white
Breed: Mountain Dog
Gender: Male
Fixed: Unknown
Age: Young
Rural earlham
Altoona
Lost: 6/6/2019
ID: 11549
Name: Tinkerbelle or Belle
Type: Cat
Color: Gray & White
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
Neighbor kids were seen shooting with pellet gun in Altoona around 9th and 10th Streets SE, and haven’t seen her since. She is very sweet and lovey.
Ankeny
Lost: 6/6/2019
ID: 11537
Name: Kiki
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Unknown
Fixed: Not Neutered
Age: Young
Last seen near Dmacc in ankeny at 11:30 pm, she’s 5 months old and very shy
Macksburg
Lost: 6/5/2019
ID: 11619
Name: Ada
Type: Dog
Color: Liver color with white
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
Last seen in rural area of Macksburg/Winterset Iowa area - she's very friendly but quick. Please please look at this picture closely and call me with any information at any time. Please bring her home! Call Mike at 515 669-3556 or Filomena at 515 669-6968