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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 10/12/2018
ID: 9798
Name: Maui
Type: Cat
Color: White with big black spots, black tail, black on head
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
A home body,a big scardy cat, always hung out in back yard. A really good boy.
Des Moines - East
Lost: 10/12/2018
ID: 9791
Name: Gizmo
Type: Dog
Color: White/ brownish Tan spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Young
I let him out potty on E University Ave towards Altoona and he hasn't returned. He should be wearing his blue sweater.
Des Moines - South
Lost: 10/12/2018
ID: 9790
Name: Teddy
Type: Dog
Color: Brown/Black
Breed: Norwegian Elkhound
Gender: Male
Fixed: Not Neutered
Age: Young
SW 14 and Maish ave
Des Moines - North
Lost: 10/12/2018
ID: 9789
Name: Dingo
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 10/12/2018
ID: 9788
Name: Dingo
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
Altoona
Lost: 10/12/2018
ID: 9787
Name: Star
Type: Dog
Color: Black & white
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around Centennial Elementary in Altoona. She broke her leash and it is still on her. She has a white chest, some of her toes are white and a little white around her nose.
Des Moines - Central
Lost: 10/12/2018
ID: 9781
Name: Charlie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
He had his red shirt on.
Indianola
Lost: 10/11/2018
ID: 9807
Name: Marvin
Type: Dog
Color: Cream
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on our acreage south of indianola.
West Des Moines
Lost: 10/11/2018
ID: 9780
Name: Atika
Type: Dog
Color: Cream & gray
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Young
Last seen on Ashworth and 13th, but someone spotted her morning of 10/12 by woodland cemetery
Des Moines - South
Lost: 10/11/2018
ID: 9779
Name: Sophie
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
She was last seen at our home by the blank park zoo. She is extremely friendly so do not be afraid to approach her. Please call me at(804) 683-3536 if you believe to have seen my beloved sophie. Any information is good information in bringing her home.
Polk City
Lost: 10/11/2018
ID: 9776
Name: Nala
Type: Dog
Color: Tan
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Small tan dog very friendly
Des Moines - North
Lost: 10/11/2018
ID: 9770
Name: Lady
Type: Dog
Color: Black with a little bit of white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
She doesn’t know the neighborhood and we’re really worried about her
Des Moines - North
Lost: 10/11/2018
ID: 9769
Name: Lady
Type: Dog
Color: Black with a little white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
We’re really worried about her it’s getting cold and she doesn’t know the neighborhood
Des Moines - South
Lost: 10/10/2018
ID: 9763
Name: Harleigh
Type: Dog
Color: Brown/white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Baby
10:30 on 10/10/18 got out of our fenced gate, she is 1 year old and very friendly
Des Moines - South
Lost: 10/10/2018
ID: 9761
Name: Toby
Type: Dog
Color: Brownish/Grey
Breed: Basset Hound
Gender: Male
Fixed: Neutered
Age: Senior
10:30 Am on 10/10/18 got out of our gated fence, older dog and very friendly
Booneville
Lost: 10/9/2018
ID: 9775
Name: Socks
Type: Cat
Color: Black & White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Socks is declawed and a very friendly cat. He was last seen on Tuesday 10/9/18. If called he will come to you.
Yale
Lost: 10/9/2018
ID: 9774
Name: Little Kitty
Type: Cat
Color: Grey and Brown
Breed: Maine Coon
Gender: Female
Fixed: Not Neutered
Age: Baby
On North Main Street in Yale
Nevada
Lost: 10/9/2018
ID: 9764
Name: Sydney
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Last seen running west towards Almaco factory. Sydney is an indoor cat and very frightened outside. He may be hiding and may run from you.
Des Moines - East
Lost: 10/9/2018
ID: 9757
Name: Sully
Type: Cat
Color: Gray tiger stripped
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
Around 4 PM. She got out of my front door & took off into my neighbor's yard which is overgrown. She's front declawed & chipped.
Pleasant Hill
Lost: 10/9/2018
ID: 9756
Name: Milo
Type: Dog
Color: Black and White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
This morning at 9am and Milo has like a 3 leaf clover mark on his face
Winterset
Lost: 10/8/2018
ID: 9768
Name: Willy
Type: Dog
Color: Black & Gray
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Traveling with yellow lab - Booner
Winterset
Lost: 10/8/2018
ID: 9767
Name: Booner
Type: Dog
Color: Yellow
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 10/8/2018
ID: 9747
Name: Rose
Type: Dog
Color: Light brown, dark brown, gray
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Last seen on 15th st and Seneca. She is very timid and scared of everything. If you have a small kennel. She may go into it.
Des Moines - North
Lost: 10/8/2018
ID: 9746
Name: Rose
Type: Dog
Color: Light brown, dark brown, gray
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Last seen on 15th st and Seneca. She is very timid and scared of everything. She has long hair.
Des Moines - Central
Lost: 10/8/2018
ID: 9743
Name:
Type: Cat
Color: Black with White Boots
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Adult
Yellow eyes, one looks to be blind. He seems healthy, but is looking for a home and wants to be out of the rain. He is a very friendly and vocal cat and isn't afraid to hang out with strangers. DSM Animal License: 18470 Vax tag: 951112 He hangs around our apartments in the Sherman Hills area.