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>='1568505600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 9/20/2019
ID: 12397
Name: Hugo
Type: Dog
Color: Brindle
Breed: Mastiff English
Gender: Male
Fixed: Neutered
Age: Adult
Arthur Ave, Des Moines
Des Moines - North
Lost: 9/20/2019
ID: 12396
Name: Hugo
Type: Dog
Color: Brindle
Breed: Mastiff English
Gender: Male
Fixed: Neutered
Age: Adult
Arthur Ave Des Moines
Pleasant Hill
Lost: 9/20/2019
ID: 12394
Name: Coco
Type: Dog
Color: Brown
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 9/20/2019
ID: 12392
Name: Syn
Type: Dog
Color: Female
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
Last seen in the area of SE5th and McKinley
Norwalk
Lost: 9/19/2019
ID: 12389
Name: Thir
Type: Dog
Color: Black.. getting grey
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Senior
About 9:30 on
Des Moines - East
Lost: 9/19/2019
ID: 12387
Name: Sky
Type: Bird
Color: Blue/grey
Breed: Quaker Parakeet
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen around E12th st. Sky has a silver collar on her right leg
Ankeny
Lost: 9/18/2019
ID: 12385
Name: CoCo
Type: Cat
Color: Tortoiseshell, black and tan
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Chip is not registered. Strictly indoor cat, she's probably scared.
Des Moines - Central
Lost: 9/18/2019
ID: 12380
Name: Jazzmine
Type: Dog
Color: Black and White and Brown
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Adult
In my yard at 4060 ne 46th st...
Des Moines - Central
Lost: 9/18/2019
ID: 12379
Name: Kyia
Type: Dog
Color: Gray and Black
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen in my yard at 4060 Ne 46th st...
Des Moines - East
Lost: 9/18/2019
ID: 12378
Name: Crash
Type: Dog
Color: Brown, black and white
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Young
Last seen by Garton Elementary! He is a very friendly dog, that loves people but does not like bicycles!
Cedar Rapids
Lost: 9/17/2019
ID: 12382
Name: Dixie
Type: Dog
Color: Reddish brown
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
Needs her meds!
Des Moines - West
Lost: 9/16/2019
ID: 12358
Name: Meesha
Type: Cat
Color: Black with white belly
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
Douglas ave and 53rd. New house so she probly scares. Loves people and is super sweet
Urbandale
Lost: 9/15/2019
ID: 12369
Name: Frostie
Type: Cat
Color: Black/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
92nd & Tanglewood dr in Urbandale- he loves to be outside and hunt in the woods.
Des Moines - East
Lost: 9/15/2019
ID: 12354
Name: Daisy
Type: Dog
Color: Tri colored
Breed: Basset Hound
Gender: Unknown
Fixed: Neutered
Age: Senior
E14th and Vine
Des Moines - Central
Lost: 9/15/2019
ID: 12352
Name: Mocha
Type: Cat
Color: Gray and cream
Breed: Maine Coon
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - Central
Lost: 9/15/2019
ID: 12351
Name: Mocha
Type: Cat
Color: Multicolor calico
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Last seen this morning in the hall way if our appartment a man let him out side because he didn't know the cat was ours and lived in this building
West Branch
Lost: 9/14/2019
ID: 12365
Name: Bay
Type: Cat
Color: Orange
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
West Branch
Lost: 9/14/2019
ID: 12364
Name: Bay
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 9/14/2019
ID: 12359
Name: Marcy
Type: Cat
Color: Green Tabby
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
Ankeny
Lost: 9/14/2019
ID: 12348
Name: Sarsaparilla
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
North ankeny. Has black collar with a bell and possibly an ISU bandana
Des Moines - North
Lost: 9/14/2019
ID: 12347
Name: Murphy
Type: Dog
Color: Black with brown highlights
Breed: Beagle
Gender: Female
Fixed: Not Applicable
Age: Adult
800 Block of West Euclid
Des Moines - East
Lost: 9/14/2019
ID: 12345
Name: Capone
Type: Dog
Color: Fawn
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
E 24th and walnut area please bring him back fyi
Des Moines - West
Lost: 9/14/2019
ID: 12020
Name: Frazier
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at residence 7/31/19; Salisbury Oaks neighborhood. Frazier is well fed, and very mild mannered.
Bondurant
Lost: 9/13/2019
ID: 12360
Name: jasmine
Type: Cat
Color: calico. brown/gray, light brown on top of head
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
she is mainly indoor cat last seen going out my front door around 10:00 pm on 9/13/19. I live in a row of townhouses across from the Brick Street Market/Cafe. She always returns between 2/5 am in the morning. I haven't seen her since she walked out the front door.
Des Moines - East
Lost: 9/13/2019
ID: 12357
Name:
Type: Reptile
Color: Orange
Breed: Iguana
Gender: Male
Fixed: Unknown
Age: Adult
Disappeared at Sleepy Hollow Ren Faire