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>='1585353600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 2/23/2020
ID: 13432
Name: Teddy
Type: Dog
Color: Orange
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Senior
East DesMoines. I was working outside and wondered off. Def and almost blind.
West Des Moines
Lost: 2/23/2020
ID: 13427
Name:
Type: Dog
Color: Black and white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Young
Found at Frisbee park this morning at 9 am
Des Moines - Central
Lost: 2/22/2020
ID: 13438
Name: Pedro
Type: Dog
Color: Light brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen in the middle of 13th and clark hair is way shorter now
Des Moines - North
Lost: 2/22/2020
ID: 13422
Name:
Type: Dog
Color: Grey, white, brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
I have him with me at my house
Des Moines - Central
Lost: 2/22/2020
ID: 13421
Name: Half Pint
Type: Dog
Color: Golden brown
Breed: Chiweenie
Gender: Male
Fixed: Neutered
Age: Adult
MLK JR pkwy between hickman road and douglas
Eldora
Lost: 2/21/2020
ID: 13418
Name: Spur
Type: Dog
Color: Blue Merle
Breed: Border Collie
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen near Union, IA.
Des Moines - South
Lost: 2/21/2020
ID: 13416
Name: Mattaeo
Type: Dog
Color: White/Black/Brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
SW 9th near Park Ave Elementary
Des Moines - South
Lost: 2/21/2020
ID: 13414
Name:
Type: Dog
Color: Black
Breed: Pug
Gender: Unknown
Fixed: Unknown
Age: Adult
On park and SW 9th was running around with a nother dog Chihuahua male but was only able to rescue her
West Des Moines
Lost: 2/21/2020
ID: 13409
Name:
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Adult
Council Bluffs
Lost: 2/19/2020
ID: 13458
Name: Jayce
Type: Dog
Color: Fawn/Tan
Breed: Greyhound
Gender: Female
Fixed: Neutered
Age: Adult
Car accident around Delong and Sierra. Greyhound bolted from car and headed up into the timbers. We have tried shelters, neighbors, UPS, USPS, posters, driving, walking, etc. No sightings. She is a 7 yr old Female Tan Greyhound with pink collar. She is friendly but has very thin skin and short hair. Will not fare well in this freezing weather. Will get frost bite or worse. Please help us find her asap. Missing since 2/19 - 7 days. Reward.
Cumming
Lost: 2/19/2020
ID: 13408
Name: Nacho Ninja
Type: Cat
Color: Black with bits of white
Breed: Greyhound
Gender: Male
Fixed: Neutered
Age: Adult
He is an indoor cat with declawed from paws.
Creston
Lost: 2/16/2020
ID: 13402
Name: Gear
Type: Dog
Color: Grey
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
Gear was last seen about 1 mile south of Creston near Graceland Cemetary. He was on my mom's property and ran into the tall grass pasture behind her house. He is an American Bully (not bulldog) which many people mistake for a pitbull. He is grey with brindle on his feet, neck, and cheeks. He was not wearing a collar. He is 7 months old and may be nervous and not come to someone he doesn't know but he is VERY sweet and friendly once he warms up.
Des Moines - South
Lost: 2/15/2020
ID: 13403
Name: Jack
Type: Cat
Color: Tabby
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 2/12/2020
ID: 13415
Name: Chubbs
Type: Cat
Color: Grey
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - North
Lost: 2/12/2020
ID: 13394
Name: Callie
Type: Cat
Color: White/grey-calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen before 7pm on the 12th of February. Near 30th and Aurora near lower beaver.
Casey
Lost: 2/12/2020
ID: 13393
Name: Mayzie
Type: Dog
Color: Fawn
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
Ran out the door when we were bringing in firewood. We live a mile southeast of casey
West Des Moines
Lost: 2/12/2020
ID: 13388
Name: Loki
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Loki is shy, but friendly. He loves food and his family is very worried about him. He is not an outdoor cat
Des Moines - South
Lost: 2/11/2020
ID: 13389
Name: Nino Brown
Type: Dog
Color: Copper/Brownish/black highlights
Breed: Toy Fox Terrier
Gender: Male
Fixed: Unknown
Age: Young
Trailer park of the corner of SE. 14th, and Park. On the Southside of Des Moines.
Des Moines - East
Lost: 2/11/2020
ID: 13385
Name: Winston
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Johnston
Lost: 2/9/2020
ID: 13382
Name: Nala
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Young
Waukee
Lost: 2/9/2020
ID: 13381
Name: Munchy
Type: Cat
Color: White with gray stripes
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
She walked out of the garage at prairie grass apartments behind Hy-Vee
Des Moines - Central
Lost: 2/9/2020
ID: 13379
Name: Disco
Type: Dog
Color: Black
Breed: Cane Corso Mastiff
Gender: Male
Fixed: Neutered
Age: Young
White mark on his chest
Johnston
Lost: 2/8/2020
ID: 13482
Name: Nala
Type: Cat
Color: Black and white
Breed: Cane Corso Mastiff
Gender: Female
Fixed: Neutered
Age: Young
Storm Lake
Lost: 2/5/2020
ID: 13360
Name: Oakkey
Type: Dog
Color: Tan/sable
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Blind in one eye
Des Moines - East
Lost: 2/4/2020
ID: 13354
Name: Rex
Type: Cat
Color: White with black and brown stripes
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
On e 28th and Euclid