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>='1614729600')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 12/21/2019
ID: 13100
Name: Oliver
Type: Cat
Color: Black, white, light brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Around Sherwood Glen apartment area, his left pupil is fogged over, super friendly
Ankeny
Lost: 12/21/2019
ID: 13092
Name: Hoobie
Type: Dog
Color: Brown with black
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
Ankeny
Des Moines - Central
Lost: 12/21/2019
ID: 13088
Name: Ella
Type: Dog
Color: Tan
Breed: Xolo/Mexican Hairless
Gender: Unknown
Fixed: Unknown
Age: Adult
Last seen near principal park/ Mullets restaurant downtown. She is VERY timid and will most likely run away if approached. If seen, please contact Shannon at 8154942811. Reward if found
Des Moines - West
Lost: 12/21/2019
ID: 13087
Name: Tiger
Type: Dog
Color: Brown black and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen with our dog Miko on 56th street and they ran off when we let them out to potty.
Des Moines - West
Lost: 12/21/2019
ID: 13086
Name: Miko
Type: Dog
Color: Tan and black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on 56th st
Guthrie Center
Lost: 12/21/2019
ID: 13082
Name:
Type: Dog
Color: Grey and white
Breed: Husky
Gender: Female
Fixed: Neutered
Age: Adult
On my back yard
Low Moor
Lost: 12/20/2019
ID: 13127
Name: Blue
Type: Dog
Color: Black snd white
Breed: Bluetick Coonhound
Gender: Male
Fixed: Unknown
Age: Adult
Melrose
Lost: 12/20/2019
ID: 13081
Name: Cow
Type: Dog
Color: White, black, brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 10:45 am
Ankeny
Lost: 12/20/2019
ID: 13078
Name: Luna
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Call 515-402-5512 please!!!
Cedar Rapids
Lost: 12/20/2019
ID: 13077
Name: Josie
Type: Dog
Color: White
Breed: Poodle Miniature
Gender: Male
Fixed: Unknown
Age: Young
Friendly. Has phone number on collar.
Des Moines - Central
Lost: 12/20/2019
ID: 13073
Name:
Type: Dog
Color: Black with white on chest
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Young
46th and Holcomb Beaverdale
Des Moines - South
Lost: 12/20/2019
ID: 13072
Name: Todd
Type: Dog
Color: Brown and Black
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Adult
Inside yard at 7:30am
Ankeny
Lost: 12/20/2019
ID: 13069
Name: Onyx
Type: Dog
Color: white/gray/black
Breed: Alaskan Malamute
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Ankeny area Possibly has a blue leash with him
West Des Moines
Lost: 12/19/2019
ID: 13105
Name: Lashonda
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 12/19/2019
ID: 13076
Name: Arrhur
Type: Cat
Color: Orange long hair
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He is very friendly. We desperately want him home. He runs out when I help my older dog out to the bathroom. He always come back and this is far too long.
Iowa City
Lost: 12/19/2019
ID: 13070
Name: Albus
Type: Dog
Color: Brown/tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Lost around Kinnick Stadium/ Koser Ave. area. Shepherd mix. VERY friendly. Might answer to Nova.
Lucas
Lost: 12/18/2019
ID: 13064
Name: Judge
Type: Dog
Color: Blue Merle
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 10pm on 12/18/19
Des Moines - East
Lost: 12/18/2019
ID: 13056
Name: Speedy
Type: Dog
Color: Tan/white
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Young
He answers to but but or paw paw peedy
Des Moines - East
Lost: 12/17/2019
ID: 13053
Name: Beau
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the Brook run village complex
Des Moines - Central
Lost: 12/17/2019
ID: 13051
Name: Flynn
Type: Cat
Color: Orange tabby
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
7:30 p.m last seen, can be a shy cat to strangers.
Des Moines - South
Lost: 12/17/2019
ID: 13050
Name: Cheyenne
Type: Dog
Color: Liver, white and gray
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Not Applicable
Age: Adult
Near Brody Jr high
Des Moines - South
Lost: 12/17/2019
ID: 13049
Name: Cheyenne
Type: Dog
Color: Liver, white and gray
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Not Applicable
Age: Adult
Near Brody Jr high
Norwalk
Lost: 12/17/2019
ID: 13048
Name: Bruce Wayne
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Orchard Hills Neighborhood. Near the stacked townhomes
Melbourne
Lost: 12/16/2019
ID: 13122
Name: Rosie
Type: Dog
Color: White black spots
Breed: English Setter
Gender: Female
Fixed: Not Neutered
Age: Young
We live in the country and she went out with out Great Pyrenees that night. He came back but she did not. She is my child's pet.
Melbourne
Lost: 12/16/2019
ID: 13090
Name: Rosie
Type: Dog
Color: White black spots
Breed: English Setter
Gender: Female
Fixed: Not Applicable
Age: Young
My daughter is so devastated with her loss. She let her out Monday and Rosie went out hunting with our Great Pyrenees and did not return. Please help! Melbourne is just south or Marshalltown if you know anyone that was hunting in the area.