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>='1579478400')) ORDER BY pm1.meta_value DESC, post_date DESC
Norwalk
Lost: 5/8/2017
ID: 5542
Name: Karma
Type: Dog
Color: light brown
Breed:
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
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!