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>='1558051200')) ORDER BY pm1.meta_value DESC, post_date DESC
Clare
Lost: 5/22/2019
ID: 11399
Name: Luna
Type: Dog
Color: White with brown dpots
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Young
8 miles west of Clare.
North Liberty
Lost: 5/22/2019
ID: 11398
Name: Gus
Type: Dog
Color: Liver
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen headed Southwest of the Penn and 965 area
Des Moines - South
Lost: 5/22/2019
ID: 11397
Name: Walter
Type: Cat
Color: Gray
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on our security camera escaping the house because the Mid American Energy meter men did not close our door after they entered our house.
Des Moines - North
Lost: 5/22/2019
ID: 11393
Name: Midnight
Type: Cat
Color: Black
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
He lives in the north high school area hes not an outside cat
Des Moines - South
Lost: 5/21/2019
ID: 11391
Name: Miley
Type: Cat
Color: Dark Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Miley was last seen at SW 12th Pl and Thornton Ave. We last saw her on 4/8/19. We miss her so much and just want her to come back home! Please contact me if you have seen her at all. 5154012478
West Des Moines
Lost: 5/21/2019
ID: 11385
Name:
Type: Dog
Color:
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
7171 Woodland Ave
Colo
Lost: 5/20/2019
ID: 11400
Name: Yadi
Type: Dog
Color: White/Black Mix
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
Yadi got out of the house with her buddy Rizzo Monday evening in Colo, IA. Rizzo is also a Siberian Husky, but he returned home Tuesday morning. Yadi is very kind, but likes to run. She has a very noticeable Mohawk, White tipped ears, with a beautiful all white face/blue eyes. I’m posting this for my sister-in-law who is worried sick and just wants her fur baby home. Since Colo, IA is right off of HWY 30, I wanted to post this state wide.
Des Moines - South
Lost: 5/20/2019
ID: 11389
Name:
Type: Cat
Color: Grey
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
Ames
Lost: 5/20/2019
ID: 11388
Name: Silhou
Type: Cat
Color: Black
Breed: Bombay
Gender: Male
Fixed: Neutered
Age: Adult
Talkative and friendly. Please bring him back to our family! Our hearts are broken.
Ankeny
Lost: 5/20/2019
ID: 11387
Name: Penny
Type: Cat
Color: White, Brown, Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
White/Brown Cat on The Left, Last Seen in NW Ankeny Area (Watercrest Development)
Urbandale
Lost: 5/19/2019
ID: 11381
Name: Atlas
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Young
Atlas is timid and scared of people. He will bark but not bite.
Des Moines - East
Lost: 5/19/2019
ID: 11376
Name: Simone
Type: Cat
Color: Black, tan
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Young
She is spayed and has no front claws.
Des Moines - Central
Lost: 5/18/2019
ID: 11378
Name: Itty bitty
Type: Cat
Color: Tan white black
Breed: Snowshoe
Gender: Male
Fixed: Unknown
Age: Baby
Lost near 37th st and Kingman blvd
Waukee
Lost: 5/18/2019
ID: 11375
Name: Pumpkin
Type: Cat
Color: Dilute Tortie
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Seen near SE Booth Ave/ Waddell Way at subdivision clubhouse area.
Des Moines - South
Lost: 5/18/2019
ID: 11369
Name: Rocket
Type: Dog
Color: White/black/brown
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen around 6pm, he has a red harness, very friendly and loves to play and run around, he loves attention
Des Moines - North
Lost: 5/18/2019
ID: 11368
Name: Sam
Type: Dog
Color: Reddish brown
Breed: Staffordshire Bull Terrier
Gender: Female
Fixed: Neutered
Age: Adult
At home at 56th and Urbandale. 50 lbs, stocky, has a skin tag on her chin.
Altoona
Lost: 5/18/2019
ID: 11367
Name: Frank/Frankie
Type: Cat
Color: Mostly white with grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
We live at the Ironwood apartments in Altoona! He’s most likely still in the area and just is lost! Frankie likes bushes and is afraid of cars. He’s really friendly and goofy, we miss him a ton! Please e-mail me if you have any information- a2000vl@gmail.com
Des Moines - Central
Lost: 5/18/2019
ID: 11366
Name: Avalanche
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Adult
I lunch was last seen on 12 Street right off of Clark and Forest he is eight years old he is not fixed not Microchipped and he has one missing tooth he does have really bad anxiety and is scared of rain and storms avalanche does have some health issues please help me bring my baby home
Des Moines - Central
Lost: 5/18/2019
ID: 11365
Name: Avalanche
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on 1417 12th St off of Clark
Altoona
Lost: 5/18/2019
ID: 11363
Name: Milkshake
Type: Cat
Color: White and gray
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 5/18/2019
ID: 11360
Name: Velcro
Type: Cat
Color: light orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on 05/10 around 11PM. He has white paws, chest and mouth areas. Friendly and lovey with family but unsure of others. Responds well to Pringles cans. Please contact 515-745-9840 if seen. We miss him very much.
Des Moines - Central
Lost: 5/18/2019
ID: 11352
Name: Hoagie
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Senior
2193 62nd Street Des Moines
Des Moines - Central
Lost: 5/18/2019
ID: 11351
Name: Hoagie
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Senior
2103 62nd street Des Moines ia 50322
Des Moines - Central
Lost: 5/18/2019
ID: 11350
Name: Hoagie
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Unknown
Age: Baby
2103 62nd Street Des Moines, IA
Des Moines - Central
Lost: 5/17/2019
ID: 11386
Name: Hannarose
Type: Cat
Color: tabby with white socks and a wife ruff
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen at our home in the River Bend Neighborhood of Des Moines.