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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Altoona
Lost: 9/24/2019
ID: 12429
Name: Zeta
Type: Dog
Color: Tan/black
Breed: Belgian Shepherd
Gender: Unknown
Fixed: Unknown
Age: Young
She was in the house when we left for work. Have dog door that goes out into fenced yard. She will bark a lot at people she does not know but friendly.
Des Moines - South
Lost: 9/23/2019
ID: 12476
Name: Tigra
Type: Cat
Color: Calico...black and tan
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Senior
Very friendly
Des Moines - East
Lost: 9/23/2019
ID: 12446
Name: Trixie
Type: Dog
Color: Brown and tan
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen in the area of 28th and Walnut St. It was bout 1130pm she is a great dog and the kids and I miss her dearly please do the right thing and give her back. She also is got some hair missing on her back due to dry skin also because she is older 8yrs she has some gray patches of hair on her back
Clive
Lost: 9/23/2019
ID: 12434
Name: Merlin
Type: Cat
Color: Black and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Senior
Blind
Des Moines - East
Lost: 9/23/2019
ID: 12427
Name: Trixie
Type: Dog
Color: Brown and
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Baby
Purple collar got some patches of hair missing on back it's a chihuahua terrier mix
Ankeny
Lost: 9/23/2019
ID: 12425
Name: Ruby
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
She was last seen at our home in Ankeny (Delaware Crossing) she is very friendly and will come to her name Ruby.
Des Moines - East
Lost: 9/23/2019
ID: 12423
Name: Cheif
Type: Dog
Color: Beige n white
Breed: Blue Heeler
Gender: Male
Fixed: Unknown
Age: Young
Sumner
Lost: 9/22/2019
ID: 12462
Name: Huck
Type: Dog
Color: Tan/white
Breed: Foxhound
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 9/22/2019
ID: 12428
Name: Lucy
Type: Dog
Color: Fawn
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Senior
She is very old (17) and deaf
Weldon
Lost: 9/22/2019
ID: 12426
Name: Miesha
Type: Dog
Color: Red and White
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
She normally explore the wood behind the house but, she hasn't came home. If you see her it may be easier to catch her with a hot dog
West Des Moines
Lost: 9/22/2019
ID: 12418
Name:
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
22nd and Westown West Des Moines
West Des Moines
Lost: 9/21/2019
ID: 12417
Name: Ivy
Type: Cat
Color: Black and White
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Lost of of ashworth and 56th near the veterinarians office.
Ames
Lost: 9/21/2019
ID: 12416
Name: Daisy
Type: Dog
Color: Black, grey, white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
Very shy dog. Last seen around 315 Hayward St Ames, IA
Rock Rapids
Lost: 9/21/2019
ID: 12415
Name: Penelope
Type: Dog
Color: Black brindle
Breed: Boston Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 9/21/2019
ID: 12413
Name: Gibby
Type: Cat
Color: Grey brown stripes with white one front leg all white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Off 42nd and Cottage Grove Ave
De Soto
Lost: 9/21/2019
ID: 12412
Name: Freya
Type: Dog
Color: Grey and white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
Near 169 in De Soto running west. Very skittish but friendly
Dubuque
Lost: 9/21/2019
ID: 12409
Name: Luna
Type: Cat
Color: grey
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Declawed all 4 paws
Ankeny
Lost: 9/21/2019
ID: 12404
Name: Pearl
Type: Cat
Color: Light gray with dark gray
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Pearl got put of the house somehow we believe on the morning of April 9 this year. We live on Snyder Blvd which is just off of Oralabor Rd. She is not an outside cat but has accidentally gotten out before at my old place but found her way back to the front door and meowed and came when called. She was about 10 lbs when I last saw her. She has all claws. She is a very gorgeous cat and I believe someone may be keeping her. Please do the right thing and give her back. She is 3 years old and I have had her since she was 4 weeks old. She is extremely soft and has striking blue eyes. Her brothers and sisters miss her so much. Please text or call Ema at 515-720-5523 if you have any info. Thank you.
Pleasant Hill
Lost: 9/21/2019
ID: 12402
Name: Mittens
Type: Cat
Color: Black and white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
He's very skittish and we thought he was loose in the house and just hiding from us, but we cannot find him anywhere. We're afraid he got out, but we are not sure when as it's been awhile since we saw him.
Ventura
Lost: 9/20/2019
ID: 12611
Name: Charlie
Type: Bird
Color: Gray white yellow flock orange cheeks
Breed: Cockatiel
Gender: Male
Fixed: Not Applicable
Age: Young
Charlie flew out the door accidentally. He has a vocabulary and is very friendly. He is very missed. He is a big part of my heart. He knows come here Charlie and may land on your shoulder.
Des Moines - Central
Lost: 9/20/2019
ID: 12399
Name: Emma Kitty
Type: Cat
Color: Black and grey tiger stripes. Yellow fur on floppy belly
Breed: Cockatiel
Gender: Unknown
Fixed: Neutered
Age: Adult
32nd street across from Jethros by Drake.
Des Moines - Central
Lost: 9/20/2019
ID: 12398
Name: Emma Kitty
Type: Cat
Color: Black and grey tiger stripes. Yellow fur on floppy belly
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
32nd street across from Jethros by Drake.
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