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: 12/14/2017
ID: 7643
Name:
Type: Cat
Color: Tortoise brown
Breed:
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.
Indianola
Lost: 12/10/2017
ID: 7619
Name: Rudy
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Still looking for our chocolate lab. Went missing from front yard in rural area NW of Indianola at 1:20 am December 10. Graying muzzle. No collar. Microchipped. Very friendly. Typically a house pet so might be fearful and anxious at being lost.
Indianola
Lost: 12/10/2017
ID: 7617
Name: Rudy3447
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Older (age 12) Chocolate Labrador Retriever went missing at 1:20 am 12/10/2017 when we let him out to relieve himself. 4 miles NW of Indianola in country on 115th Avenue. He usually comes back in a minute or two. Never saw him again. Very friendly dog.
Des Moines - West
Lost: 12/10/2017
ID: 7616
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
Microchip doesn’t have owners information!
Des Moines - North
Lost: 12/9/2017
ID: 7655
Name: Princess
Type: Cat
Color: All black
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Guthrie&York st. All black cat very friendly always hanging out on corner of Guthrie &York st.knows most people in neiborhood
Des Moines - Central
Lost: 12/9/2017
ID:
Name: Gizmo
Type: Dog
Color: Black and tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Senior
Norwalk
Lost: 12/8/2017
ID:
Name: Dusty
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen 12/14 on Casady Dr but got spooked and ran. Came from Windflower Dr in Norwalk
Norwalk
Lost: 12/8/2017
ID: 7675
Name: Dusty
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen 12/14 on Casady Dr but got spooked and ran. Came from Windflower Dr in Norwalk
Pleasant Hill
Lost: 12/8/2017
ID: 7612
Name: Munchkin
Type: Cat
Color: Black and tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
She has a distinct marking on her chin that looks like a mustache. Last seen near townhomes near car dealership.
Pleasant Hill
Lost: 12/8/2017
ID: 7611
Name: Munchkin
Type: Cat
Color: Black and tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
She has a distinct marking on her chin that looks like a mustache. Last seen near townhomes near car dealership.
Altoona
Lost: 12/8/2017
ID: 7606
Name: Puti
Type: Cat
Color: Half black half yellow
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
She was originally feral when she was born. She is still skittish when she is scared.
Davenport
Lost: 12/8/2017
ID: 7602
Name: Gustav aka Goose
Type: Dog
Color: Brown
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Senior
Goose is a friendly but elderly min pin. He’s small, in bad health due to age and losing his eye sight. We’re worried sick and just want him back home.
Des Moines - Central
Lost: 12/8/2017
ID: 7599
Name: Vinny
Type: Dog
Color: Blonde
Breed: Dachshund Standard
Gender: Male
Fixed: Neutered
Age: Senior
56th and franklin around 1:30p heading west
Des Moines - East
Lost: 12/8/2017
ID: 7597
Name: Dreko & Aujeanae
Type: Dog
Color: Black and drak brown
Breed: Pit Bull
Gender: Male
Fixed: Not Applicable
Age: Young
In front yard someone took them out my front yard
Des Moines - East
Lost: 12/8/2017
ID: 7596
Name: Dreko & Aujeanae
Type: Dog
Color: Black and drak brown
Breed: Pit Bull
Gender: Male
Fixed: Not Applicable
Age: Young
In front yard someone took them out my front yard
Des Moines - East
Lost: 12/7/2017
ID: 7595
Name:
Type: Dog
Color: Black/white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 12/7/2017
ID: 7593
Name: Teddy
Type: Dog
Color: Brown, white and black
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Baby
Last seen around York and Washington street
Council Bluffs
Lost: 12/6/2017
ID: 7592
Name: Sid
Type: Cat
Color: Orange
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Lost at Iowa Western community college Has three legs