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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Mitchellville
Lost: 10/17/2018
ID: 9812
Name: Scarlett
Type: Dog
Color: Black/tan
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Baby
Mitchellville area
Des Moines - East
Lost: 10/16/2018
ID: 9827
Name: Twizzler
Type: Cat
Color: black, brown, gold
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
indoor outdoor cat, 5 months old,
Des Moines - Central
Lost: 10/16/2018
ID: 9811
Name: Emilio Rodriquez
Type: Cat
Color: White with dark gray Siamese markings
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
By six Avenue and Franklin in Des Moines
Cumming
Lost: 10/15/2018
ID: 9829
Name: Harvey
Type: Cat
Color: Tan
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 10/15/2018
ID: 9816
Name: Oliver
Type: Cat
Color: orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Live over by the fairgrounds . He is a very mellow cat and very loving .
Des Moines - Central
Lost: 10/15/2018
ID: 9802
Name: Missy B
Type: Cat
Color: Black with white paws and underside
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
last seen in the drake neighborhood, Missy B is older and may be confused. She has been a housecat for 14 years and is not used to being outdoors.
Ankeny
Lost: 10/15/2018
ID: 9799
Name: Zoey
Type: Dog
Color: Gray
Breed: Schnauzer Miniature
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in our yard, shortly after noon
Des Moines - West
Lost: 10/14/2018
ID: 9794
Name: Business
Type: Cat
Color: Gray with white on chest and feet
Breed: Schnauzer Miniature
Gender: Female
Fixed: Unknown
Age: Adult
Lost on 10/02/2018. Her collar might be off since it is a breakaway.
Sioux City
Lost: 10/13/2018
ID: 9848
Name: Sadie
Type: Dog
Color: Reddish Brown with Some Black
Breed: Tibetan Spaniel
Gender: Female
Fixed: Unknown
Age: Adult
Missing since Saturday 10/13/18 Sadie is a Tibetan Spaniel. She looks similar to a Pekinese. Small – about 12 pounds. $100 reward for safe return Last seen Sioux City and North Sioux City Area. She went missing at 1250 W. Flurie Rd, Dakota Dunes, SD 57049 Please call Sandy at 712-490-3030 Sadie is lost and very scared. Please help us find her.
Des Moines - South
Lost: 10/13/2018
ID: 9793
Name: Red
Type: Dog
Color: Brown/red
Breed: Red Heeler
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on SW 16th street My 2 year old daughters misses her puppy!
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