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
Monroe
Lost: 12/19/2017
ID: 7889
Name: Mario
Type: Dog
Color: red
Breed:
Gender: Male
Fixed: Not Neutered
Age: Young
Monroe IA area. Dog is skittish. He is a red min pin and he doesn't come when called. He has some dark hairs. Tall standing ears and cropped tail. He is the pup on the far right in the picture. Please help him come home.
Ankeny
Lost: 12/19/2017
ID: 7685
Name: Jax
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Front declawed, indoor cat only.
West Des Moines
Lost: 12/19/2017
ID: 7664
Name: Shadow
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
We found him he came home through the back door at 7:30 pm.
West Des Moines
Lost: 12/19/2017
ID: 7663
Name: Shadow
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Possibly got out through the garage between 7 am and 9 am. He is all black with bright yellow/green eyes. Will come by the name of Shadow if he is called.
Johnston
Lost: 12/19/2017
ID: 7662
Name: Dozer
Type: Dog
Color: Yellow
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Seen 4 house ago. Non aggressive
Des Moines - South
Lost: 12/19/2017
ID: 7661
Name: Minnie
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Unknown
Fixed: Neutered
Age: Young
Minnie likes to bark but she is not mean at all. She had a leopard sweater on but I found it in the backyard where she dug out. We are near SE 3rd and McKinley
Des Moines - East
Lost: 12/18/2017
ID: 7658
Name: ZoSo
Type: Dog
Color: Gray and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
My dog was last seen in my home. My daughters friends stole it. He is only 4 weeks old and needs a special diet. There are 6 little girls who will have a very sad Christmas if he is not found safe
Newton
Lost: 12/17/2017
ID: 7913
Name: Snow
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Snow was last seen south of Knoxville near Aliba. She was found by a lady named Amy Geogena who gave her to tje wrong family. We are trying to find out who has her and want our baby back. Amy and The Marion County Humane society has been very suspicious and not giving any answers and blocking us on fb. Please share!
Des Moines - South
Lost: 12/17/2017
ID: 7673
Name: Cookie
Type: Cat
Color: Tortie
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Southridge Estates, veru friendly
West Des Moines
Lost: 12/17/2017
ID: 7659
Name: Oreo
Type: Dog
Color: Black and white with black freckles
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - Central
Lost: 12/17/2017
ID: 7656
Name: Eva
Type: Dog
Color: Red
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Senior
Last seen in Sherman Hill around 18th & Pleasant. Eva is deaf so she will likely not answer to her name.
Des Moines - Central
Lost: 12/17/2017
ID: 7654
Name: Sawyer
Type: Dog
Color: Black
Breed: Irish Setter
Gender: Male
Fixed: Unknown
Age: Adult
Found wandering down Chamberlain by the Roosevelt baseball fields. Tags seem outdated or the phone number isn't working.
Waterloo
Lost: 12/16/2017
ID: 7651
Name:
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen around 9:00 pm near Lantern Square Apartments
Clive
Lost: 12/16/2017
ID: 7650
Name: Princess Fiona
Type: Cat
Color: White , black and orange
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Baby
Has identification tags
Des Moines - Central
Lost: 12/15/2017
ID: 7687
Name: Bruce
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Over by Union park area
Oskaloosa
Lost: 12/15/2017
ID: 7679
Name: Kolby
Type: Dog
Color: Black and Gray
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Young
Wearing a red shock collar with no tags. very shy and timid
West Des Moines
Lost: 12/15/2017
ID: 7657
Name: Droogie
Type: Cat
Color: Gray, white and spots of buff
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last seen Friday, 12/15/17 around 6-6:30 PM. She likes to hang out south in the alley between 4th and 5th Street close to Vine Street. See her every morning and evening, so I think she may be in a garage around that area.
Des Moines - Central
Lost: 12/14/2017
ID: 7643
Name:
Type: Cat
Color: Tortoise brown
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
Found at Lefty’s Live Music, trying to enter the back door. Currently in lout green room with litter, water, blanket and food.
Des Moines - South
Lost: 12/14/2017
ID: 7640
Name: Remi
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on Leland Ave and sw 14th early afternoon. She is friendly. Can sit, shake, lay down
Ames
Lost: 12/13/2017
ID: 7921
Name: Kelso
Type: Cat
Color: Black and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
On alexander drive among/behind businesses and construction area - Near Lincoln way and graham street by the cocoa cola company/behind yarn tree building among businesses in that area. The area before 580th street to the right of Lincoln way coming from ames toward Nevada
Norwalk
Lost: 12/12/2017
ID: 7635
Name: Vince
Type: Dog
Color: Grey
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Adult
The Ridge at Echo Valley in Norwalk. Friendly dog. Does not bite.
Des Moines - East
Lost: 12/12/2017
ID: 7634
Name: Remington
Type: Cat
Color: Grey
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Lives at 3402 E 7th st. Very friendly cat responds to remi or Remington. Contact me at 5154226368
Des Moines - North
Lost: 12/10/2017
ID: 7644
Name:
Type: Dog
Color: Liver & Roan
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
410 NW 50th Place Des Moines
Des Moines - North
Lost: 12/10/2017
ID:
Name:
Type: Dog
Color: Liver & Roan
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
410 NW 50th Place Dm IA 50313
Ankeny
Lost: 12/10/2017
ID: 7620
Name:
Type: Cat
Color: Orange with White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Our cat was last seen on Saturday Nov. 25th. We live in the Saylorville Lake Area. He has no collar or microchip. He is very friendly and may have wandered into a shed or garage. If you have seen him please call 515-975-9365.