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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Riceville
Lost: 9/4/2018
ID: 9522
Name: Gunner
Type: Dog
Color: Liver/white
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen by Riceville Iowa, very friendly boy but will run if chased. He did not have his collar on
Des Moines - South
Lost: 9/4/2018
ID: 9520
Name:
Type: Dog
Color: White with black face and ears, black spot on top of tale
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Adult
in her fenced and electric fenced yard on the Southwest side
Pleasant Hill
Lost: 9/4/2018
ID: 9517
Name: Coachella
Type: Dog
Color: Brown
Breed: Terrier
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen on NE 56th street in pleasant hill, IA. Answers to Coachella or Coachie. Brown with streaks of black and white. No collar. Pointy ears
Millersburg
Lost: 9/3/2018
ID: 9509
Name: Frankie
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Adult
Frankie got out of his harness at Lake Iowa, Iowa County. He was last seen by the boat docking area. Owners are from New York and were just stopping for a rest. Worried sick, they need to find before leaving.
Des Moines - South
Lost: 9/2/2018
ID: 10052
Name: Ranger
Type: Cat
Color: gray, brown with black
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Likes to wander neighborhood. Friendly. Begs for food at neighbors houses even though he has a good home.
Grimes
Lost: 9/2/2018
ID: 9515
Name: Stark
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
We have been unable to find our 4 month old orange kitten named Stark. We live just East of James Street near 11th street. He was spotted on Sunday, September 2nd near Beaverbrooke Park in Grimes. He is about 4 months old.
Altoona
Lost: 9/2/2018
ID: 9514
Name: Dobby
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Last seen at 1002 9th Ave PL SE in Altoona. He is very small and friendly. We just moved into a new house and he got out under a hole in the gate that we didn't notice. Please call 408-499-3126 if you have seen him and help us bring him home!
Altoona
Lost: 9/2/2018
ID: 9511
Name: Dobby
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 1002 9th Ave PL SE in Altoona. He is very small and friendly. We just moved into a new house and he got out under a hole in the gate that we didn't notice. Please help us bring him home!
Des Moines - Central
Lost: 9/2/2018
ID: 9505
Name: Buddy
Type: Dog
Color:
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Senior
Won’t let me upload photo. Long white hair, little brown on tail. Cannot see or hear very well. Name is buddy. Call 7123635598 if you think saw my dog.
Avoca
Lost: 9/2/2018
ID: 9502
Name: Simon
Type: Cat
Color: Brown and White Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen at the Flying J Travel center crawling out of the window of a red Prius.
West Des Moines
Lost: 9/1/2018
ID: 9958
Name: Nina
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
West does Moises back yard
Sheldahl
Lost: 9/1/2018
ID: 9622
Name: Band-Aid
Type: Reptile
Color: Gold and black
Breed: Turtle
Gender: Male
Fixed: Not Applicable
Age: Adult
He is a tortoise and a very beloved family pet. Escaped his outdoor enclosure. His family misses him!!!
Des Moines - North
Lost: 9/1/2018
ID: 9558
Name: Bagheera
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen just south of the intersection of Madison and North Union on the culdesac of Hoffman Avenue on the morning of Saturday September 1st. No collar. Greenish eyes.
Des Moines - North
Lost: 9/1/2018
ID: 9507
Name: Urlacker
Type: Dog
Color: Brown & White
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Adult
Lost off Lower Beaver and Douglas area. Please call 515-988-3731
Altoona
Lost: 9/1/2018
ID: 9503
Name: Herky
Type: Dog
Color: White and Black
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Around 9:30 by Pheniox Park
Des Moines - Central
Lost: 9/1/2018
ID: 9496
Name:
Type: Dog
Color:
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Adult
Owner found him!!!
Milo
Lost: 8/31/2018
ID: 9530
Name: Sargeant
Type: Cat
Color: Black with white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Baby
Liberty center area. Country semi-feral but shy and sweet.
Des Moines - North
Lost: 8/31/2018
ID: 9489
Name: Sinatra
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Young
8AM this morning. Farm kitten, about 3 months old, beautiful blue eyes, VERY friendly.
Des Moines - East
Lost: 8/30/2018
ID: 9493
Name: Fryda
Type: Dog
Color: Beige
Breed: Pug
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - Central
Lost: 8/30/2018
ID: 9487
Name: Smokey
Type: Cat
Color: Grey
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Baby
At home on university 23rd St.
Ankeny
Lost: 8/30/2018
ID: 9482
Name: Ares(Pookie)
Type: Small or Furry
Color: Sable
Breed: Ferret
Gender: Female
Fixed: Neutered
Age: Adult
Ne 6th st ankeny
Des Moines - South
Lost: 8/29/2018
ID: 9485
Name: Mimi
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen in our home on E Bell Ave and King Ave in Des Moines. We were moving and the cats got out on accident and we have found all but Mimi.. she’s really timid but usually comes if you call her and have patience. She might be in the wooded area behind our house, or across the street. She’s not a fan of car noises so I don’t think she’d be by a street..
Des Moines - East
Lost: 8/28/2018
ID: 9521
Name: Kiki/ kiki marie
Type: Cat
Color: Tan white grey stripped
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Kiki or kiki marie was last seen around her house. She enjoys being outside a few times during the day but always loves to come in and end every day with her owners. So this is unusual of her. She is a very friendly cat who is deeply missed by her mom dad and sister and brother. She was last seen on her street Jefferson st. Right off 33rd. If seen or found please contact immediatley. Thank you!
Des Moines - South
Lost: 8/28/2018
ID: 9486
Name: Coal
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is not declawed. Has scars on nose and missing patch of hair near his eyes.
Des Moines - East
Lost: 8/28/2018
ID: 9480
Name: Taz
Type: Cat
Color: Brown, black, and white
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in Primary Healthcare parking lot off of E. 29th street around midnight.