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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
La Motte
Lost: 7/4/2020
ID: 14416
Name: Piper
Type: Dog
Color: Tan/White
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Doesn’t know the area at all
Norwalk
Lost: 7/4/2020
ID: 14413
Name: Stella
Type: Dog
Color: Brown Black White
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Sunset and Elm in Norwalk
Malcom
Lost: 7/4/2020
ID: 14412
Name: Bella
Type: Dog
Color: Brown/black
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Hwy 63 malcom iowa Scared of fireworks Skittish
Norwalk
Lost: 7/4/2020
ID: 14411
Name: Stella
Type: Dog
Color: Brown Black White
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Sunset and Elm in Norwalk
Des Moines - North
Lost: 7/4/2020
ID: 14410
Name: Lady B
Type: Dog
Color: Blonde
Breed: Shar Pei
Gender: Unknown
Fixed: Neutered
Age: Adult
She got spooked from fireworks. She is very calm.
Mason City
Lost: 7/4/2020
ID: 14409
Name: Layla
Type: Dog
Color: White and brown
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Senior
On porch 917 n washington ave
Des Moines - East
Lost: 7/4/2020
ID: 14408
Name: Judy
Type: Dog
Color: White with black and brown spots
Breed: Basset Hound
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on Penn Avenue
West Des Moines
Lost: 7/4/2020
ID: 14407
Name: Lexi
Type: Dog
Color: Black
Breed: Chow Chow
Gender: Female
Fixed: Neutered
Age: Adult
Last seen crossing Jordan Creek heading east along the railroad tracks by Ashworth Rd
Des Moines - Central
Lost: 7/4/2020
ID: 14400
Name:
Type: Dog
Color: Blonde
Breed: Labradoodle
Gender: Male
Fixed: Unknown
Age: Young
With another small dog found wandering 235 around the 42nd street exit.
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