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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 11/9/2017
ID: 7363
Name: Fergie
Type: Dog
Color: Brindle
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Senior
30th and shawnee area 50310
Randolph
Lost: 11/8/2017
ID: 7351
Name: Gray
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Still missing
Johnston
Lost: 11/8/2017
ID: 7422
Name: Baby
Type: Cat
Color: Orange and white. Freckles on his nose and white pointed tail
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Chapel Ridge Apartments
Johnston
Lost: 11/8/2017
ID: 7421
Name:
Type: Cat
Color: Orange and white. Freckles on his nose and white pointed tail
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Chapel Ridge Apartments
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