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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 11/8/2017
ID: 7375
Name: Spot
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Last seen at cambridge and madison friendly family companion loved and missed please help us bring him home
Des Moines - East
Lost: 11/8/2017
ID: 7352
Name: Daisy
Type: Dog
Color: White and Black
Breed: Great Dane
Gender: Unknown
Fixed: Not Applicable
Age: Young
Daisy is a sweet and shy 2 year old female Great Dane. Was last seen North of University Ave areound E 28th Street. Mostly white with black spots.
Des Moines - Central
Lost: 11/7/2017
ID: 7369
Name: Bo
Type: Cat
Color: Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was 15 lbs at his last vet exam (not that I'm expecting someone to weigh him, but to give an idea of his size). The only white spot he has is on his chin, and he does not have his collar. He is not declawed.
West Des Moines
Lost: 11/7/2017
ID: 7359
Name: Smoky or Kitty cat meow face
Type: Cat
Color: Gray striped
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Very friendly, does not respond to name.
Dallas Center
Lost: 11/6/2017
ID: 7393
Name: Atticus
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Wandered off from our acreage in Dallas Center
Harpers Ferry
Lost: 11/6/2017
ID: 7382
Name: Riley
Type: Dog
Color: Brindle
Breed: Mastiff
Gender: Male
Fixed: Neutered
Age: Adult
Riley is 5 years old. He is our house dog. He is seen in the picture with his owner. Thank you for helping him find his way home.
Des Moines - Central
Lost: 11/6/2017
ID: 7360
Name:
Type: Cat
Color: Grey
Breed: Mastiff
Gender: Female
Fixed: Unknown
Age: Adult
11/8 keeps trying to come into my house. Very friendly and very hungry!
Cumming
Lost: 11/6/2017
ID: 7353
Name: Squirt
Type: Cat
Color: Gray with stripes
Breed: Mastiff
Gender: Female
Fixed: Not Neutered
Age: Baby
Super friendly indoor kitten, she is litter trained and escaped the house Monday morning around 0630.
Des Moines - South
Lost: 11/5/2017
ID: 7339
Name: Máximo
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by Lincoln High School
Des Moines - Central
Lost: 11/5/2017
ID: 7328
Name:
Type: Dog
Color: Brown black white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Senior
MLK and university
Des Moines - North
Lost: 11/4/2017
ID: 7396
Name: Oscar
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Escaped out of house on the corner of Madison and Bowdoin.
Bondurant
Lost: 11/4/2017
ID: 7346
Name: Pumpkin
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Very sweet, loved....please help us locate pumpkin.
Des Moines - South
Lost: 11/3/2017
ID: 7458
Name: Mazimus Tank a Bank
Type: Dog
Color: Brown and Black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Young
Southside Walmart when my Rv went up in flames
Des Moines - South
Lost: 11/3/2017
ID: 7457
Name: Smokey psycho Fu Fu Kitty
Type: Cat
Color: Smokey Grey white tuxedo
Breed: American Shorthair
Gender: Female
Fixed: Not Applicable
Age: Young
When my rv went up at Southside Walmart
Des Moines - South
Lost: 11/3/2017
ID: 7456
Name: Oreo
Type: Dog
Color: white black a Little Brown
Breed: Chihuahua
Gender: Unknown
Fixed: Not Applicable
Age: Adult
When my RV Went up at Walmart
Des Moines - East
Lost: 11/3/2017
ID: 7334
Name: Olaf
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Maury Street
Des Moines - Central
Lost: 11/3/2017
ID: 7321
Name: Oeanut
Type: Cat
Color: Orange tabby
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - East
Lost: 11/2/2017
ID: 7302
Name: Buddy
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen by east high school, He jumped out of my car. He is very scared of people
Des Moines - South
Lost: 11/2/2017
ID: 7299
Name: Otis
Type: Dog
Color: Black & white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Madrid
Lost: 11/2/2017
ID: 7298
Name: Tyson
Type: Dog
Color: brown, white chest, brown, tri-colored face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Ty is 7yrs. old, friendly attitude, he wants home & needs help to find his way. Please call with any information.
Chariton
Lost: 11/1/2017
ID: 7320
Name: Cricket
Type: Dog
Color: Red merle
Breed: Australian Shepherd
Gender: Unknown
Fixed: Neutered
Age: Adult
Altoona
Lost: 11/1/2017
ID: 7300
Name: Trouble
Type: Cat
Color: Gray and white
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
Mom and her kitty just moved in with us and he got out Please help us find him lost 5 blocks south of Medicap Pharmacy on 8th street in Altoona
Des Moines - West
Lost: 11/1/2017
ID: 7296
Name: Gilbie
Type: Cat
Color: Black and white
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
58th and Grand Ave.
Des Moines - East
Lost: 10/31/2017
ID: 7781
Name: Baby
Type: Dog
Color: White brindle
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
my dog was took from my back yard and I have not seen her I am so scared where she is or what has happened please i heard a rumor she was at a apt on seneca ave white bldg behind homeplate diner my x took her as i got that answer a few weeks ago please i can prove she is my dog i miss her...called police they cant do anything unless i know where shes located. The girlfriend lives in those apts behind home plate diner off of e14th white bldg his sister lives at 802 county line rd trk242 but my dog hasnt been seen anywhere i hope shes ok and alive. He served restraining order on me so i cant look for her and he stated in it that my dog was his he has no paper work on her i do. I raised her i paid for her vet bills well being he was in prison or living with other people she was at home with me. Shes my dog. Last seen 5 weeks ago michelles bar on e 14th sitting in a white toyota 4 runner misouri plates. Im just sock about it we miss her please someone call if you see my dog
Indianola
Lost: 10/31/2017
ID: 7338
Name: Sparkie
Type: Cat
Color: Orange and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young