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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 11/22/2018
ID: 10147
Name: Trace
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on SE 17TH and pleasant view dr he's very friendly and loves to snuggle. He's an indoor cat.
Des Moines - South
Lost: 11/22/2018
ID: 10067
Name: Jake from state farm
Type: Cat
Color: Grey stripes normal standard cat with white tip on his tail
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Waukee
Lost: 11/22/2018
ID: 10066
Name: Minon
Type: Cat
Color: Calico
Breed: Torbie
Gender: Female
Fixed: Not Neutered
Age: Young
She probably doesn't have a collar, she keeps slipping out of it. Has claws. She can be pretty hostile to women. She's a short hair Torbie with a Calico pattern. More than likely still around Waukee Ave. or Northview.
Des Moines - East
Lost: 11/22/2018
ID: 10062
Name: Rosie
Type: Dog
Color: White and brindle
Breed: American Bulldog
Gender: Female
Fixed: Unknown
Age: Adult
Last seen on Hubbel and 44th St in Des Moines
Colfax
Lost: 11/22/2018
ID: 10057
Name: Paisley
Type: Dog
Color: Blue Merle
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
Last seen at parents house on Hwy 117 south. She is very shy
Des Moines - South
Lost: 11/21/2018
ID: 10090
Name: Gilbert
Type: Cat
Color: White black spots
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He got out when guests were coming into our home. He hasn't been seen since
Ankeny
Lost: 11/21/2018
ID: 10085
Name: Stewie
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen on the NW side of Ankeny on the edge of town near the Trestle Trail.
Des Moines - East
Lost: 11/21/2018
ID: 10069
Name: Ozzy
Type: Dog
Color: Beige
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Ozzy slipped out the gate as my husband has dementia and forgot to close it as we were visiting our daughter
Dallas Center
Lost: 11/21/2018
ID: 10061
Name: Gizmo
Type: Dog
Color: White and Brown
Breed: Maltipoo
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen wandering Dallas Center, he does bark at people
West Des Moines
Lost: 11/21/2018
ID: 10048
Name: Lola
Type: Dog
Color: White
Breed: Red Heeler
Gender: Female
Fixed: Not Neutered
Age: Young
Carriage Park apartments, 50th and pleasant street, she is really friendly
Hawkeye
Lost: 11/20/2018
ID: 10117
Name: Pearl
Type: Dog
Color: Black, with a gray aged face and paws
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Pearl was last seen pheasant hunting with her owner between West Union, Fredericksburg, and Hawkeye, Iowa. She had a on a shock collar and a cow bell. She was also wearing boots. She is a senior black lab, with a gray face. She is friendly.
Boone
Lost: 11/19/2018
ID: 10042
Name: Thor
Type: Dog
Color: Black and tan
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
510 W 5th Street
Des Moines - Central
Lost: 11/19/2018
ID: 10039
Name: Pippy
Type: Dog
Color: white
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Adult
My mini golden doodle who is shaved ran off around 42nd st and Greenwood Drive in Des Moines. She is about 30 lbs.
Des Moines - South
Lost: 11/18/2018
ID: 10037
Name: Demon
Type: Dog
Color: Brown and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 11/18/2018
ID: 10036
Name: Demon
Type: Dog
Color: Brown and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Lost around East Edison Ave in des moines.
Ankeny
Lost: 11/17/2018
ID: 10115
Name: Scooby
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
He's pretty friendly, very cuddly and meows alot, loves to eat.
Oskaloosa
Lost: 11/17/2018
ID: 10054
Name: Wilson
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 200 Northshore Drive Oskaloosa which is about 3 miles north of town.
West Des Moines
Lost: 11/17/2018
ID: 10051
Name: Simon
Type: Cat
Color: White
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 11/17/2018
ID: 10049
Name: simon
Type: Cat
Color: white and black
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Johnston
Lost: 11/17/2018
ID: 10030
Name: Raven
Type: Cat
Color:
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Last seen by chapel ridge townhomes in Johnston Ia. Is micro chipped and has never been outside. Has 4 kids that miss her so much. Please call 515-802-0741
Johnston
Lost: 11/17/2018
ID: 10026
Name: Foxy
Type: Dog
Color: White and tan
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 11/17/2018
ID: 10023
Name: Hazel
Type: Dog
Color: Black/Brown/white
Breed: Pomeranian
Gender: Unknown
Fixed: Unknown
Age: Adult
Jumped out of window by hyvee on fluer drive by the airport. Call sell phone 5154237642. Very friendly and full of energy
Des Moines - South
Lost: 11/17/2018
ID: 10022
Name: Hazel
Type: Dog
Color: Black/Brown/white
Breed: Chiweenie
Gender: Unknown
Fixed: Unknown
Age: Adult
Jumped out of window by hyvee on fluer drive by the airport. Call sell phone 5154237642. Very friendly and full of energy
Des Moines - South
Lost: 11/17/2018
ID: 10021
Name: Hazel
Type: Dog
Color: Black/Brown/white
Breed: Chiweenie
Gender: Unknown
Fixed: Unknown
Age: Adult
Jumped out of window by hyvee on fluer drive by the airport. Call sell phone 5154237642. Very friendly and full of energy
Des Moines - South
Lost: 11/16/2018
ID: 10018
Name: Riley
Type: Dog
Color: Black with white upper chest
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in SW 15th St in Des Moines