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>='1599955200')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 5/10/2020
ID: 13979
Name: Samson
Type: Cat
Color: White and orange striped
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines/Waukee area off of University behind Dunkin Donuts
West Des Moines
Lost: 5/10/2020
ID: 13978
Name: Samson
Type: Cat
Color: White and orange
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Baby
Last seen on 5/10/2020. Waukee/West Des Moines off of University behind Dunkin Donuts
Linden
Lost: 5/10/2020
ID: 13974
Name: Chucho
Type: Dog
Color: White
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Linden. He took off with my husky
Linden
Lost: 5/10/2020
ID: 13973
Name: Jade
Type: Dog
Color: Red and white
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
Lost from Linden, her chain broke our white pitt took off with her
Des Moines - Central
Lost: 5/10/2020
ID: 13966
Name: Troy
Type: Dog
Color: Black with a little brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Altoona
Lost: 5/10/2020
ID: 13960
Name: Manolo
Type: Dog
Color: Black/Dark Brown
Breed: Belgian Shepherd Malinois
Gender: Male
Fixed: Not Neutered
Age: Adult
Went missing this morning by our house on the corner. Per a neighbor it sounds like someone picked him up in his/her truck. He’s very friendly and we just want him home.
Altoona
Lost: 5/10/2020
ID: 13959
Name: Manolo
Type: Dog
Color: Black/Dark Brown
Breed: Belgian Shepherd Malinois
Gender: Male
Fixed: Not Neutered
Age: Adult
By our house on the corner. Per a neighbor it sounds like someone picked him up in his/her truck. He’s very friendly and we just want him home.
Grimes
Lost: 5/10/2020
ID: 13956
Name: Scratches
Type: Cat
Color: Grey and white
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
She got out last night around 2 or 3 am. I wanna bring her home to my mom she's heart broken
Des Moines - South
Lost: 5/9/2020
ID: 13968
Name: HUNTER
Type: Cat
Color: WHITE/GREY TABBY
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
SOUTHWEST 31ST AND SUMMIT VISTA
Des Moines - East
Lost: 5/9/2020
ID: 13957
Name:
Type: Dog
Color: Tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
Des Moines - South
Lost: 5/9/2020
ID: 13954
Name: Bandit
Type: Cat
Color: White w/ some black spots
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 5/9/2020
ID: 13953
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 5/9/2020
ID: 13951
Name: Adri
Type: Dog
Color: White
Breed: Maltipoo
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Around Corning Ave. Very nice dog will answer to her name
Des Moines - West
Lost: 5/9/2020
ID: 13950
Name: Max
Type: Dog
Color: Black and white
Breed: Alaskan Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
Last time seen at 2am May 10th. Ran out of front door and last seen on ingersoll near Waterbury.
Des Moines - East
Lost: 5/9/2020
ID: 13943
Name: Archie
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Adult
Very nice cat, doesn’t hiss. He is declawed. Lost near Norwoodville
Des Moines - South
Lost: 5/8/2020
ID: 13972
Name: Bandit
Type: Cat
Color: White w/ some black spots
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near Columbus Park on E 1st and Indianola Rd
Des Moines - South
Lost: 5/8/2020
ID: 13971
Name:
Type: Cat
Color:
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Baby
Polk City
Lost: 5/8/2020
ID: 13969
Name:
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
721 Phillips Street in Polk City
Des Moines - East
Lost: 5/8/2020
ID: 13965
Name: Archie
Type: Cat
Color: Black with white piece under neck -
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in home - somehow must of darted out the door - he is real friendly - sneezes all the time - small - cuddly - his mamma misses him.. E32nd and Aurora - Norwoodville area - Daughter got from the ARL - microchipped - not sure if info is updated -
Des Moines - East
Lost: 5/8/2020
ID: 13964
Name:
Type: Cat
Color: White,Carmel,black
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 5/8/2020
ID: 13949
Name: Adri
Type: Dog
Color: White
Breed: Maltipoo
Gender: Unknown
Fixed: Unknown
Age: Adult
North side near North Highschool
Des Moines - North
Lost: 5/8/2020
ID: 13942
Name: Duchess
Type: Cat
Color: Gray/Black
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 5/8/2020
ID: 13932
Name: Makaveli
Type: Dog
Color: Tan with black on his face
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
He is a mini pit very friendly loves food lost him around e 14th and and Cleveland
Ankeny
Lost: 5/6/2020
ID: 14322
Name: The Queen
Type: Cat
Color: light gray/ black
Breed: Tonkinese
Gender: Female
Fixed: Neutered
Age: Adult
The Queen, who is 3 years old, was last seen on May 6th. She is not technically a Tonkinese but looks very similar to one. She has a notch in her left ear to show she is spayed since she was an alley cat when I found her and didn't know if she would stick around because she is so skiddish. She has her nails and is not chipped. She is a surviver and has been gone for up to 4 weeks before and numerous 2 week durations as well. She would never come up to anyone she doesn't know. If you have seen her or know of her where abouts please contact me.
North Liberty
Lost: 5/6/2020
ID: 13939
Name: Fran
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen for sure 5/6 11:30am, possible sighting 5/8 7:30am. Friendly, but likely scared.