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
Des Moines - East
Lost: 1/2/2018
ID: 7764
Name: Kimbo
Type: Dog
Color: Black with some gray around mouth
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
By 29th and East Euclid
Des Moines - Central
Lost: 1/2/2018
ID: 7762
Name: Luna
Type: Dog
Color: Red & white
Breed: English Bulldog
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 1/2/2018
ID: 7748
Name: Bear
Type: Dog
Color: Black
Breed: English Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
E 36th st and Dubuque
Ankeny
Lost: 1/1/2018
ID: 8055
Name: Buddy
Type: Cat
Color: Black
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Baby
In our house he got out through the back door and he has never been outside.
Grimes
Lost: 1/1/2018
ID: 7830
Name: test
Type: Rabbit
Color: test
Breed: American
Gender: Male
Fixed: Unknown
Age: Baby
this is just a test.
Des Moines - Central
Lost: 12/31/2017
ID: 7745
Name: Epic
Type: Cat
Color: Medium gray
Breed: American Shorthair
Gender: Female
Fixed: Not Applicable
Age: Adult
5th ave and indianna
Des Moines - North
Lost: 12/30/2017
ID: 7948
Name: Zues
Type: Cat
Color: Tri colored
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Not declawed. Very very nice. He has a cricked back from an accident when he was younger. Hes my sons cat just want him home safe.
Adair
Lost: 12/29/2017
ID: 8648
Name: Hope
Type: Dog
Color: Red Lab
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Lost along I-80 East of Adair near the rest stop. Very personable well trained dog.
Des Moines - South
Lost: 12/29/2017
ID: 7740
Name: Batley
Type: Cat
Color: Black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Rosemont place Apartments Southside des moines. About 4 months old.
Pleasantville
Lost: 12/29/2017
ID: 7723
Name: Dally
Type: Dog
Color: Brown black and white
Breed: Border Collie
Gender: Female
Fixed: Not Neutered
Age: Young
She was last spotted in a field by G40 and HWY 92 she is my sisters dog and we are very worried about her! Please please if anyone has any information contact my sister Kelsie at 515-729-2579
Urbana
Lost: 12/29/2017
ID: 7722
Name: Savage
Type: Dog
Color: black/white/tan
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Young
Our gate wasn't closed properly and they got out around 4:15pm. They are not outdoor dogs, so we are very worried. He originally went missing with his brother Max, but Max was found 01/05/2018, a week after they got loose. Max was found around 3138 56th Street Trail, Center Point, Iowa. This is a gravel road off the Urbana-Shellsburg black top that goes to Vinton. This is about 2 miles from our home. Savage may be sheltering himself in outbuildings around this area as well.
Pleasantville
Lost: 12/29/2017
ID: 7718
Name: Dally
Type: Dog
Color: Tri Color-Black,White, and Brown
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Young
She was last seen running around G40 and Hwy 92 South of town in Pleasantville. She is very friendly but is timid of people she doesn’t know. Please contact Kelsie at 515-729-2579 if you see her or find her! We just want her home safe with us.
Winterset
Lost: 12/28/2017
ID: 7721
Name: Moose
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
2427 Carver Rd, Winterset, IA
Winterset
Lost: 12/28/2017
ID: 7720
Name: Moose
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
At our home 2427 Carver Rd, Winterset, IA.
Altoona
Lost: 12/28/2017
ID: 7716
Name: Wilhelm
Type: Cat
Color: Goldish orange
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen outside on my driveway by neighbors. But not seen since
Des Moines - North
Lost: 12/27/2017
ID: 7711
Name: Zues
Type: Cat
Color: Brown calico
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
We live close to park fare mall. He very timid. Hes usually an outside cat, but brought him for the winter an he was let back out while i was at work.
Washington
Lost: 12/25/2017
ID: 7737
Name: Shelby
Type: Dog
Color: Black/white
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Senior
Last seen by the railroad tracks in Washington by N 12th ave
Pleasant Hill
Lost: 12/25/2017
ID: 7704
Name: Kimber
Type: Dog
Color: Tan and white
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Baby
Near southeast Polk area
Bloomfield
Lost: 12/24/2017
ID: 7719
Name: Nook
Type: Dog
Color: Black and white
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
He is friendly but will most likely not approach you unless he thinks you have food
Des Moines - East
Lost: 12/24/2017
ID: 7694
Name: Jingles
Type: Dog
Color: Black /white chest
Breed: Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
In the Oxford /Ovid area
Ackley
Lost: 12/23/2017
ID: 7746
Name: Majesty
Type: Cat
Color: Gray
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Last seen on State St. in Ackley, Iowa We miss her very much and are very worried about her.
Des Moines - East
Lost: 12/23/2017
ID: 7701
Name: Buddy
Type: Cat
Color: Blonde orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
2615 n.e. 44th ct
Des Moines - East
Lost: 12/23/2017
ID: 7700
Name: Goose
Type: Cat
Color: Black & Brown stripped with White chest
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
He snuck out of our home on Dubuque Ave and 42nd Street
Des Moines - East
Lost: 12/23/2017
ID: 7699
Name: Goose
Type: Cat
Color: Brown and black tiger striped
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly lost around east side of Des Moines maybe around Dubuque and university
Bettendorf
Lost: 12/23/2017
ID: 7692
Name: Stripe
Type: Cat
Color: grey striped
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Was wearing orange break-away as well as a locking blue collar with leash still attached when he got out of my arms at Frozen Landing next to Splash Landing on corner of Middle Rd. and 23rd St. in Bettendorf by Middle Park and west end of Palmer Hills Golf Course.