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>='1552953600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 3/24/2019
ID: 10819
Name: G-lee
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
31st and Woodland. She is very friendly.
Des Moines - East
Lost: 3/24/2019
ID: 10816
Name: Chiquito
Type: Dog
Color: Red and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
He is older now then his picture and may be very dirty has dug many holes in our yard
Des Moines - North
Lost: 3/23/2019
ID: 10813
Name: Rico
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He got out of the house around 11th st/Madison ave between 2 and 4 p.m.
Urbandale
Lost: 3/23/2019
ID: 10812
Name: Cadet
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen as we were unloading the car and bringing stuff into the house. Cadet is an indoor cat and does not usually go outside, therefore has not been chipped. He has all his claws and is normally a very friendly and affectionate cat.
Ankeny
Lost: 3/23/2019
ID: 10811
Name: Bellr
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is a boy, named Belle. Needs prescription cat food. Very sweet and kind. Call Karrie @ 515-238-3200.
Indianola
Lost: 3/23/2019
ID: 10807
Name: Tippy
Type: Cat
Color: White and orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last see. Around East 15th St and East 16th St in Indianola. He is deaf.
Cumming
Lost: 3/23/2019
ID: 10805
Name: Luna
Type: Dog
Color: White
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Young
Last seen west of the interstate in Cummings. She is a five month old Border Collie/Blue Heeler mix. She answers to Luna or Luna Bear.
Des Moines - South
Lost: 3/23/2019
ID: 10804
Name: Simon
Type: Dog
Color: Brown and white
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
He went missing in the Easter lake area this morning and escaped again after finding him.
Des Moines - South
Lost: 3/23/2019
ID: 10801
Name: Simon
Type: Dog
Color: Brown
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
He was last seen around the Easter lake houses
Des Moines - East
Lost: 3/22/2019
ID: 10814
Name: Lola
Type: Cat
Color: Grey mixed tan
Breed: Border Collie
Gender: Unknown
Fixed: Neutered
Age: Young
Last seem in my backyard at 10pm
Des Moines - Central
Lost: 3/22/2019
ID: 10810
Name: Sesi (Seh-See)
Type: Dog
Color: Black, White, brown
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
She is shy of humans but super sweet, loves treats.
Altoona
Lost: 3/22/2019
ID: 10802
Name: Mochi
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Baby
Ankeny
Lost: 3/22/2019
ID: 10793
Name: Tiny
Type: Dog
Color: Brown dark/light
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Baby
Delaware crossing apt.E
Des Moines - West
Lost: 3/22/2019
ID: 10790
Name: Sesi (Seh-See)
Type: Dog
Color: Black, White, Brown
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 3/22/2019
ID: 10787
Name: Chloe
Type: Dog
Color: Blonde
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Applicable
Age: Young
Lost from emma ave on south side of desmoines
West Des Moines
Lost: 3/22/2019
ID: 10781
Name: Avalanche
Type: Dog
Color: White
Breed: Alaskan Husky
Gender: Male
Fixed: Neutered
Age: Young
13th Street, Valley Junction area, Stillwell school
Des Moines - North
Lost: 3/21/2019
ID: 10809
Name: Spike
Type: Cat
Color: Black with white spots
Breed: Alaskan Husky
Gender: Male
Fixed: Neutered
Age: Adult
Much larger now than in photo (He is now 17 lbs)
Leon
Lost: 3/21/2019
ID: 10783
Name: Opal
Type: Other
Color: Brown
Breed: Other
Gender: Unknown
Fixed: Not Neutered
Age: Young
She is pregnant- due to kid in May. I just got her and was unloading when she escaped. She came from 4 hours south.
Iowa City
Lost: 3/21/2019
ID: 10782
Name: Bobo
Type: Cat
Color: tortoise shell - black and orange
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
very friendly, green eyes, will come when offered food
Des Moines - South
Lost: 3/21/2019
ID: 10780
Name: Cricket
Type: Dog
Color: Tri-color
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Left for work-came home and the screen was out of my window and my eleven month old puppy was missing. Speckled face, licks a lot/very friendly.
Des Moines - South
Lost: 3/21/2019
ID: 10779
Name: Unknown
Type: Dog
Color: Black white tan
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Indianola ave and 1st street on south side of Des Moines
Des Moines - Central
Lost: 3/20/2019
ID: 10788
Name: Hershel
Type: Cat
Color: Orange tabby
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Cross streets 16th and College, early morning. Recently moved. Previous residence cross streets Euclid Ave and 12th, may have tried to find his way back there. All claws. Wearing same collar as picture. Sweet, fluffy, timid.
Des Moines - South
Lost: 3/20/2019
ID: 10784
Name: Mia
Type: Cat
Color: Brown, black, and white
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
A friend accidentally let her out thinking she was an outdoor cat but didn’t let us know.
West Des Moines
Lost: 3/19/2019
ID: 10789
Name: Margot
Type: Cat
Color: white bottom, gray/black on top, black mustache on left side of mouth
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
In Valley Junction area of West Des Moines, Iowa Mix of tabby and calico. Calico on bottom and Tabby on back.
West Des Moines
Lost: 3/19/2019
ID: 10765
Name: Mufasa
Type: Cat
Color: Cream
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
I shaved him like a little lion. Last at 562 16th st WDM IA 50265