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
Ankeny
Lost: 3/17/2016
ID: 2484
Name:
Type: Dog
Color: white and black
Breed:
Gender: Male
Fixed: Unknown
Age: Baby
Ankeny
Des Moines - South
Lost: 3/17/2016
ID: 2483
Name: Candy
Type: Dog
Color:
Breed: Greyhound
Gender: Male
Fixed: Unknown
Age: Adult
she got out of her fence on 31st in south DSM
Council Bluffs
Lost: 3/16/2016
ID: 3508
Name: Bleau
Type: Dog
Color: Blue
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - West
Lost: 3/16/2016
ID: 2496
Name: Maxi
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Baby
West Des Moines
Lost: 3/15/2016
ID: 2472
Name: Maverick
Type: Dog
Color: Fawn
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Lost: 3/15/2016
ID: 2471
Name: Maverick
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
Murray
Lost: 3/14/2016
ID: 2572
Name: Jasper
Type: Dog
Color: Black
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Adult
Friendly happy dog. May have been picked up as he probably would jump in if someone invited him. We miss him like crazy!!!!
Des Moines - North
Lost: 3/13/2016
ID:
Name: George
Type: Cat
Color: Dark and light grey, white, like and dark brown
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Senior
Last seen in Douglas acers neighborhood/ Delaware town ship area
Indianola
Lost: 3/13/2016
ID: 2460
Name: Buddy
Type: Dog
Color: Black and brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen at lake aquabi please call 515 808 8111 if you see him he is very friendly we just want him back home
Lansing
Lost: 3/12/2016
ID: 2550
Name: Callie
Type: Dog
Color: Dark brown & black
Breed: Brussels Griffon
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near North Front Street in Lansing, Iowa. Long hair, about 12 lbs, looks like an Ewok (Star Wars). Very shy dog - she is our baby and we are desperate to find her. Please call 319 830 7945 with any information.
Morning Sun
Lost: 3/12/2016
ID: 2500
Name: Diesel
Type: Dog
Color: Dark brindle
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
He was on our farm and was stolen. It was reported of a man in a old green truck possible Chevy trying to sell a dog just like him that same evening. He is owned by a 14 year old girl who is devastated.
Des Moines - Central
Lost: 3/12/2016
ID: 2455
Name:
Type: Dog
Color:
Breed: Bulldog
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 3/10/2016
ID: 2486
Name: Unknown
Type: Dog
Color: Brown, gray, tan
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Young
Found him running around on the street off of Guthrie ave. No one I spoke to in the area recognized him
Indianola
Lost: 3/10/2016
ID: 2451
Name: Rio
Type: Bird
Color: Gray green yellow
Breed: Parrot
Gender: Male
Fixed: Unknown
Age: Young
Indianola
Lost: 3/10/2016
ID: 2450
Name: Rio
Type: Bird
Color: Gray green yellow
Breed: Parrot
Gender: Male
Fixed: Unknown
Age: Young
Indianola
Lost: 3/10/2016
ID: 2449
Name: Rio
Type: Bird
Color: Green, gray, yellow
Breed: Parrot
Gender: Male
Fixed: Unknown
Age: Young
Indianola Iowa South 1st St
Des Moines - Central
Lost: 3/9/2016
ID: 2520
Name: Harley
Type: Dog
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen near 13th&forest near Forest Park. Very friendly. He is my everything please help me find him!
Albia
Lost: 3/9/2016
ID: 2491
Name: Sargent
Type: Dog
Color: Red
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Western monroe county
Des Moines - West
Lost: 3/9/2016
ID: 2443
Name: Thunder
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 12:30 on Wed. He has his front claws and a little white spot on his chest.
Des Moines - East
Lost: 3/8/2016
ID: 2452
Name: Marley
Type: Cat
Color: Grey white stripped
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He got out the back door when I was taking the trash out, he is our baby and we've looked everywhere for our baby. Please help us find Marley
West Des Moines
Lost: 3/8/2016
ID: 2435
Name: JOEY
Type: Dog
Color: BLACK AND WHITE
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at 2501 Westown Parkway, West Des Moines, IA. Please call 515-720-8582
Davenport
Lost: 3/8/2016
ID: 2432
Name: micah
Type: Dog
Color: black
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 3/7/2016
ID: 2429
Name: Nini
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Got outside overnight around se 19th and park, she's very friendly to some and skittish around during others ,she has a white tipped ear and a little white on her chest
Elk Run Heights
Lost: 3/5/2016
ID: 8829
Name: Morty
Type: Cat
Color: Tiger-Grey, Black, Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Toneff and James in Elk Run Heights near the truck stops at Evansdale Highway 20. Friendly. Likes to go for rides. Male, Tiger -Grey, black, brown. Aqua-blue eyes. Neutered. Drools when he purrs.
Altoona
Lost: 3/5/2016
ID: 2417
Name: Joe Joe
Type: Cat
Color: Black and white striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen Saturday morning March 5th 2016.