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
Waterloo
Lost: 4/27/2021
ID: 16556
Name: Theo
Type: Cat
Color: White/ buff
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
I opened my garage door to unload my car and he slipped out behind me..
Mason City
Lost: 4/26/2021
ID: 16622
Name: Silver
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly and lazy. Front declawed. North Washington & 14th ST NW
Ankeny
Lost: 4/26/2021
ID: 16566
Name: Shadow
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
Shadow is an indoor older cat who is probably scared right now. He’s never gotten out before, please help us find him.
Johnston
Lost: 4/26/2021
ID: 16554
Name: Baby
Type: Dog
Color: Tan and White
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Young
Baby was last seen on Merle Hay Rd and 62nd Running towards Wallace Elementary - she still had her black and red dog leash attached to her pink color. Baby is very timid but is not know to bite. She is an emotional service animal for a 6 yr old girl- Baby also was scheduled to see the Vet on Merle Hat Rd early morning 4-27-2021. It is dire baby sees the vet and is safely returned to a vet or home !!
Storm Lake
Lost: 4/26/2021
ID: 16551
Name: Gooby
Type: Dog
Color: Brown with black
Breed: Mix
Gender: Male
Fixed: Not Applicable
Age: Young
Pleasant Hill
Lost: 4/26/2021
ID: 16549
Name: Buddy
Type: Cat
Color: Black, gray and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Around Sunrise Circle in Pleasant Hill super friendly but scared.
Jesup
Lost: 4/25/2021
ID: 16619
Name: Millie
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Millie is our neighborhood mouser who has become a beloved pet. In three years, she has never left our vicinity.
Jesup
Lost: 4/25/2021
ID: 16618
Name: Millie
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Millie is our neighborhood mouser who has become a beloved pet. In three years, she has never left our vicinity.
Jesup
Lost: 4/25/2021
ID: 16617
Name: Millie
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Millie is our neighborhood mouser who has become a beloved pet. In three years, she has never left our vicinity.
Des Moines - South
Lost: 4/25/2021
ID: 16547
Name: Lenny
Type: Cat
Color: B&W
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Lost: 4/25/2021
ID: 16540
Name: Luka
Type: Dog
Color: grey, blonde, white.
Breed: Alaskan Husky
Gender: Male
Fixed: Not Neutered
Age: Young
urbandale avenue. let him out to use the restroom and he ran off.
Muscatine
Lost: 4/25/2021
ID: 16539
Name: Yuka and Yura
Type: Dog
Color: Black and White (one has blue eyes and the other is blue and brown)
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Baby
951 Whicher St - please call 5632606804 or 5632609803
Muscatine
Lost: 4/25/2021
ID: 16538
Name: Yuka and Yura
Type: Dog
Color: Black and White (one has blue eyes and the other is blue and brown)
Breed: Siberian Husky
Gender: Unknown
Fixed: Neutered
Age: Young
951 Whicher St
Des Moines - Central
Lost: 4/24/2021
ID: 16576
Name: Bentley
Type: Dog
Color: black brindle, white chest
Breed: French Bulldog
Gender: Male
Fixed: Unknown
Age: Young
Carlisle
Lost: 4/24/2021
ID: 16564
Name: Ruby Gray
Type: Cat
Color: Gray on gray...beige belly
Breed: French Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
140th Ave Near Countyline Road
Des Moines - West
Lost: 4/24/2021
ID: 16537
Name: Bella
Type: Dog
Color: Fawn and white
Breed: Bulldog
Gender: Female
Fixed: Neutered
Age: Young
Escaped our house at 535 Country Club Blvd, Des Moines
Des Moines - East
Lost: 4/23/2021
ID: 16567
Name: Jesse
Type: Cat
Color: White colored tiger with white eyeliner
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Senior
E. 28th St. between Euclid and Douglas Avenue on the north east side
Des Moines - East
Lost: 4/23/2021
ID: 16535
Name: Marvin
Type: Dog
Color: Brown / red mahogany/ white
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
Last seen around home at 4320 NE 23rd Ave. Des Moines, IA 50317 and Easton Blvd & 42nd St.
Runnells
Lost: 4/22/2021
ID: 16771
Name:
Type: Cat
Color: black and white. 4 white paws
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
friendly and curious. Name is Boots.
Runnells
Lost: 4/22/2021
ID: 16770
Name:
Type: Cat
Color: black and white. 4 white paws
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
friendly and curious. Name is Boots.
Runnells
Lost: 4/22/2021
ID: 16542
Name: Boots
Type: Cat
Color: black and white. 4 white paws
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 2 miles NE of Runnells. May have traveled west up to 7 miles on an equipment trailer. Very friendly.
Des Moines - East
Lost: 4/22/2021
ID: 16536
Name: Buttercup
Type: Cat
Color: Orange (ginger)
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Lost on 3200 block of State Ave - one block north of fairgrounds. She's 8 months old, very feisty, plays hard with biting/scratching, likes playing catch with paper balls, doesn't like to be held or petted much, and gas a big fluffy tail.
Waterloo
Lost: 4/22/2021
ID: 16534
Name: Sylvester
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Very talkative and probably scared
Des Moines - East
Lost: 4/22/2021
ID: 16532
Name: Dino
Type: Dog
Color: Black and brown
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen yesterday around 4pm on the east side of Des Moines
Waterloo
Lost: 4/22/2021
ID: 16530
Name: Bob Marley
Type: Dog
Color: Brown two tone tan and white
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around Hammond Ave from Grant Avenue towards Covenant Hospital. Please if find call 3192316158.