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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - East
Lost: 5/3/2017
ID: 5485
Name: Oscar
Type: Cat
Color: Gray/White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at home on East Side of DSM, unsure if he got out or not.
Ankeny
Lost: 5/3/2017
ID:
Name: brinlee
Type: Dog
Color: Liver
Breed: German Shorthaired Pointer
Gender: Unknown
Fixed: Unknown
Age: Young
She was last seen on the NE 29th block off of Delaware in Ankeny! She is a great dog and too smart for her own good unlocking our fence!
Des Moines - South
Lost: 5/3/2017
ID: 5479
Name: Unknown
Type: Dog
Color: Primarily black
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
Near Lincoln High School down Creston ave
Elk Horn
Lost: 5/2/2017
ID: 5540
Name: Spud
Type: Dog
Color: Black and Tan
Breed: Black And Tan Coonhound
Gender: Male
Fixed: Not Neutered
Age: Adult
Has an electronic dog collar that is faded. Scar behind front elbow, tattoo in ear.
Iowa City
Lost: 5/1/2017
ID: 5465
Name: Boss ladi
Type: Dog
Color: Black white a lil grey
Breed: Poodle Standard
Gender: Female
Fixed: Not Neutered
Age: Baby
On Muscatine Ave across from Walgreens
Des Moines - North
Lost: 4/30/2017
ID: 5454
Name: Jersey
Type: Dog
Color: Black with White markings
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Beaver Avenue, near Hickman Road. She is new to us and slipped her collar. Hasn't even been to vet for microchipping yet. Help!
West Des Moines
Lost: 4/29/2017
ID: 5562
Name: Mao
Type: Cat
Color: Tiger Striped (Long(ish) fur
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is friendly but, he is vocal. Last seen in the Valley Junction Area 6th and Maple his microchip will come back to Cedar Falls. This is my daughter's cat please contact me (Reward)
Des Moines - North
Lost: 4/29/2017
ID: 5460
Name: Nosey
Type: Cat
Color: Multi
Breed: Domestic Medium Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen around the 2nd and aurora area... she is very petite and her brother is missing her