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
Odebolt
Lost: 5/9/2017
ID: 5954
Name: Harley
Type: Dog
Color: black/white chest
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
north of Odebolt Iowa wearing a neon collar with a red rabies tag on collar
Odebolt
Lost: 5/9/2017
ID: 5882
Name: Harley
Type: Dog
Color: Black /white chest
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
last seen in odebolt iowa someone at sparkys gas station said they may have seen him north of odebolt within the first mile. Harley is a runner he loves to run and he is fast! if anyone locates this dog their is a reward for him. thank you
West Des Moines
Lost: 5/9/2017
ID: 5565
Name: Indigo
Type: Cat
Color: Brown and black
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Last seen near Normandy Terrace Apartments. She has black paws.
Des Moines - West
Lost: 5/9/2017
ID: 5552
Name: Isis
Type: Cat
Color:
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
51st street, south of Grand
Des Moines - West
Lost: 5/9/2017
ID: 5545
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Front Declawed. Very sweet demeanor. email ted1957@mchsi.com
Des Moines - Central
Lost: 5/9/2017
ID: 5543
Name: Peaches
Type: Cat
Color: Buff/ Light Orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She is very friendly and sweet but also scared. She also has a very quiet meow and was wearing a pink harness and leash when she went missing.
Norwalk
Lost: 5/8/2017
ID: 5542
Name: Karma
Type: Dog
Color: light brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Last seen in the area of 50th and hwy 28 in prole. Answers to Karma. Very timid.
Norwalk
Lost: 5/8/2017
ID: 5541
Name: Karma
Type: Dog
Color: light brown
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Last seen in the area of 50th and hwy 28 in prole. Answers to Karma. Very timid.
Shelby
Lost: 5/8/2017
ID: 5531
Name:
Type: Dog
Color: White mixed
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
I found her on the road going from Shelby, IA to Harlan, IA.
Des Moines - South
Lost: 5/7/2017
ID: 5534
Name: Diamona
Type: Dog
Color: Brindle and white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Senior
Southside by lincoln high school
Indianola
Lost: 5/7/2017
ID: 5530
Name: Gwen
Type: Dog
Color: Black/White
Breed: Pointer
Gender: Unknown
Fixed: Neutered
Age: Adult
Around 90th Ave and Nevada south west of Indianola with our other dog a Chocolate Lab.
Indianola
Lost: 5/7/2017
ID: 5529
Name: Hershey
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 90th Avenue and Nevada with our other dog a black & white pointer.
Altoona
Lost: 5/7/2017
ID: 5514
Name:
Type: Dog
Color: White and black
Breed: Lhasa Apso
Gender: Female
Fixed: Unknown
Age: Baby
Pink collar
Des Moines - Central
Lost: 5/6/2017
ID: 5601
Name: Trevor
Type: Cat
Color: Brown with black stripes and white belly
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Outside in my backyard we do live in a fairly residential area anf ger collar is lose so it could have slipped off
Des Moines - West
Lost: 5/6/2017
ID: 5521
Name: Sunny
Type: Bird
Color: Yellow and green parakeet
Breed: Budgie/Budgerigar
Gender: Male
Fixed: Unknown
Age: Young
Lost at Iola and 36th streets. Kingman Blvd area
Urbandale
Lost: 5/6/2017
ID: 5504
Name: Hank
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Hank is a 10 year old sweet and gentle black lab. He escaped from our backyard this afternoon in Northview Estates at the edge of Urbandale/Johnston.
Des Moines - East
Lost: 5/6/2017
ID: 5502
Name: Sheeba
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Newton
Lost: 5/6/2017
ID: 5501
Name: Jed
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Near S 13th St W He should be with a yellow female lab that has a bark collar on that is black. The black lab is Jed and the yellow lab is Maddie.
Altoona
Lost: 5/6/2017
ID: 5499
Name: Tucker
Type: Dog
Color: Brown & White
Breed: Shetland Sheepdog Sheltie
Gender: Male
Fixed: Neutered
Age: Baby
In Altoona
Norwalk
Lost: 5/5/2017
ID: 5526
Name: Remy
Type: Dog
Color: Black and white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
Near Norwalk
Leland
Lost: 5/5/2017
ID: 5489
Name: Romeo
Type: Dog
Color: Brown white black
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Leland iowa just ran out of my girlfriends apartment
Hawkeye
Lost: 5/4/2017
ID: 5505
Name: Kyla
Type: Dog
Color: Black & White - a few brown spots
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Young
Kyla is an outside dog and familiar with the yard. She was barking in the night. Kyla can be shy with strangers.
Des Moines - East
Lost: 5/4/2017
ID: 5496
Name: Sushi
Type: Cat
Color: Grey tabby
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Sushi is soft spoken. His meow is small. He is friendly and loves to get attention until he's done, then he likes to be close.
Des Moines - Central
Lost: 5/4/2017
ID: 5487
Name: Cheeto
Type: Dog
Color: Black and Brown-Tan
Breed: Pinscher-Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Merle Hay area
Des Moines - East
Lost: 5/4/2017
ID: 5486
Name: Bumkin
Type: Dog
Color: tan
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Young
east side des moines, near capitol. blind in one eye. will respond to name