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
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
West Des Moines
Lost: 11/15/2018
ID: 10025
Name: Lydia
Type: Cat
Color: Mostly black, some white and gray. White spot on her nose
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Not declawed, never been outside alone, long hair, mostly black, some white, some gray. Two white spots on her nose, friendly but likely scared. Last seen at Crossroads Colony complex off 49th St. in West Des Moines. Near Pleasant & 49th intersection
Altoona
Lost: 11/15/2018
ID: 10019
Name: Pumpkin
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Corner of 5th Ave and 6th ST NW.
Pleasantville
Lost: 11/14/2018
ID: 10028
Name: sooki
Type: Cat
Color: large calico one gray strip leg one orange strip leg in the front tips of toes white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
572 40th ave. possible hopped into a ups or fedex truck information on chip is Heather williams 515 681 7275 sooki is 4 years old, she is my grandcat that i am keepingfor my grandkids she never leave the property . she loves kids. scared of strangers
Urbandale
Lost: 11/14/2018
ID: 10016
Name: Jasper
Type: Cat
Color: Orange and White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Round the 71 street urbandale
Johnston
Lost: 11/14/2018
ID: 10013
Name: Denver
Type: Cat
Color: Yellow/Golden/Tan
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Johnston over by Lawson Elementary.
Des Moines - Central
Lost: 11/14/2018
ID: 10006
Name: Herman Joseph Brooks
Type: Dog
Color: White, with a brown spots, and a brown head, he has a crocked tail
Breed: English Pointer
Gender: Male
Fixed: Neutered
Age: Adult
On 37th and Franklin
Des Moines - Central
Lost: 11/13/2018
ID: 10003
Name: Guinness
Type: Cat
Color: Black
Breed: English Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Microchip on left shoulder. Balding on head near ears and eyes. Green eyes. Belly hangs low. Has all claws.
Des Moines - Central
Lost: 11/13/2018
ID: 10002
Name: Guinness
Type: Cat
Color: Black
Breed: English Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Downtown riverfront lofts Has balding spots near ears. Belly hangs low. Movie chip over left shoulder.