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>='1610841600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 7/10/2020
ID: 14506
Name: Appa
Type: Cat
Color: Grey & White
Breed:
Gender: Male
Fixed: Neutered
Age: Adult
Appa is now safely home.
Waukee
Lost: 7/10/2020
ID: 14489
Name: Mia
Type: Cat
Color: Gray and White
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
Mia has vertigo and is on a topical antibiotic for her eye. She is really wobbly on her feet right now. She was at the door meowing the other day and my son let her out. She never came back.
Algona
Lost: 7/10/2020
ID: 14478
Name: Millie
Type: Dog
Color: Red and tan
Breed: Australian Cattle Dog
Gender: Female
Fixed: Neutered
Age: Young
Last seen at Smith Lake Campground area north of Algona. She is a skittish and scared dog
Audubon
Lost: 7/10/2020
ID: 14477
Name: Pixie
Type: Dog
Color: Black and White
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
She is slim and her coat from the winter just blew out so she is not as fluffy as huskys normally are. She is very sweet but scared at first
Audubon
Lost: 7/10/2020
ID: 14476
Name: Keifer
Type: Dog
Color: Grey and White
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Bi-eyed scared of people
Des Moines - South
Lost: 7/10/2020
ID: 14472
Name: Puddles
Type: Cat
Color: Calico
Breed: Calico
Gender: Unknown
Fixed: Not Neutered
Age: Adult
We recently moved to the Southridge area she use to go outside all the time we haven't been letting her out but she ran out last night she is pregnant and we are worried sick
Marengo
Lost: 7/10/2020
ID: 14468
Name: Oreo
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Around J Ave and 170th st in the country out side of Marengo
Dubuque
Lost: 7/10/2020
ID: 14465
Name: Merlina
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Last seen jumping out car window on Hempstead St. The cross road is Kaufmann. Merlina deals with anxiety when out the house which caused her to leap out the car. However, she is a very sweet and friendly cat. Please bring her home to us because we miss her dearly.
Des Moines - South
Lost: 7/10/2020
ID: 14464
Name: Sophie
Type: Cat
Color: Long haired brown tabby w/white chest and paws
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen when I let him out for his usual patio time at 1pm. He has had all his shots within the month. He is shy with strangers and doesn't like to be held/picked up.
Johnston
Lost: 7/9/2020
ID: 14467
Name: Velma
Type: Cat
Color: Gray/white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Near Peckham Street in Johnston
Johnston
Lost: 7/9/2020
ID: 14466
Name: Velma
Type: Cat
Color: Gray/white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly pet, lady seen on Peckham Street in Johnston.
Bevington
Lost: 7/9/2020
ID: 14461
Name: Jimmy
Type: Pig
Color: Black
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Baby
Last seen near bevington park road. Possibly roaming around Bevington/ St Charles
Des Moines - East
Lost: 7/9/2020
ID: 14460
Name: LUNA
Type: Cat
Color: Brown White Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Luna Is lost near E 38th St Des Moines
Des Moines - North
Lost: 7/9/2020
ID: 14458
Name: Slots
Type: Dog
Color: fawn with black face
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Young
escaped from our back yard
West Des Moines
Lost: 7/8/2020
ID: 14492
Name: Neko
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Huxley
Lost: 7/8/2020
ID: 14453
Name: Lexi
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Young
Picked up by two women in a white car by East 5th Street In Huxley Iowa off HWY 69. She recently gave birth and is still nursing.
Glenwood
Lost: 7/8/2020
ID: 14451
Name: Nallah
Type: Cat
Color: Gray, black, tan
Breed: Tabby
Gender: Female
Fixed: Not Applicable
Age: Young
Our home was broken into early this morning guns were taken. They left our basement door open on way out and Nallah got out. Shes an indoor cat so she's never been outside on her own. We just want her home. We miss her.
Des Moines - West
Lost: 7/8/2020
ID: 14448
Name:
Type: Dog
Color: Black, white, a bit buff
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
He's a runner. We've only had him about a week. Bit the 1st day but not since. He's a rat terrier mixed with chihuahua. Has shots. His name is Panther and he likes to hid.
Urbandale
Lost: 7/8/2020
ID: 14447
Name:
Type: Cat
Color: black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
Pleasant Hill
Lost: 7/7/2020
ID: 14441
Name: Sweetpee
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
She has multiple toes on her front two paws she is long haired she is about 4 years old....plz help me bring my sweetpee home
Pleasant Hill
Lost: 7/7/2020
ID: 14439
Name: Sweetpee
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Female
Fixed: Unknown
Age: Baby
Last I seen my sweet girl was last night when she was laying down with me she is 4 years old she is a polydactyl wich is her has multiple toes on her front two paws she is my baby plz help her get home safe
Dubuque
Lost: 7/7/2020
ID: 14438
Name: Odie
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Escaped from home on Alpine near University. Wearing a red harness. Very sweet, responds to Odie. No microchip or tag on harness. He's a large German Shepherd with long black and brown hair and a white fluffy rump.
Urbandale
Lost: 7/7/2020
ID: 14437
Name: Mia
Type: Cat
Color:
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Young
In yard
Des Moines - North
Lost: 7/6/2020
ID: 14432
Name:
Type: Dog
Color: Cream
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
Elkhart
Lost: 7/6/2020
ID: 14425
Name: Harlow
Type: Dog
Color: Reddish Gold
Breed: Nova Scotia Duck-Tolling Retriever
Gender: Female
Fixed: Not Neutered
Age: Baby
She was last seen in our yard the morning she disappeared. She is an extremely friendly dog that is spooked by loud noises.