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
Winterset
Lost: 12/10/2016
ID: 4533
Name: Bella Rose
Type: Dog
Color: Brown
Breed: Golden Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Last seen in highway 92, East of Winterset near Patterson, Iowa. Will give reward if found. 515.205.6942
Altoona
Lost: 12/9/2016
ID: 4514
Name: Charlie
Type: Dog
Color: Brown
Breed: Dachshund
Gender: Female
Fixed: Neutered
Age: Senior
Des Moines - West
Lost: 12/9/2016
ID: 4513
Name: Spur
Type: Dog
Color: Black/white
Breed: Blue Heeler
Gender: Unknown
Fixed: Not Applicable
Age: Young
Post office in west Des Moines
Ankeny
Lost: 12/9/2016
ID: 4500
Name: Rosie
Type: Dog
Color: Balck with white
Breed: Mix
Gender: Female
Fixed: Not Applicable
Age: Young
Village view area SE Ankeny off of Delaware
Ankeny
Lost: 12/9/2016
ID: 4499
Name: Rosie
Type: Dog
Color: Balck with white
Breed: Mix
Gender: Female
Fixed: Not Applicable
Age: Young
Village view area SE Ankeny off of Delaware
Des Moines - North
Lost: 12/8/2016
ID: 4503
Name: Raggs
Type: Dog
Color: White
Breed: Terrier Toy Manchester
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen at N.E. 27th and Broadway Ave. Tags was wearing a black animal sweater that matched his collar. It had white skulls and crossbones on it too. Raggs is VERY sweet and would NOT hurt anyone or anything. If you've seen an animal that resembles this description or have any information, please call Carrie at (515) 351-7113. Thank you
Des Moines - West
Lost: 12/8/2016
ID: 4498
Name: Gilbert
Type: Dog
Color: Piebald/black-brownish spotted
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Adult
Got out of the apartment, screen door was not fully closed. Neighbor said saw him heading towards Holuday Park is West Des Moines. It was around 7 pm. He has been with me 9 years, he has a family that is frantic. His home is at Normandy Terrace Apts, unit 337. he is not chipped and not wearing his collar at the time.
Des Moines - North
Lost: 12/7/2016
ID: 4497
Name: Baby
Type: Cat
Color: White with Gray patches. Has unique gray patch on front of face
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Baby
Baby was last seen on 9th and Douglas. She slipped out with the dog. Highland Park/Oak Park. She is very friendly. Possibly stolen!!!
Des Moines - South
Lost: 12/7/2016
ID: 4495
Name: Asher
Type: Dog
Color: White/Jack Russel brown spots/brown patch on left eye
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
On the south side off Porter and SW 9th St.
Des Moines - East
Lost: 12/7/2016
ID: 4493
Name: Bunpkin
Type: Dog
Color: Brown/white
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Baby
Please if seen or found please contact me at 515-865-6836, he is the baby in my home.
Des Moines - East
Lost: 12/7/2016
ID: 4492
Name: Bunpkin
Type: Dog
Color: Brown/white
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Baby
Please if seen or found please contact me at 515-865-6836,
Des Moines - South
Lost: 12/7/2016
ID: 4489
Name: Nero
Type: Dog
Color: White
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Baby
Running after some animal out of our garage
Pleasantville
Lost: 12/6/2016
ID: 4494
Name: Sassir
Type: Cat
Color: Black with white spot on neck and white belly
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Pleasantville Iowa, beware he is not declawed.
Ames
Lost: 12/5/2016
ID: 5019
Name: Jack
Type: Dog
Color: White W/black spots
Breed: Anatolian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen by family on their farm. Last possible sighting in 01/17 near Gilman.
Linden
Lost: 12/5/2016
ID: 4529
Name: Barnabus
Type: Dog
Color: Black with reddish tint
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
4 miles NE of London, 10 miles south of Dawson, 8 miles east of Panora , 8 miles North of Redfield on the corner of highway 44 and highway P46.
Redfield
Lost: 12/5/2016
ID: 4526
Name: Barnabus
Type: Dog
Color: Black with a reddish tint
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
At the corner of highway 44 and p46 Dallas County Iowa. 10 miles south of Dawson, 8 miles east of Panora and 8 miles north of Redfield.
Chariton
Lost: 12/5/2016
ID: 4490
Name: Toby
Type: Dog
Color: Fawn w/ black mask
Breed: Mastiff
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen at Chariton airport and then later running past GW bank in Chariton with my other dog, possibly heading back home, disappeared right after that, black dog came home without him. He hasn't been seen since. We believe he might possibly be stolen. If you have any info of him or seen any sign of him anywhere please notify us at 641-931-0229
Berwick
Lost: 12/5/2016
ID: 4485
Name: Treble
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
1 mile north of Berwick
Ankeny
Lost: 12/5/2016
ID: 4482
Name: TREBLE
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
8.30.pm Dec 5
West Des Moines
Lost: 12/3/2016
ID:
Name: Phoebe
Type: Dog
Color: Black white and brown
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Last seen at Graveyard circle at Mills Civic and S 88th around noon on 12/3, she is skiddish and may run, call megan 515-974-9134, phoebe is so sweet but scared, we think heading home to waukee, she jumped the fence at Raccoon River Kennel at 10 am 12/3.
West Des Moines
Lost: 12/3/2016
ID:
Name: Phoebe
Type: Dog
Color: Black white and brown
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Last seen at Graveyard circle at Mills Civic and S 88th around noon on 12/3, she is skiddish and may run, call megan 515-974-9134, phoebe is so sweet but scared, we think heading home to waukee, she jumped the fence at Raccoon River Kennel at 10 am 12/3.
Des Moines - South
Lost: 12/3/2016
ID: 4466
Name: Tony
Type: Dog
Color: Black and white tan eye brows
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Boston terrier x daschund mix. Very hyper very happy is a jumper very approachable and will come when called. Very very very fast. Mistaken alot for a puppy pitbull. Does not bite and is not a Barker. Last seen this morning 530am on pioneer in between indianola and se5th.
Cumming
Lost: 12/2/2016
ID: 4487
Name: Nellie Rosa
Type: Cat
Color: Black and Orange Tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Maffitt Lake Farms
Cedar Falls
Lost: 12/2/2016
ID: 4464
Name: Belle
Type: Dog
Color: White/black
Breed: Basset Hound
Gender: Male
Fixed: Not Applicable
Age: Young
Won't let me select Waterloo.. But I'm on w 11th street in Waterloo and she got out overnight. I'm assuming chasing a squirrel. Doesn't have a collar on but she is chipped. She's really friendly. Call me at 3199392219
Urbandale
Lost: 11/30/2016
ID: 4730
Name: Zippy
Type: Dog
Color: fawn with white patch on chest and paws
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Adopted from the arl and they had him listed as a Labrador retriever mix, he look like he is mixed with terrier.