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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Grimes
Lost: 11/13/2018
ID: 9997
Name: Gilbert
Type: Dog
Color: Golden brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Grimes area
Des Moines - Central
Lost: 11/13/2018
ID: 9992
Name: Bella
Type: Dog
Color: Blonde
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Young
Very friendly. Does not bite. Will be with our other dog, Harvey, who also got out. He is a black lab with white paws. He does have a collar. Last seen in Beaverdale on Valdez Drive, near woodlawn Park.
Des Moines - Central
Lost: 11/13/2018
ID: 9991
Name: Harvey
Type: Dog
Color: Black, tiny bit of white on paws and chest
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, knows his name. Will be with our other dog, Bella, who also got out. She is a golden retriever/Malamute mix. Blonde with a curly tail. He was last seen in Beaverdale on Valdez Drive, near Woodlawn Park.
Des Moines - Central
Lost: 11/12/2018
ID: 10001
Name: Milo
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Monday midday early evening. He is an indoor/outdoor cat. So he loves being inside and outside. He doesn't have his collar cause he keeps chewing it off.. Not microchipped. Not declawed because he does go outside and he isnt neuter. Please help bring him home. My six year old is devastated..
Des Moines - South
Lost: 11/12/2018
ID: 9995
Name: Pepper
Type: Cat
Color: Black and gray
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Adult