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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Norwalk
Lost: 7/4/2017
ID: 6107
Name: Unknown
Type: Dog
Color: White with darker spots throughout back
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Came to our home north of the Bevington, IA Kum and Go. I believe I saw him Monday come through the yard and my dogs scared him off. Had on what I believe to be a shock collar with a bright orange strap. Then on the night of the Fourth he returned as the fireworks were going off. Great dog, well mannered, loves to play ball, doesn't mind cats at all.
Des Moines - South
Lost: 7/4/2017
ID: 6095
Name: Jessie
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
Two rows of bottom teeth. Reward family dog
Ankeny
Lost: 7/4/2017
ID: 6088
Name: Ali
Type: Dog
Color: Brown
Breed: Dachshund
Gender: Female
Fixed: Neutered
Age: Adult
Lost on SE 9th from our backyard. Will bark at first but NOT aggressive!
Dysart
Lost: 7/4/2017
ID: 6087
Name: Ariel
Type: Dog
Color: Black White Brown
Breed: Corgi
Gender: Male
Fixed: Neutered
Age: Young
Entered Cornfield East of Dysart
Bondurant
Lost: 7/4/2017
ID: 6085
Name: Maxx
Type: Dog
Color: Black
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Ran from our back yard because of fireworks, we live rural
Dexter
Lost: 7/4/2017
ID: 6072
Name:
Type: Dog
Color: White
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
We found this beautiful girl on our deck this morning at Diamondhead Lake (north between Dexter and Stuart).
Birmingham
Lost: 7/3/2017
ID: 7218
Name: Kona
Type: Dog
Color: Black, white belly, white paws, white on face, white tip on tail, tan markings where the white and black meet.
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last sighting had him west of Birmingham, in the country, south of Interstate 34. Has been missing for several months; I am desperately searching and running out of hope.
Adair
Lost: 7/3/2017
ID: 6371
Name: Dusty
Type: Cat
Color: Gray And white
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Adult
Sightings by other residents on west end of town mid July . His home is on east end of town. Answers to his name and "food food food" (called they way you'd call here kitty kitty)
Mount Pleasant
Lost: 7/3/2017
ID: 6102
Name: Arizona
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Ran when she was spooked by neighborhood fireworks. Has not been seen so may have been picked up and taken to another town. Very friendly but scares easily.
Urbandale
Lost: 7/3/2017
ID: 6094
Name: Henry
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Collar is a Petsafe shock collar. Friendly cat, vocal, will tap you with his front paw to get attention.
Waterloo
Lost: 7/3/2017
ID: 6082
Name: Villian
Type: Dog
Color: Tricolor
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Scared and escaped during fireworks
Des Moines - South
Lost: 7/3/2017
ID: 6078
Name: Tito
Type: Dog
Color: Brown
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Senior
Kenyon & south union
Lacona
Lost: 7/3/2017
ID: 6071
Name: OJ
Type: Dog
Color: Lite brown/black face
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
180 ave. Lacona Iowa Warren/Luca County
Lacona
Lost: 7/3/2017
ID: 6068
Name: OJ
Type: Dog
Color: Lite brown/ black face
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
Lacona area warren/ Lucas county
Bondurant
Lost: 7/3/2017
ID: 6067
Name:
Type: Dog
Color:
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 7/3/2017
ID: 6064
Name: Mya
Type: Dog
Color: White with reddish brown spine
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
E Holcomb and Cornell. Slipped out of her collar. Very friendly. Reward if found
Des Moines - North
Lost: 7/3/2017
ID: 6063
Name: Mya
Type: Dog
Color: White with reddish brown spine
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
E Holcomb and Cornell. Skipped out of her collar. Very friendly
Des Moines - South
Lost: 7/3/2017
ID: 6059
Name: Star
Type: Dog
Color: White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
She's a Lab Mix, white, with a ridge down her back-to-back like a Rhodesian Ridgeback. She's afraid of people.
West Des Moines
Lost: 7/3/2017
ID: 6055
Name: ??
Type: Dog
Color: White/Black
Breed: Mix
Gender: Male
Fixed: Not Applicable
Age: Adult
Randall
Lost: 7/2/2017
ID: 6192
Name: Kia
Type: Dog
Color: Tan
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Rockwell City
Lost: 7/2/2017
ID: 6174
Name: Barney
Type: Dog
Color: Black and White
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Senior
Barney is a well cared for very friendly dog. He was not wearing a collar. His owner misses him very much.
Des Moines - Central
Lost: 7/2/2017
ID: 6053
Name: drake
Type: Dog
Color: white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Lost: 7/2/2017
ID: 6051
Name: Precious
Type: Dog
Color: Brown and Black Brindle
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home right off E 14th and Euclid. She is terrified of fireworks and the neighbor let some off, so she took off. She is friendly to humans but timid around other dogs.
Des Moines - Central
Lost: 7/2/2017
ID: 6050
Name: Precious
Type: Dog
Color: Brown and Black Brindle
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home right off E 14th and Euclid. She is terrified of fireworks and the neighbor let some off, so she took off. She is friendly to humans but timid around other dogs.
Carlisle
Lost: 7/2/2017
ID: 6049
Name: Shilo
Type: Dog
Color: Black with tan
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
Last seen 7/1 before fireworks started going crazy...She's very old and very weak...she cannot walk well.