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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 7/4/2015
ID: 950
Name: Maximums (Max)
Type: Dog
Color: grey
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by Walgreen and then the subway by the old dahls. He broke his collar off. if you so much as just see him please call or text me! He might be hungry oe thirsty.
Des Moines - East
Lost: 7/4/2015
ID: 938
Name: Buster
Type: Dog
Color: Black, White, Tan
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Trotting North on 3316 E. 52nd Street, Des Moines, 50317
Johnston
Lost: 7/4/2015
ID: 936
Name: Dipper
Type: Cat
Color: black with white paws/belly
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 11 p.m. on July 4. He is friendly and he's used to being outside. He might have been scared by fireworks.
Redfield
Lost: 7/4/2015
ID: 931
Name: Duke
Type: Dog
Color: white/yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 6 miles west of Redfield, someone said spotted near Dexter but not positive.
Des Moines - East
Lost: 7/4/2015
ID: 926
Name: Honey
Type: Dog
Color: Light brown with white belly
Breed: English Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
Escaped fenced yard with other dog pictured. At around 4:00 pm around east 39th street in Des Moines. Extremely missed and loved please help
Pleasant Hill
Lost: 7/4/2015
ID: 920
Name: Coco
Type: Dog
Color: Blonde with Black in beard
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Young
She was scared by fireworks and ran off. No collar on.
Des Moines - South
Lost: 7/4/2015
ID: 916
Name: Bear
Type: Dog
Color: Brown
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Bear was last seen in our backyard around 6:30pm on the 4th of July. He was not wearing a collar.
Des Moines - East
Lost: 7/3/2015
ID: 914
Name:
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 7/1/2015
ID: 967
Name: Toby
Type: Dog
Color: Light brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Toby is an adult male puggle. He got loose from a house that is back behind the QT on 2nd Avenue. He is very friendly and probably does not have his collar on.
Adair
Lost: 7/1/2015
ID: 941
Name: Boshi
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
****Western Iowa***** lost at second rest area if heading east on 80 through the state. Name is boshi but no collar. Very deep Amber eyes. Please share this. He is the world to my daughter and I. If you have him or find him let me know here. Thank you so much.
Des Moines - East
Lost: 7/1/2015
ID: 891
Name: gizzie
Type: Dog
Color: black with some white around nose and mouth
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Senior
hes half pomerainon,half poodle hes got on a black tshirt with lil paw prints on the back
Des Moines - East
Lost: 6/29/2015
ID: 901
Name: Mija Vazquez
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
Des Moines - North
Lost: 6/29/2015
ID: 868
Name: Bonnie
Type: Dog
Color: light brown with just a little black on her back
Breed: Hound
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 6/28/2015
ID: 856
Name:
Type: Dog
Color: Dark Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 6/28/2015
ID: 855
Name: Boots
Type: Cat
Color: Gray
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on the morning of 6/28. Gray body with white tuxedo. Responds to boots. He is very large, and very friendly. Declawed in the front. Missed terribly. If found, please call or text 515/664-0374
Des Moines - North
Lost: 6/28/2015
ID: 852
Name: kazi
Type: Dog
Color: brown
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Young
She weighs 20 pounds and won't bite. She is still puppy. She is fast at getting away so grab her if you can.
Des Moines - South
Lost: 6/27/2015
ID: 848
Name: Tiny
Type: Dog
Color: Greyish
Breed: Poodle
Gender: Female
Fixed: Unknown
Age: Adult
She got out of back yard. She's a very nervous dog. Please call if you seen her.
Johnston
Lost: 6/26/2015
ID: 886
Name: BUFFY
Type: Cat
Color: BUFF - LIGHT TAN
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Des Moines - Central
Lost: 6/26/2015
ID: 842
Name: Pixie
Type: Cat
Color: Multi
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Missing from home 6/26 at 307 Diehl Ave. Also responds to catdog as he is an indoor/outdoor (farm) cat. Very loved and missed. He will talk to you and responds very well to Hello. Has front de-clawed. Can leave a message or text at 783-4495 if found.
Des Moines - South
Lost: 6/25/2015
ID: 827
Name: Aura
Type: Dog
Color: Pure white - FYI she is deaf!
Breed: Siberian Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
I haven't had any updates on her now for atleast 8 hours. ARL does not have her but does have my info. I ask that anyone call me or text me even if you see a white dog but not too certain it's her. Thank u!
Des Moines - South
Lost: 6/25/2015
ID: 826
Name: Aura
Type: Dog
Color: Pure white
Breed: Siberian Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
On sw. 14th and watrous
Dubuque
Lost: 6/22/2015
ID: 935
Name: GRACIE
Type: Dog
Color: BRINDLE & WHITE
Breed: Shih Tzu
Gender: Female
Fixed: Not Neutered
Age: Baby
LAST SEEN IN BROOKLYN PARK MINNESOTA- POLICE SUSPECT DOG MAY HAVE BEEN STOLEN - PLEASE CONTACT OWNER WITH ANY INFORMATION @ 612-412-7459
Des Moines - North
Lost: 6/22/2015
ID: 808
Name: Bubbles
Type: Dog
Color: Brown, black, white
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Young
Beaverdale, iowa.she loves to run and is fast.
Des Moines - East
Lost: 6/22/2015
ID: 807
Name: Primo
Type: Dog
Color: White with black markings
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Young
E 15th and University, taken off front porch
Des Moines - East
Lost: 6/21/2015
ID: 880
Name: captain kittie
Type: Cat
Color: orange/white
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult