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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 9/5/2018
ID: 9526
Name: Smudge (previously Marnie)
Type: Cat
Color: Tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Microchipped! 4th and Grand near Grand Ave Pet Hospital, Dairy Queen, Taco Johns, across from Fareway. 7 pounds. Very shy but very affectionate when she feels safe. Spayed in July. Tummy still shows signs of shaving. Microchip 985 113 O02 097 515. Call 515-991-9371!
Ames
Lost: 9/5/2018
ID: 9525
Name: Tank
Type: Dog
Color: Black & tan
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on S.16th between Duff & University.
Bernard
Lost: 9/4/2018
ID: 9584
Name: Maya
Type: Dog
Color: White, Gray/Black
Breed: English Setter
Gender: Female
Fixed: Neutered
Age: Young
Maya was taken from her kennel. Our other dog was left behind with the door shut. We just moved to Bernard and she is not totally comfortable with the surrounding area. She is a trained hunting dog and does know her name but only listens to her owner. Friendly to people but is independent. Territorial with other smaller dogs/animals/cats. FOOD MOTIVATED. She's a purebred english setter 2 years old and was recently (within one month) fixed so she's sensitive around the stomach.
Fort Dodge
Lost: 9/4/2018
ID: 9524
Name: Blake
Type: Dog
Color: Black with some white on his chest
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
On 13th street North FD
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