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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Sibley
Lost: 9/27/2018
ID: 9702
Name: Lilo
Type: Dog
Color: Black/white/brown
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
My granddaughters dog took off this evening. If anyone sees her, please call Mary at 712-461-9028. She was last seen on the road by the cemetary. She is wearing a Green Bay Packers collar. There are 2 tags on her collar (one is a bone that is black but the number is not updated on it). If any one finds her, please call or bring to the vet or police station... the vet does know who she is. She is very nice, doesn't bite and has all her shots.
Mason City
Lost: 9/27/2018
ID: 9676
Name: Blanca
Type: Cat
Color: white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Lost: 9/27/2018
ID: 9675
Name: Bo
Type: Dog
Color: White & Black
Breed: American Shorthair
Gender: Male
Fixed: Not Applicable
Age: Adult
Near SE Brownswoods Drive in West Des Moines. The dog's name is Bo and he is newly adopted. Tom Swartwood @ 515-491-6561. You can also call Lorrie Culp @ 515-250-7113
Mason City
Lost: 9/26/2018
ID: 9674
Name: Blanca
Type: Cat
Color: white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
8:30 p.m.
Des Moines - South
Lost: 9/26/2018
ID: 9667
Name: Osha
Type: Dog
Color: Brown white
Breed: Saint Bernard
Gender: Male
Fixed: Neutered
Age: Adult
Sw 9th and thorton
Des Moines - East
Lost: 9/25/2018
ID: 9683
Name: Lucy
Type: Cat
Color: Gray white stripes
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
She is 8 yrs old never been outside. She got out my back door. Ashfield Park area. She is probably very scared. Now its almost 3 weeks. Please if anyone sees her call my number please