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>='1579478400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 6/22/2019
ID: 11808
Name: Fuzzy
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Phone number is not what is listed 515-954-6800
Des Moines - East
Lost: 6/22/2019
ID: 11807
Name: Fuzzy
Type: Cat
Color: Gray and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 6/22/2019
ID: 11669
Name: Frank
Type: Cat
Color: Grey tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Frank was last seen in our yard on 19th St in between Center and Pleasant. He did not have his collar on and is not chipped. He is missing some teeth and has a white patch on his chest as well as white feet. He in indoor outdoor and spends most nights outside, but didn't come home the morning of 6/22. We miss him dearly. Please contact us if you've seen him!
West Des Moines
Lost: 6/22/2019
ID: 11658
Name: Simon
Type: Cat
Color: Gray brown , blue eyes
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Senior
Last seen at 1725 S 50th St in WDM. Escaped from townhouse.
Des Moines - Central
Lost: 6/22/2019
ID: 11653
Name: Greta
Type: Dog
Color: White and red
Breed: Cavalier King Charles Spaniel
Gender: Female
Fixed: Unknown
Age: Adult
Scared with storms.
Des Moines - Central
Lost: 6/22/2019
ID: 11652
Name: Turbee
Type: Cat
Color: Torti
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Friendly but very shy. Would likely go to anyone with some food. She is very thin as She is Hyperthyroid and needs daily medication.
Urbandale
Lost: 6/22/2019
ID: 11651
Name: Aceso
Type: Cat
Color: Brown, orange , and black
Breed: Himalayan
Gender: Unknown
Fixed: Neutered
Age: Adult
She can be shy. Lost around urbandale QT on 100th st.
Clive
Lost: 6/22/2019
ID: 11650
Name: Daisey
Type: Dog
Color: Golden
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Senior
I left for a haircut and came back and she had left. She is very calm and shy.
Ankeny
Lost: 6/22/2019
ID: 11649
Name: Kion
Type: Dog
Color: Silver/light brown
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Young
Prairie trail and State street
Burlington
Lost: 6/21/2019
ID: 11643
Name: I don’t know
Type: Dog
Color: Brown and black
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Baby
Two black and brown dogs found on street with collars don’t know owners no name or number on collars
Knoxville
Lost: 6/20/2019
ID: 11768
Name: Bear bear
Type: Cat
Color: Black
Breed: Burmese
Gender: Male
Fixed: Neutered
Age: Adult
Approx mid June Very friendly purrs a lot. Front declawed and neutered. My baby
Atalissa
Lost: 6/20/2019
ID: 11648
Name: KIKI
Type: Cat
Color: White with Black and auburn markings
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Pilot gas station @Atalissa Rd. Kiki is going to be an emotional cat for my autistic daughter. Please help me find her. We are heart broken for Kiki
Des Moines - South
Lost: 6/20/2019
ID: 11644
Name: Peachy
Type: Cat
Color: White peach
Breed: Domestic Medium Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Three lakes pkwy area
Waukee
Lost: 6/20/2019
ID: 11639
Name: Blaire
Type: Dog
Color: Brown and white
Breed: Coonhound
Gender: Female
Fixed: Neutered
Age: Young
5:45
West Des Moines
Lost: 6/20/2019
ID: 11635
Name: Bo
Type: Dog
Color: brown and white
Breed: English Setter
Gender: Male
Fixed: Neutered
Age: Adult
browns woods area
Spirit Lake
Lost: 6/19/2019
ID: 11667
Name: Scooby
Type: Dog
Color: White red
Breed: Shetland Sheepdog Sheltie
Gender: Male
Fixed: Unknown
Age: Adult
Francis sites . Hawn rd spirit lake ia
Wellman
Lost: 6/19/2019
ID: 11634
Name: Arrow
Type: Dog
Color:
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen Tuesday night at our house. He was gone when we got up in the morning. We live out in the country on a dead end road.
Des Moines - South
Lost: 6/19/2019
ID: 11633
Name: Zoey
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
SE 5th and Bell
Des Moines - West
Lost: 6/19/2019
ID: 11628
Name: Kaiser
Type: Dog
Color: Red/brown
Breed: Vizsla
Gender: Male
Fixed: Neutered
Age: Young
50th and Douglas in des moines. Very timid and scared of loud noises
Dubuque
Lost: 6/18/2019
ID: 11754
Name:
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 6/18/2019
ID: 11641
Name: Gypsie
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Female
Fixed: Not Neutered
Age: Young
she was last seen on grand & 22nd, special details of her are she has a beauty mark right by her nose and mouth and she has black patches on her nose and mouth
Des Moines - South
Lost: 6/18/2019
ID: 11638
Name: Mittens
Type: Cat
Color: Grey two toned
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Indianola
Lost: 6/18/2019
ID: 11631
Name: Jethro
Type: Dog
Color: Tan/black with white under belly
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
Around Moats Park on Hwy 65/69 across from Hy-Vee in Indianola
Des Moines - East
Lost: 6/17/2019
ID: 11624
Name: Max
Type: Dog
Color: Blonde/orange
Breed: Pomeranian Standard
Gender: Male
Fixed: Unknown
Age: Senior
Area of Arthur Ave and E 11th is DSM
Estherville
Lost: 6/16/2019
ID: 11711
Name: Roddy
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Neutered
Age: Baby