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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Monticello
Lost: 10/5/2018
ID: 9739
Name: Meeka
Type: Dog
Color: Black and Tan with a bone shape on her stomachs
Breed: Chiweenie
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on military Road in Monticello Iowa
Des Moines - East
Lost: 10/4/2018
ID: 9908
Name: Crush
Type: Cat
Color: Orange and white
Breed: Chiweenie
Gender: Male
Fixed: Neutered
Age: Young
His name is crush.plz plz help me find my cat bring him home his family misses him so much .. he lives at (1302 Williams st )EastSide Of DesMoines Iowa 50317
Des Moines - East
Lost: 10/4/2018
ID: 9907
Name: Crush
Type: Cat
Color: Orange and white
Breed: Chiweenie
Gender: Male
Fixed: Neutered
Age: Young
His name is crush plz help me find my cat plz plz /Lives at 1302 Williams St. Des Moines IA 50317
Fairfield
Lost: 10/4/2018
ID: 9753
Name: Shamus
Type: Dog
Color: Black and Brown
Breed: Airedale Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Last seen running around outside approx 5 miles south of Fairfield Iowa on Highway 1
Johnston
Lost: 10/4/2018
ID: 9733
Name:
Type: Cat
Color: Blk/brn white front & wht paws
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
RIZZI DISTINCTIVE MARK ON NOSE 515.494.6885
Johnston
Lost: 10/4/2018
ID: 9730
Name: Rizzi
Type: Cat
Color: Blk/brn white front & wht paws
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Winwood Apts
Des Moines - Central
Lost: 10/4/2018
ID: 9720
Name: Spotty
Type: Dog
Color: White with black spots
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Senior
He has no tail and teeth and losing his vision
Des Moines - Central
Lost: 10/4/2018
ID: 9719
Name: Spotty
Type: Dog
Color: White with black spots
Breed: Tabby
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.