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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 8/8/2017
ID: 6442
Name: Kitty
Type: Cat
Color: Grey Tortie
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 8/8/2017
ID: 6434
Name: Calli
Type: Cat
Color: Tri colored
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Senior
60th and EP true Has medical issues
Norwalk
Lost: 8/8/2017
ID: 6420
Name:
Type: Dog
Color: Brown and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Found on Clarke Rd
Ankeny
Lost: 8/7/2017
ID: 9810
Name: Penny
Type: Dog
Color: Mahogany
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Adult
Last Seen: 2501 NW Pleasant St Ankeny IA 50023-9069 Microchip# 4C18387768
Des Moines - East
Lost: 8/7/2017
ID: 6640
Name: Millie
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Pomeroy
Lost: 8/7/2017
ID: 6545
Name: Maximus
Type: Cat
Color: brown/gray &white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He's got a white spot on his back
West Des Moines
Lost: 8/7/2017
ID: 6461
Name: Pumba
Type: Cat
Color: Orange and White
Breed: Abyssinian
Gender: Male
Fixed: Neutered
Age: Adult
He got out of my apartment at Chapel Ridge West.
Des Moines - South
Lost: 8/7/2017
ID: 6426
Name: Ollie
Type: Cat
Color: Tabby and white
Breed: Abyssinian
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Aug,7,2017 . Ollie has a red collar , white prints and a tiny bell.
Des Moines - South
Lost: 8/7/2017
ID: 6424
Name: Ollie
Type: Cat
Color: Tabby and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Aug,7,2017 . Ollie has a red collar , white prints and a tiny bell.
Urbandale
Lost: 8/6/2017
ID: 6459
Name: Bandit
Type: Cat
Color: Bandit
Breed: Snowshoe
Gender: Male
Fixed: Neutered
Age: Adult
By Kmart on Hickman
Ames
Lost: 8/6/2017
ID: 6437
Name: Kelso
Type: Cat
Color: Black/White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Parking lot at Hampton Inn & Suites on SE 16th St in Ames, IA. Kelso is spooked easily, and if spotted, it is best to speak softly and move slowly. He is very receptive to having his name called and using kitty noises is also helpful. He loves catnip and wet kitty food, and may even come out of hiding when in the presence of a hairbrush, as he is absolutely obsessed with having his fur brushed, (especially around his ears and chin).
Spragueville
Lost: 8/6/2017
ID: 6407
Name: Petey
Type: Dog
Color: White and brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen running into wood behind our house. He is microchipped.
Des Moines - South
Lost: 8/6/2017
ID: 6403
Name: Molly
Type: Dog
Color: Wheat
Breed: Wheaten Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
Sutures in abdomen from recent surgery
Ames
Lost: 8/5/2017
ID: 6455
Name: Winston
Type: Cat
Color: Black
Breed: Wheaten Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Recently moved from Clark & 20th area.
Grinnell
Lost: 8/4/2017
ID: 6520
Name: Happy
Type: Dog
Color: Black with white tux
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
Was adopted to a couple in grinell without my permission by a friend who was taking temporary custody. I adopted him on 11 24 2016 from dsm arl Hes chipped and licensed in my name I know hes in grinell and that's all
Waterloo
Lost: 8/4/2017
ID: 6382
Name: Pablo
Type: Dog
Color: White
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in my front yard! He just got a hair cut so he looks like a chihuahua he is also mixed with poodle he has a little hair on his tail still!
Grinnell
Lost: 8/3/2017
ID: 6519
Name: Happy
Type: Dog
Color: Black
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
Adopted without my permission to a family in grinell Hes chipped thru dsm arl . He was rescued there by me on nov 24 2016
Colfax
Lost: 8/3/2017
ID: 6475
Name:
Type: Dog
Color: White, black spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Lives on Broadway by the elementary school in Colfax
Beacon
Lost: 8/3/2017
ID: 6393
Name: Mia
Type: Cat
Color: Grey and white
Breed: Sphynx (Hairless Cat)
Gender: Female
Fixed: Not Neutered
Age: Young
We are unsure if she found her way through a crawl space in my daughters closet or if she made her way out the front door when the wind blew it open. She is dearly loved and missed and we would love to see her home safe and sound. Please call Diana @ 641-670-7636 or Adam @ 641-891-5523 if you see her.
Des Moines - East
Lost: 8/3/2017
ID: 6383
Name: Zozo
Type: Dog
Color: Brown and white
Breed: Sphynx (Hairless Cat)
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 8/2/2017
ID: 6387
Name: jack
Type: Cat
Color: tan white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
lives on e walnut st
Norwalk
Lost: 8/1/2017
ID: 6693
Name: Helen/Cat
Type: Cat
Color: Tortoiseshell
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
Sassy 2 year old kitty with a pink collar and sparkly gold claws. She's been gone over a month and I miss her a lot. I have a feeling someone took her in. Please help find my kitty.
West Des Moines
Lost: 8/1/2017
ID: 6537
Name: Kade or Meekers
Type: Cat
Color: White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Meekers was left out overnight and didn't come home the next morning. He's a very friendly cat. He has one eye that's crossed and his front paws are declawed.
Pella
Lost: 8/1/2017
ID: 6392
Name: Bayja
Type: Dog
Color: Black with white on her chest and paws
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
I got in a car accident and she ran off after. We are from Ankeny so far from home. She was last seen on old highway 163 in oskaloosa.
Oskaloosa
Lost: 8/1/2017
ID: 6391
Name: Bayja
Type: Dog
Color: Black with white on chest and paws
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Was in a car accident and she ran off after, were from ankeny so she's far from home. Ran off on old highway 163 in oskaloosa