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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 3/7/2015
ID: 43
Name: unknown
Type: Dog
Color: tan
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
druid hill / south side area
Altoona
Lost: 3/4/2015
ID: 39
Name: Maddie
Type: Dog
Color: yellow/ white
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Tuscany on 80th street in Altoona
Windsor Heights
Lost: 3/1/2015
ID: 22
Name: Cody
Type: Dog
Color: Black & White with some caramel
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Cody was in our fenced in yard during the afternoon with our other dog. When we were trying to bring them inside we noticed that Cody was missing.
Rowley
Lost: 2/28/2015
ID: 145
Name: Gunner
Type: Dog
Color: black tri color
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Last seen playing on our property (2 acres) all morning and early afternoon. We went outside to call for him and he did not return. He sometimes went exploring to our neighbors but they too had not seen him.
Lamoni
Lost: 2/28/2015
ID: 59
Name: jack
Type: Dog
Color: brown/white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
south of lamonia,Iowa,he is very happy and hyper,loves everyone...
Fredonia
Lost: 2/24/2015
ID: 21
Name: mia
Type: Dog
Color: white,brown
Breed: Alaskan Husky
Gender: Female
Fixed: Not Neutered
Age: Young
They was last spotted together in creston,iowa
Des Moines - East
Lost: 2/23/2015
ID: 19
Name:
Type: Dog
Color: white/yellow/tan
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
She was lost on Thompson St between E.14th and Glenbrook Dr. Around 3 pm. She's very friendly and very much a part of our family. We miss her very much! Please if you have any information contact us @515-346-9222
Ankeny
Lost: 1/4/2015
ID: 64
Name: Tiny
Type: Dog
Color: white
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Senior
Please call 515-971-7891 if you have found her or know where she is.
Des Moines - Central
Lost: 1/3/2015
ID: 4018
Name: Oso
Type: Dog
Color: Brown and his paw with white
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Young
U see wear light coat green
Cincinnati
Lost: 12/14/2014
ID: 317
Name: Phoebe
Type: Dog
Color: YELLOW
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Young
She was outside in yard with her daughters labs for about 20 min and disappeared.
Fort Dodge
Lost: 12/13/2014
ID: 76
Name: Ava
Type: Dog
Color: Brown/black
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Young
We had her boarded while we were out of town at a wedding. She jumped the fence. Friendly probably will be skiddish of strangers. My kids miss their best friend.
Fort Dodge
Lost: 12/13/2014
ID: 15
Name: Ava
Type: Dog
Color: Brown/Black
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Young
She jumped the fence while we had her boarded while we were out of town. Very fast, might be skiddish towards strangers. Loves kids
Des Moines - South
Lost: 12/10/2014
ID: 806
Name:
Type: Dog
Color:
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Earlham
Lost: 11/13/2014
ID: 10
Name: Greta
Type: Dog
Color: black/white/grey
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Missing from Earlham Iowa since November 13th. No sightings of her since.
Des Moines - South
Lost: 10/26/2014
ID: 1097
Name: Soldier
Type: Dog
Color: "blue" grey and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
He was last seen between se8th and se5th off Rose Ave on south side of des moines. He is very friendly and is missed dearly! Will not hurt anyone although he may be intimidating at first sight. He is known as a Blue Pit and he is very good looking with a big head. may have has some skin irritations since he has been away from home due to not having his normal skin/coat care.
Des Moines - East
Lost: 8/18/2014
ID: 58
Name: Mandy
Type: Dog
Color: Reddish head and legs. Back black with gray.
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
Escaped to chase a bunny. Tracking dogs found her scent at Goodrill school on E29th; on Guthrie by 235; along the fence beside 235/35 starting at Euclid, crossing Broadway and up by the jail; just west and across the street from the ARL; area where Interstates 35 an 80 cross; at E14th and Broadway; at Euclid and E29th, on the bike/walking trail between Euclid and E33rd and going up to Broadway following Four Mile. Could be anywhere.
Stanton
Lost: 8/8/2014
ID: 93
Name: Nanook
Type: Dog
Color: Blue merl
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
By viking lake in Stanton Iowa was lost
Stanton
Lost: 8/7/2014
ID: 94
Name: Kana
Type: Dog
Color: Fawn
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
By Viking lake area in Stanton iowa
Maxwell
Lost: 7/4/2014
ID: 174
Name: Jaxon
Type: Dog
Color: Black and brown
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
Jaxon ran from a farm outside of maxwell on july 4th 2014. He has an eye condition so is typicallly squinty/gooby around eye area. Loves to lick toes. Is leary around male humans he is not used to. Has never been agressive.
Dunkerton
Lost: 4/6/2014
ID: 2727
Name: Chance
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Chance was last seen at his home in Dunkerton Iowa April 6,2014
Spencer
Lost: 8/18/2013
ID: 7813
Name: Pup or boy
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Norwalk
Lost: 12/5/2012
ID: 1909
Name: Tigy
Type: Cat
Color: brown and black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He will also come to my baby. I miss him very much and I would really appreciate it if anybody has seen him.
Greenfield
Lost: 8/1/2012
ID: 3769
Name: Dakota
Type: Dog
Color: Mult-Colored. Brown, Tan, Black
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
Would be around 4 years old now.
Des Moines - East
Lost: 1/17/2012
ID: 7828
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
1544 Royer st des moines iowa 50316
Creston
Lost: 3/20/2011
ID: 737
Name: Lily
Type: Dog
Color: Black and white
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby