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>='1594166400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 7/3/2020
ID: 14490
Name: Baby
Type: Cat
Color: Black and gray
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Baby
Last seen morning of the 3rd, accidentally got out of house. He's a large not fat cat,friendly but cautious ,jumpy, scaredy cat kind of way. Please take to ARL, his brother cheeto is sick over his disappearance
Des Moines - Central
Lost: 7/3/2020
ID: 14428
Name: Nibbler
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Please find my baby, he ran away from fireworks on the north side of Des Moines near the bike trails but could be anywhere by now. Cash reward for any help
Des Moines - East
Lost: 7/3/2020
ID: 14427
Name: Loki
Type: Cat
Color: black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 7/3/2020
ID: 14402
Name: Nibbler
Type: Dog
Color: Mostly black
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Last seen near north high school/Riverview area. He's very friendly but afraid of fireworks and will run from loud noises.
Des Moines - Central
Lost: 7/3/2020
ID: 14401
Name: Greta
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
Beaverdale area. Greta is very friendly. Shes a companion animal.
Des Moines - South
Lost: 7/3/2020
ID: 14399
Name: Huck
Type: Dog
Color: Brown
Breed: Coonhound
Gender: Male
Fixed: Not Neutered
Age: Young
REWARD. McKinley/sw 9th area. Hoping he’s with his little sisters (bullies ) it’s like Huck to be Houdini but not the girls. It’s odd they’re all missing! If you see anyone with them please contact me right away with their location.
Des Moines - South
Lost: 7/3/2020
ID: 14398
Name: Haley
Type: Dog
Color: Black and white
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
REWARD. McKinley/sw 9th area. She will have been with her sister and a coon hound (brother)
Des Moines - South
Lost: 7/3/2020
ID: 14397
Name: Bailey
Type: Dog
Color: Grey and white
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
REWARD. Micknley/sw 9th area. She would be with her sister who is black and white and a big coon hound.
Des Moines - East
Lost: 7/2/2020
ID: 14457
Name: Haze
Type: Dog
Color: black w/white, tan. Grey face
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Ran due to fireworks. He is scared of them. He is micro chipped if you take him to ARL on SE 14th St they will call us
Des Moines - East
Lost: 7/2/2020
ID: 14456
Name: Haze
Type: Dog
Color: black w/white, tan and
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
7/2 He was scared by the fireworks and ran off. He is micro chipped so if you take him to the ARL on SE 14th St they will call me. Thank you
Des Moines - Central
Lost: 7/2/2020
ID: 14396
Name: Gizzy
Type: Dog
Color: blonde brown with white
Breed: Pomeranian Standard
Gender: Male
Fixed: Unknown
Age: Young
He is friendly and scared
West Des Moines
Lost: 7/2/2020
ID: 14391
Name: Charlie
Type: Cat
Color: Orange/ brown spots
Breed: Bengal
Gender: Unknown
Fixed: Not Neutered
Age: Adult
She jumped off balcony at the club of Washington Heights
Lacona
Lost: 7/2/2020
ID: 14390
Name: Buddy
Type: Dog
Color: Brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
In the country in Lacona near milo as well.
Des Moines - East
Lost: 7/2/2020
ID: 14385
Name:
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
By grandview college. please give me general description of what he looks like so we can return to the correct owner.
Des Moines - Central
Lost: 7/1/2020
ID: 14449
Name: Shadow Ghost Wolf
Type: Dog
Color: Black and Tannish brown
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Adult
She was last seen with my ex Austin Lee Meyers who was taking care of her till I had gotten situated in a housing out here in Sacramento California where I moved to. I had told my ex I was working on getting her home to me and was going to keep him posted on what all I've been doing in regards to getting my service dog out here to me. I bought shadow Ghost Wolf out here in Sacramento California when she was a puppy June of 2015 and have had her since then up to February when me and my ex agreed she stay with him either till he couldn't handle her anymore or I got housing which they both had happened around the same time which was back in late March early April.
Waterloo
Lost: 7/1/2020
ID: 14379
Name: Rocky
Type: Cat
Color: Dark
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Hawarden
Lost: 6/30/2020
ID: 14435
Name: Maya
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 6/30/2020
ID: 14395
Name: Gonzo
Type: Cat
Color: Dark brown and black tiger stripes
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Adult
She has green eyes and white hairs in her ears that grow out and curl back
Des Moines - Central
Lost: 6/30/2020
ID: 14388
Name: Carter
Type: Cat
Color: Gray tabby, white feet & chest
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 6/30/2020
ID: 14383
Name:
Type: Cat
Color: Blacks,golds
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Baby
Big cat, scared of everything, name is mama kitty, don’t try to pick her up or approach,
Des Moines - North
Lost: 6/30/2020
ID: 14372
Name: Harvey
Type: Dog
Color: White/brown spots
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Senior
Took off around 5am by Birdland Marina, at 8:30am a man at mchenry park said he saw him on 9th st towards Aurora ave he's 11yrs old, has arthritis, very friendly, he also has a tumor on his scrotum sack, Please bring our boy home! There is a $200 reward if found
Des Moines - East
Lost: 6/29/2020
ID: 14370
Name: pedro
Type: Dog
Color: black
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
was in fence in backyard with other dogs and when fireworks started he got out of fence and took off
Des Moines - East
Lost: 6/29/2020
ID: 14369
Name: pedro
Type: Dog
Color: black
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
was in fence in backyard with other dogs and when fireworks started he got out of fence and took off
Onawa
Lost: 6/28/2020
ID: 14440
Name: Chubbs
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Onawa.
Johnston
Lost: 6/28/2020
ID: 14378
Name: Nola
Type: Cat
Color: mix of white, tan, and dark brown
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
Headed toward a forest nearby home, very friendly.