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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 8/22/2017
ID: 6552
Name: Bolt
Type: Cat
Color: Gray
Breed:
Gender: Male
Fixed: Unknown
Age: Young
Found at the Dowling track on 8/22.
Windsor Heights
Lost: 8/22/2017
ID: 6548
Name: Bolt
Type: Cat
Color: Gray
Breed:
Gender: Male
Fixed: Unknown
Age: Young
Found at the Dowling track on 8/22. Taking to ARL on E 14th St.
Ankeny
Lost: 8/21/2017
ID: 6598
Name: Pickles
Type: Dog
Color: White-Brown
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Baby
Wood Spring Suite's extended stay hotel..
Ankeny
Lost: 8/21/2017
ID: 6597
Name: Pickles
Type: Dog
Color: White-Brown
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Around the Wood Spring Suites extended stay
Johnston
Lost: 8/21/2017
ID: 6561
Name: Freddie
Type: Cat
Color: Black and white Tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Last seen at Adam Ridge Condos at 8:00PM on Monday, August 21, 2017. He was on our patio and jumped to the ground, probably to chase an animal. We combed the entire apartment complex and called for him, but he must have been too afraid or too far away to respond. Very friendly and playful and a very tall, handsome boy. He loves raw meat. Sometimes he bites out of love. Please call (319) 427-1582 if you have any information. He's our baby and we miss him :'(
Des Moines - East
Lost: 8/21/2017
ID: 6556
Name: Goldie
Type: Dog
Color: Golden brown
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Adult
Very friendly and happy
Des Moines - East
Lost: 8/21/2017
ID: 6555
Name: Shadow
Type: Dog
Color: Black with white neck
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly and happy
West Des Moines
Lost: 8/20/2017
ID: 6538
Name: Milo
Type: Cat
Color: Gray
Breed: Mix
Gender: Unknown
Fixed: Not Neutered
Age: Young
165 80th street unit number 102 west des moines
Ankeny
Lost: 8/19/2017
ID: 6573
Name: Hope
Type: Cat
Color: Light brown, white, black, dark brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Baby
Last seen S.E. Grant St Ankeny, IA it's not like Hope to just run off. When she went missing is Saturday August 19th. I'm very worried and I KNOW that there's people in our neighborhood that HATES CATS. We know that one of them shoots at animals and another neighbor has put poison out.... I LOVE MY BABY GIRL and I want her home safe and sound. Even if she's found...... Dead.... I want to know. She's a short haired brown tabby. Name: Hope Yes she's microchipped. She's a loving cat and I just want her to be home. The other two cats refuse to come inside. One of them barley goes outside and is refusing to go inside. They'll leave in the morning and come back around four. As if they went looking for something. It has to be Hope that they're looking for because I've never seen them refuse to come inside.
Osceola
Lost: 8/19/2017
ID: 6566
Name: Ryker
Type: Dog
Color: Brown
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
By 1500 Highway 69, got out of his collar. Has tan spots, BorderCollie/German Shepard mix
Des Moines - North
Lost: 8/19/2017
ID: 6543
Name: Cheez-Wiz
Type: Cat
Color: black and white
Breed: Tuxedo
Gender: Female
Fixed: Not Neutered
Age: Young
Cheez shoved her way out the window last night, most likely because she saw something she wanted to go after - its the ONLY reason she would have escaped - so she may be hurt. The stormy weather over the last few days hasn;t helped either, as shes an indoor cat and hates thunder and being wet. Please help us. Shes probably very frightened. Lost near the Merle Hay Mall at 50th and Aurora.
Des Moines - East
Lost: 8/19/2017
ID: 6530
Name: Cooper
Type: Dog
Color: Brown leather
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen at NE 23rd ave.
Johnston
Lost: 8/18/2017
ID: 6535
Name: Kush
Type: Cat
Color: black / white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Baby
last seen on 86th on douglas in johnston iowa. He has a white spiral on his chin, one of his paws has black on the foot
Des Moines - East
Lost: 8/18/2017
ID: 6525
Name:
Type: Dog
Color: Tan and White
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Adult
Quick google search, I think it's a Boston terrier. very small and wiggly! Cropped tail. No tags on collar. Found on E 22nd street, we'll be trying to get him to the ARL so his family can come get him.
Indianola
Lost: 8/18/2017
ID: 6523
Name: Fella
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Indianola
Lost: 8/18/2017
ID: 6522
Name: Steve
Type: Cat
Color: Orange/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Indianola
Lost: 8/18/2017
ID: 6521
Name: Fella
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Urbandale
Lost: 8/18/2017
ID: 6516
Name: Naughts
Type: Dog
Color: Tan and brindle
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
64th and urbandale ave
Des Moines - East
Lost: 8/18/2017
ID: 6506
Name: Boss aka Bossy
Type: Dog
Color: Blue/dark grayish
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Applicable
Age: Adult
Very trusting. He is very friendly .has food and skin allergies. Has a special dietx
Des Moines - East
Lost: 8/17/2017
ID: 9229
Name: Foo-foo
Type: Cat
Color: Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 8/17/2017
ID: 9174
Name: Spunky
Type: Dog
Color: None
Breed: Pinscher-Miniature
Gender: Male
Fixed: Not Neutered
Age: Senior
He’s been missing for a really long time... I was just hoping if someone did happen to have him I could get some closure. I had him for 10 years and one day he was just gone. I miss him very much and would love to see him, even if it were just a goodbye.
Des Moines - Central
Lost: 8/17/2017
ID: 8483
Name: Spunky
Type: Dog
Color: Black and brown
Breed: Pinscher-Miniature
Gender: Male
Fixed: Unknown
Age: Baby
I know it’s been a long time, we all miss him so much. If you see him please alert me immediately.
Carroll
Lost: 8/17/2017
ID: 6574
Name: Piper
Type: Cat
Color: White/orange/black
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Piper was let out of her residence at 3:00 am on Thursday 8/17/2017 in Carroll, Iowa. This was her routine and she would always return home by 6:30 am to our front step. She did not return that same morning and has not been seen since. She is 9 years old and very friendly - she will go up to anyone.
Des Moines - East
Lost: 8/17/2017
ID: 6571
Name: Spunky
Type: Dog
Color: Black and Brown (some grey hairs)
Breed: Calico
Gender: Male
Fixed: Not Neutered
Age: Senior
He is super sweet even though he barks to act tough. He will not bite, but he might nip if you pick him up because he has bad back legs. But he's super nice. The picture is bad and kind of old. Sorry. If you find him please contact me.
Des Moines - East
Lost: 8/17/2017
ID: 6570
Name: Spunky
Type: Dog
Color: Black and Brown (some grey hairs)
Breed: Calico
Gender: Male
Fixed: Not Neutered
Age: Senior
He is super sweet even though he barks to act tough. He will not bite, but he might nip if you pick him up because he has bad back legs. But he's super nice. The picture is bad and kind of old. Sorry. If you find him please contact me.