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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 3/2/2017
ID: 4946
Name: Noni
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Senior
Around 3:00 in NW Ankeny. NW Scott and 4th. She isn't a wanderer and a nervous dog but generally friendly.
Des Moines - West
Lost: 2/28/2017
ID: 4942
Name: Mitty kitty mccudden
Type: Cat
Color: Dark grey with lighter colored stripes
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Senior
Last seen Tuesday late afternoon; in the Urbandale Ave. / 56th street area; has injury to head; goes by "mitty".
Altoona
Lost: 2/28/2017
ID: 4938
Name: Tylee
Type: Dog
Color: White
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Altoona
Lost: 2/28/2017
ID: 4937
Name: Tylee
Type: Dog
Color: White
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 2/27/2017
ID: 4939
Name: Bucky
Type: Cat
Color: Brown/white/black
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Baby
Last seen in the Ankeny development of Centennial Pointe West - directly west of Centennial High School. Is an indoor cat that somehow got out.
Johnston
Lost: 2/26/2017
ID: 4931
Name: Chance
Type: Dog
Color: Cream
Breed: Lhasa Apso
Gender: Male
Fixed: Neutered
Age: Young
Very nice, scares easy. Iffy around kids. Is probably scared out of his mind and will probably go to just about anyone
Clive
Lost: 2/25/2017
ID: 4925
Name:
Type: Dog
Color: Yellow and chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 2/24/2017
ID: 4915
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Baby
Currently at Downtown Doggy Daycare. 724 Scott ave. 515-288-0957
Des Moines - East
Lost: 2/23/2017
ID: 4927
Name: Gizmo
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Cleveland Ave
Williamsburg
Lost: 2/22/2017
ID: 4908
Name: Stevie
Type: Dog
Color: Blonde / yellow
Breed: Labradoodle
Gender: Unknown
Fixed: Not Neutered
Age: Young
She ran away near the ranger outlet mall in Williamsburg Iowa, she is my life please if you know anything contact me.
Johnston
Lost: 2/22/2017
ID:
Name: Hallow
Type: Cat
Color: Tortie
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Baby
Lost around green meadows area village circle
Des Moines - East
Lost: 2/21/2017
ID: 4910
Name: Bentley
Type: Dog
Color: White and cream
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Last seen outside on a runner he had a shirt on he's friendly
Urbandale
Lost: 2/21/2017
ID: 3661
Name: Zoey
Type: Dog
Color: Tan and white
Breed: Australian Cattle Dog
Gender: Female
Fixed: Neutered
Age: Senior
Near soccer complexes
Runnells
Lost: 2/20/2017
ID: 4936
Name:
Type: Dog
Color: yellow lab
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
distinguishing feature....front nipple very large and odd
Iowa Falls
Lost: 2/20/2017
ID: 4903
Name: Lady
Type: Dog
Color: Cream
Breed: Cocker Spaniel
Gender: Female
Fixed: Unknown
Age: Adult
Lady is deaf. Will not hear you if you call her name, and probably won't come to you if you try to pick her up. Is probably very scared. Does not get outside much.
Iowa Falls
Lost: 2/20/2017
ID: 4900
Name: Lady
Type: Dog
Color: Buff
Breed: Cocker Spaniel
Gender: Female
Fixed: Neutered
Age: Senior
LOST DOG: Missing from Iowa Falls...15 year old female, buff colored Cocker Spaniel named Lady. Went missing around 9:00 Monday night, 2/20/17. Pink collar, no tags. She is a small cocker and looks younger than 15 years. She is deaf and probably very scared and nervous. We recently moved and she may be unsure of her whereabouts. She could be anywhere if she was walking all night. If spotted please contact us at 641-648-5460 or 641-373-0916.
Clive
Lost: 2/20/2017
ID: 4895
Name: Bane
Type: Cat
Color: Orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen hanging out on neighbors balcony. They said they never saw him tho? Just a neighbor across the ways
Indianola
Lost: 2/20/2017
ID: 4893
Name: Axel
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 2/20/2017
ID: 4892
Name: Rascal
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near Lincoln South High School
Ankeny
Lost: 2/19/2017
ID: 4935
Name: Rocky
Type: Cat
Color: Black & white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at sw reunion drive, Ankeny Iowa
Des Moines - West
Lost: 2/19/2017
ID: 4882
Name: Schnitzel
Type: Dog
Color: Brown and White
Breed: Schnauzer Miniature
Gender: Female
Fixed: Neutered
Age: Adult
63rd street and University. She is deaf and very friendly. You will have to use a hand signal to get her to come or a treat. She was just groomed today.
Des Moines - South
Lost: 2/18/2017
ID: 4926
Name: Fluffy
Type: Dog
Color: White and black
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
He's small and fluffy
West Des Moines
Lost: 2/18/2017
ID: 4919
Name: Brad
Type: Cat
Color: White and gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 2/18/2017
ID: 4896
Name: Rosie
Type: Dog
Color: Black/white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
vicinity of 6th and Hickman. She is a therapy dog and also has health issues and needs a special diet. It is SO important we get her back. REWARD!
Des Moines - North
Lost: 2/18/2017
ID: 4885
Name: cree
Type: Dog
Color: all white with brown and black spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
he was let out to go potty and he chewed threw the leash .. 8th ave and Madison was where he was last seen