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>='1614643200')) ORDER BY pm1.meta_value DESC, post_date DESC
Waukee
Lost: 11/24/2015
ID: 1985
Name: Mae
Type: Cat
Color: Gray and white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Waukee
Lost: 11/24/2015
ID: 1979
Name: Mae
Type: Cat
Color: Gray with white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
She has her claws but friendly. She does not like her belly rubbed. Likes to cuddle
Ogden
Lost: 11/23/2015
ID: 2000
Name: Bella
Type: Dog
Color: White
Breed: Shiba Inu
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 11/23/2015
ID: 1968
Name:
Type: Dog
Color: blond
Breed: Shiba Inu
Gender: Female
Fixed: Unknown
Age: Young
Johnston
Lost: 11/23/2015
ID: 1963
Name: Maci
Type: Dog
Color: White with brown patches
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
Last seen around Dewey park
Seymour
Lost: 11/22/2015
ID: 2006
Name: Kiki
Type: Cat
Color: Gray and black
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
She ran away while being watched on a farm in Seymour. She is friendly. Her fur patters are generally symmetrical on right and left side. Has all of her claws.
Des Moines - West
Lost: 11/21/2015
ID: 1950
Name: Piper
Type: Dog
Color: White
Breed: Jack Russell Terrier (Parson Russell Terrier)
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Wearing a collar with a heart. Please call 763 381 2751.
Ankeny
Lost: 11/20/2015
ID: 1959
Name: zelda
Type: Cat
Color: gray/black striped
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
south side of ankeny near carney.
Des Moines - Central
Lost: 11/20/2015
ID: 1944
Name: Charlie
Type: Dog
Color:
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
He was let out to pee and he ran after a rabbit. He may still be in the 31st Street/Ingersoll area. He answers well to his name and kissy noises. If he sees you, he'll jump up on you in excitement.
West Des Moines
Lost: 11/20/2015
ID: 1940
Name: Houston
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Lost on Monday evening
Des Moines - South
Lost: 11/19/2015
ID: 2059
Name: BB
Type: Cat
Color: Grey, White, yellow.
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
BB is a indoor outdoor cat, she comes and goes through our doggy door. It has been 4 weeks since we've seen her. With any information please call or text 515-988-2727.
Des Moines - South
Lost: 11/19/2015
ID: 2058
Name: BB
Type: Cat
Color: Grey, White, Yellow.
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is a indoor out door cat. She comes and goes through our doggy door. It has been 4 weeks since she has returned home. We live around Lincoln and any information would be greatly appreciated.
Winterset
Lost: 11/19/2015
ID: 1966
Name: Marshall
Type: Cat
Color: Dark gray tabby
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 11/19/2015
ID: 1942
Name: Rosa
Type: Dog
Color: White
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen by 13th street and Ascension street. Rosa is deaf and she is also dog aggressive. She is great with people.
Lawton
Lost: 11/18/2015
ID: 13795
Name: Battle Rose
Type: Dog
Color: Light brown
Breed: Alaskan Malamute
Gender: Female
Fixed: Not Neutered
Age: Senior
Altus
Lawton
Lost: 11/18/2015
ID: 13794
Name: Battle Rose
Type: Dog
Color:
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Adult
Bevington
Lost: 11/18/2015
ID:
Name: bruno
Type: Dog
Color: brown
Breed: Alaskan Malamute
Gender: Male
Fixed: Neutered
Age: Baby
missing fur under neck and under belly due to scratching from severe allergies
Urbandale
Lost: 11/17/2015
ID: 2064
Name:
Type: Cat
Color:
Breed: Alaskan Malamute
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 11/17/2015
ID: 1926
Name: Romeo
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Romeo is declawed in the front, does not do well with other children besides my daughter.
Urbandale
Lost: 11/17/2015
ID: 1924
Name: Lela
Type: Cat
Color: Dark grey
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Lost small female cat 2-3 years old, long dark grey fur. Lost in car accident off of I80/35 eastbound, between the 141 entrance ramp and 100th St. The vehicle rolled and her carrier came open - she ran from the car when the car door was opened. We do not know if she is injured. Please keep a look out for her in the Plum Dr/100th St area.
Hull
Lost: 11/17/2015
ID: 1921
Name: daily may
Type: Dog
Color: black and white
Breed: Jack Russell Terrier
Gender: Female
Fixed: Unknown
Age: Baby
Heading north on hickery Ave I hull ia very friendly please contact me at 5738553478 thank you
Hull
Lost: 11/17/2015
ID: 1920
Name: luna
Type: Dog
Color: brown
Breed: Blue Heeler
Gender: Female
Fixed: Unknown
Age: Baby
Heading east down hickery Ave in hull she's a hanging tree and healer mix very friendly do please contact, me at 5738553478 thank you
Hull
Lost: 11/17/2015
ID: 1919
Name: daily may
Type: Dog
Color: black and white
Breed: Jack Russell Terrier
Gender: Female
Fixed: Unknown
Age: Adult
She was running east on hickery Ave in hull Ave. It wouldn't let me put a picture up but she's very special please contact me if you find any dog that looks like her she's very friendly Thank you
Des Moines - Central
Lost: 11/16/2015
ID: 1967
Name: Albert Fish
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly cat got out and hasn't returned! He has green eyes, is orange tabby and will answer to Albert or Fish.
West Des Moines
Lost: 11/16/2015
ID: 1929
Name: Houston
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
He snuck out the back door Monday evening close to Jordan Creek Town Center. Hes been declawed in front. Microchip has wrong address and phone number. We've moved since.