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>='1606262400')) ORDER BY pm1.meta_value DESC, post_date DESC
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
West Des Moines
Lost: 2/4/2020
ID: 13350
Name: JoJo
Type: Dog
Color: White
Breed: Schnauzer
Gender: Unknown
Fixed: Neutered
Age: Adult
She is super sweet and will probably come to you if called by name.
Des Moines - North
Lost: 2/3/2020
ID: 13362
Name: shadow
Type: Cat
Color: black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
skittish around people
Des Moines - East
Lost: 2/3/2020
ID: 13356
Name: Novie
Type: Dog
Color:
Breed: Alaskan Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
She is pretty skeptical of new people so will must likely run if approached.
Des Moines - East
Lost: 2/3/2020
ID: 13355
Name: Novie
Type: Dog
Color:
Breed: Alaskan Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
She was last seen on Vandelia Rd near the fairgrounds. She is pretty skeptical of new people.
Des Moines - East
Lost: 2/3/2020
ID: 13348
Name: “Bob” or “Bobbie Brown”
Type: Dog
Color: Brown w/ White Dapple
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Senior
“Bob” is an old boy who is very skittish to loud noises and voices. He is a very friendly dog who is motivated by food 100%. Bob has deteriorating health due to cancer and has many bumps and tumors on his body. He is a known runner but with the weather and his age we are very worried that he won’t make it home on his own this time.
West Des Moines
Lost: 2/3/2020
ID: 13343
Name: Buddy
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
25th and Woodland Wdm, Contact #515-778-5025, or 515-321-2033
Des Moines - East
Lost: 2/2/2020
ID: 13386
Name: Molly
Type: Dog
Color: Black and White
Breed: Boston Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen near off at 42nd and E Sheridan Ave. She has 8 week old puppies that miss their Mommy. Please call 515-689-3851 if you see her. We want our baby girl back. Very missed by her family and babies.
Des Moines - East
Lost: 2/2/2020
ID: 13339
Name: Molly
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Adult
On our back yard right next to Hoyt.
Des Moines - East
Lost: 2/2/2020
ID: 13336
Name: Molly
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
By Hoyt middle school
Bloomfield
Lost: 2/1/2020
ID: 13353
Name: Sport
Type: Dog
Color: Brown, black and white
Breed: Papillon
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on Mill Street, Bloomfield Iowa. He has seizures from time to time, is elderly and about 7lbs
Winterset
Lost: 2/1/2020
ID: 13346
Name: Track
Type: Dog
Color: Red/Brown
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Healing scar on left front leg. Last seen on Carver Road near Pammel Park
Des Moines - West
Lost: 2/1/2020
ID: 13332
Name:
Type: Dog
Color: White
Breed: Poodle
Gender: Female
Fixed: Unknown
Age: Adult
Found at 31st and Iola
Bloomfield
Lost: 1/31/2020
ID: 13372
Name: Ramsey
Type: Dog
Color: Black with dappled color on chest
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Bloomfield
Lost: 1/31/2020
ID: 13369
Name: Ramsey
Type: Dog
Color: Black with dappled color on chest
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Dissapeared from my home outside of Bloomfield ia, without a trace. It's not normal he doesnt come home..
New Virginia
Lost: 1/30/2020
ID: 13323
Name: Max
Type: Dog
Color: Black
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Adult