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
West Des Moines
Lost: 5/20/2020
ID: 14298
Name: Ralph
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 5/20/2020! Ralph has a noticeable half blind RIGHT eye, it’s a yellowish color compared to his left eye which is green! He has a tiny white patch on his belly otherwise he’s ALL solid grey . He has been missing for a month and we need him home!! He IS neutered, not microchipped and has no collar.
Perry
Lost: 5/20/2020
ID: 14059
Name: Lulu
Type: Dog
Color: Tan
Breed: Shih Tzu
Gender: Unknown
Fixed: Neutered
Age: Senior
On west 3rd street in Perry.
Marion
Lost: 5/20/2020
ID: 14054
Name: Hazel
Type: Cat
Color: Black/White Tuxedo
Breed: Tuxedo
Gender: Female
Fixed: Not Applicable
Age: Young
Hazel was last seen around Hunters Creek Way/Winslow Rd in N Marion. Hazel back paws are white “boots”
Ankeny
Lost: 5/20/2020
ID: 14047
Name: Britney
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Young
She’s very friendly. She has allergies so she wheezes a bit.
Altoona
Lost: 5/20/2020
ID: 14046
Name: Phillip
Type: Cat
Color: Black with stripes
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
We just moved to Altoona and he is not a cat that goes outside we live by target
Des Moines - Central
Lost: 5/20/2020
ID: 14043
Name: Sin-Sin
Type: Dog
Color: Black with a white face
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Applicable
Age: Senior
Went outside to go potty behind 687 32nd Street house that she lives at. Near the Drake area.
Des Moines - West
Lost: 5/20/2020
ID: 14040
Name: Megatron
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Cummins Pkwy just south of University in DSM. Wearing a collar with a bell.
Farmersburg
Lost: 5/19/2020
ID: 14067
Name: Malibu
Type: Dog
Color: White with brendel stripes
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen Near Giard on Iris ave near rail road tracks Please Call 563-880-8482
Monona
Lost: 5/19/2020
ID: 14066
Name: Malibu
Type: Dog
Color: white with Brendel stripes
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen near Giard on Iris ave near Rail road tracks Please call 563-880-8482
Marquette
Lost: 5/19/2020
ID: 14065
Name: Malibu
Type: Dog
Color: White with Brendel stripes
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on Iris Ave near Giard near rail road track on Iris Ave Please call 563-880-8482
McGregor
Lost: 5/19/2020
ID: 14064
Name: Malibu
Type: Dog
Color: White and Brendel stripes
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in Giard area on Iris Ave rail road tracks Please Call 563-880-8482
Avoca
Lost: 5/19/2020
ID: 14060
Name: Amy
Type: Cat
Color: Multicolor
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Escaped from car at FlyingJ truck stop off I-80 in Avoca. Scared but friendly.
Des Moines - North
Lost: 5/19/2020
ID: 14045
Name: Kobi
Type: Dog
Color:
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 5/19/2020
ID: 14042
Name: Dexter
Type: Cat
Color: Tabby.brown-gray.
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
did not come in this AM. This is my brothers cat. he is a large tabby. He has 2 matted areas in front of his tail I have not yet cut out. Rather shy, not very friendly towards strangers.
Des Moines - North
Lost: 5/19/2020
ID: 14038
Name: Patron
Type: Dog
Color: Gray
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Not Applicable
Age: Adult
Last seen around 9pm. Very friendly.
Urbandale
Lost: 5/19/2020
ID: 14035
Name: Rugby
Type: Dog
Color: golden
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
Carlisle
Lost: 5/19/2020
ID: 14034
Name: Jack
Type: Dog
Color: Tan and black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Young
Jack slipped out the door when getting ready for bed tonight. He is 4.5lbs, 1.5yrs old and very friendly. He is wearing a collar but no tags.
Des Moines - South
Lost: 5/19/2020
ID: 14031
Name: Garfunkel
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Tuesday morning around 9. I also call her Garf or Garfie. She is scared of strangers, but she is so important to me, please keep an eye out for her.
Ankeny
Lost: 5/18/2020
ID: 14118
Name: Duke
Type: Cat
Color: Black with a couple white spots
Breed: Bombay
Gender: Male
Fixed: Neutered
Age: Adult
Duke turned 10 years old on May 29th
Ankeny
Lost: 5/18/2020
ID: 14063
Name: Duke
Type: Cat
Color: Black with white on the chest and paws.
Breed: Bombay
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 11:30 PM of Sunday Night. Tended to be more paranoid of people he doesn't know so may just run. Very good at climbing trees and enjoyed doing it. May be treed somewhere.
Des Moines - South
Lost: 5/18/2020
ID: 14029
Name: Bella
Type: Dog
Color: White black and gray
Breed: Siberian Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
Her collar came undone , she went running around carman estate apartments the new complex on porter Ave 50320
Des Moines - South
Lost: 5/17/2020
ID: 14070
Name: Tac
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near Union and Kenyon in the wooded area along the creek.
Des Moines - South
Lost: 5/17/2020
ID: 14069
Name: Tac
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near Union and Kenyon in the wooded area along the creek.
Iowa City
Lost: 5/17/2020
ID: 14032
Name: Lilac
Type: Cat
Color: Cream, lilac / grey - blue eyes
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Senior
Slipped out the door - is an indoor cat. Microchip may have our old address from Dyersville as we may have forgotten to update it
Altoona
Lost: 5/17/2020
ID: 14022
Name: Lyla
Type: Cat
Color: Dark brown
Breed: Norwegian Forest Cat
Gender: Female
Fixed: Neutered
Age: Young
Sunday morning