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>='1487808000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Altoona
Lost: 2/27/2017
ID: 4933
Name: Andy
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Andy is very gentle but very skittish and does not like to be held or picked up. He has not been declawed.
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
State Center
Lost: 2/24/2017
ID: 4912
Name: Sasha
Type: Dog
Color: Black with white chest and white stripe on her nose and what paws
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Young
She was let outside in a fenced in yard at 6am this morning, and at 615 we found out she was missing. She got out of the fence's back yard
Mingo
Lost: 2/23/2017
ID: 4934
Name:
Type: Dog
Color: black and white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Senior
Our dog was let out early in the morning of February 23rd. He is black with white down his chest wall and white on his paws. He has a lot of gray around his muzzle. His back legs shake a lot due to his age. He was wearing a camouflage collar with a rabies tag and an orange E-collar.
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