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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Carlisle
Lost: 9/25/2018
ID: 9678
Name: Cakes
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Lost in avon lake. Have a handicap blind kitty that really depends on his big brother. Please call 515-991-1650 if found.
Norwalk
Lost: 9/24/2018
ID: 9673
Name: Hawkeye
Type: Dog
Color:
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Senior
Norwalk
Lost: 9/24/2018
ID: 9672
Name: Hawkeye
Type: Dog
Color: black/white
Breed: Husky
Gender: Unknown
Fixed: Not Applicable
Age: Senior
Des Moines - West
Lost: 9/24/2018
ID: 9662
Name: FiFi
Type: Dog
Color: Brindle
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Fifi got out mlk and atkins near 235. She is loving and doesnt have a mean bone in her body!!
Ankeny
Lost: 9/24/2018
ID: 9661
Name: Drake
Type: Dog
Color: White w/ Black spots
Breed: Terrier
Gender: Male
Fixed: Not Applicable
Age: Senior
Mustache Collar w/tags and license.
Story City
Lost: 9/23/2018
ID: 9669
Name:
Type: Dog
Color:
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Senior
Missing most teeth so tongue hangs out.
Story City
Lost: 9/23/2018
ID: 9668
Name:
Type: Dog
Color:
Breed: Schipperke
Gender: Female
Fixed: Neutered
Age: Senior
Missing most teeth so tongue hangs out.
Rodney
Lost: 9/23/2018
ID: 9663
Name: Chapo
Type: Dog
Color: chocolate brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
last seen 5 miles south of smithland by some corn bins.
Clive
Lost: 9/23/2018
ID: 9659
Name: Merlot
Type: Cat
Color: Brown, orange calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
SHe is very Friendly but gets scared. She is only 2 yrs old and I know she is scared she's never been outside before. We lost her in Clive Iowa near university and 104th..If you see her or see a picture anything please. My name is Molly McGuire (515)422-8583
Independence
Lost: 9/22/2018
ID: 10064
Name: Tycho
Type: Dog
Color: Tan and grey
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
Tycho is 9 and shy. Please help us bring him home.