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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 10/4/2018
ID: 9719
Name: Spotty
Type: Dog
Color: White with black spots
Breed:
Gender: Male
Fixed: Not Neutered
Age: Senior
He has no teeth ,losing vision and has no tail
Des Moines - South
Lost: 10/4/2018
ID: 9718
Name: Tinky
Type: Cat
Color: Brown
Breed: Maine Coon
Gender: Female
Fixed: Not Applicable
Age: Young
2946 Indianola Ave
Des Moines - South
Lost: 10/4/2018
ID: 9717
Name:
Type: Dog
Color: Black and brown
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Young
Being taken by animal control tonight.
Des Moines - South
Lost: 10/4/2018
ID: 9712
Name: Vincent
Type: Cat
Color: White with dark ears and dark tail
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Young
He's a friendly cat and might come to his name "Vinny" he's about 14 weeks old I love him to death please give me a call if you think you've seen him around se14th and indianola ave area.
Des Moines - South
Lost: 10/4/2018
ID: 9711
Name: Vincent
Type: Cat
Color: White with dark ears and dark tail
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Young
He's a friendly cat and might come to his name "Vinny" he's about 14 weeks old I love him to death please give me a call if you think you've seen him around se14th and indianola ave area.
Norwalk
Lost: 10/3/2018
ID: 9754
Name: Lucky
Type: Cat
Color: Black
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
He doesn't normally like people, skittish.
Grimes
Lost: 10/3/2018
ID: 9723
Name: Stewie
Type: Dog
Color: Black brown and white
Breed: Shetland Sheepdog Sheltie
Gender: Male
Fixed: Unknown
Age: Young
Stewie is very shy and will not come to people. Please do not chase just immediately call 515-423-4232
Des Moines - South
Lost: 10/3/2018
ID: 9714
Name: Penelope
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Female
Fixed: Not Neutered
Age: Young
On courtland ave and indianola ave
Des Moines - South
Lost: 10/3/2018
ID: 9713
Name: Penelope
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Female
Fixed: Not Neutered
Age: Young
On courtland ave and indianola ave
Des Moines - West
Lost: 10/3/2018
ID: 9709
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - West
Lost: 10/2/2018
ID: 9721
Name: Business
Type: Cat
Color: Gray with white on her chest and feet
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Business was last seen on 10/02/18 on 26th and Woodland in Woodland Heights.
Ames
Lost: 10/2/2018
ID: 9710
Name: Daisy
Type: Dog
Color: Black, Brown, and White
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Senior
Last seen near Garfield Ave. and Phoenix in Ames.
Des Moines - South
Lost: 10/2/2018
ID: 9708
Name: Herman
Type: Cat
Color: Black and silver striped
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - West
Lost: 10/2/2018
ID: 9707
Name: Business
Type: Cat
Color: Grey with white on chest and feet
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Business was last seen on 10/02/18 on 26th and Woodland in Woodland Heights.
Clarion
Lost: 10/1/2018
ID: 9701
Name: Kilo
Type: Dog
Color: Brindle and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Only 8 months old but very large(Size of adult pitbull). He pulled and his chain snapped in half so possibly still hanging from his collar. Escaped between Clarion/Dows/Galt, IA area when we pulled over to let him go to the bathroom. Very friendly but rambunctious and hyper.
Adair
Lost: 10/1/2018
ID: 9700
Name: BENTLEY & STUBBY
Type: Dog
Color: Red heeler
Breed: Red Heeler
Gender: Male
Fixed: Neutered
Age: Adult
Accident occurred at 87 mile marker on I 80 around 2:00a.m. My son was taken to hotel in Adair but not sure exactly what the city is at the 87 mile marker.
Madrid
Lost: 9/30/2018
ID: 9689
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Maybe had a color at one time but must have slipped it.
West Des Moines
Lost: 9/30/2018
ID: 9687
Name: Gomez
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
He is a very sweet dog and he never runaway before.
Adair
Lost: 9/29/2018
ID: 9699
Name: BentleyStudley
Type: Dog
Color: Red/tan
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
White speckles and socks. Black n gray nose. One has a stumpy tail. Ran away from a car accident on the highway.
Des Moines - West
Lost: 9/29/2018
ID: 9697
Name: Blue
Type: Dog
Color: Blue brindles
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
He was with a puppy reddish in color 4 months old in the area of Mary ave between 10th -14th streets please help
Cedar Rapids
Lost: 9/28/2018
ID: 9691
Name: Nova
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen off Edgewood Rd in the west park trailer court
Des Moines - West
Lost: 9/28/2018
ID: 9684
Name: Kiara
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Around Merle Hay and Holcomb
Des Moines - East
Lost: 9/28/2018
ID: 9682
Name: Buster
Type: Dog
Color: Brown
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Baby
Ne 43rd Avenue and E 14th st
Des Moines - South
Lost: 9/28/2018
ID: 9679
Name: Chico
Type: Dog
Color: Tan
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen at The Vineyards Carmen Estates Condominiums.
Ames
Lost: 9/27/2018
ID: 10126
Name: Oreo
Type: Cat
Color: Whit/black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Might have a scar or would on left front leg