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
Hamburg
Lost: 8/16/2017
ID: 6900
Name: Bunny
Type: Cat
Color: Black and white
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
STILL MISSING, SIX WEEKS -- Please help bring Bunny home. Multiple sightings at Sapp Bros travel center (Hwy 2 and I 29) near Percival, Iowa, and Nebraska City, Neb., August 29-31. Possible sightings Sept.4-9 in Hamburg, Iowa: E Street at Bluff Road and in Nebraska City; unable to confirm. Went missing at Waubonsie State Park on August 16. We haven't been able to pin down a location to identify and capture. Please text with a photo immediately if you think you've seen him: 607 727 9213. He was lost 60 miles from home, and is dearly missed. Thank you.
Hamburg
Lost: 8/16/2017
ID: 6859
Name: Bunny
Type: Cat
Color: Black and white
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
STILL MISSING, FIVE WEEKS -- Possible sightings Sept.4-9 in Hamburg, Iowa: E Street at Bluff Road. Possible sightings in Nebraska City; unable to confirm. Multiple sightings at Sapp Bros travel center (Hwy 2 and I 29) near Percival, Iowa, and Nebraska City, Neb., August 29-31. Went missing at Waubonsie State Park on August 16. We haven't been able to pin down a location to identify and capture. Please contact immediately if seen: 607 727 9213. He was lost 60 miles from home.
Hamburg
Lost: 8/16/2017
ID: 6671
Name: Bunny
Type: Cat
Color: Black and white
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
STILL MISSING -- Possible sightings Sept.4-9 in Hamburg, Iowa: E Street at Bluff Road. Multiple sightings at Sapp Bros travel center (Hwy 2 and I 29) near Percival, Iowa, and Nebraska City, Neb., August 29-31. Went missing at Waubonsie State Park on August 16. We haven't been able to pin down a location to identify and capture. Please contact immediately if seen. He was lost 60 miles from home.
Hamburg
Lost: 8/16/2017
ID: 6627
Name: Bunny
Type: Cat
Color: Black and White long-haired
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Waubonsie State Park, Cabin 4 - the park is 2600 acres of wilderness. Nearest towns are Sidney and Hamburg, Iowa. Nearest city is Nebraska City. Lost from cabin 4, but also seen at cabin 5. Most recent sighting on 8/19 on the lower road behind the cabins headed toward the lower picnic area in the park. Bunny is generally very affectionate, but scared and shy with strangers or unfamiliar circumstances. The last two people who saw him pursued him, and he has not been seen since. Reward offered. He is part of my family.
Des Moines - West
Lost: 8/16/2017
ID: 6495
Name: Baxter
Type: Dog
Color: Cream
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the north of grand area, ingersoll-ish. He's not wearing a collar because we flea treated him yesterday!
Duncombe
Lost: 8/15/2017
ID: 6488
Name: Riley and Cheyenne
Type: Dog
Color: Black other is light tan
Breed: Husky
Gender: Unknown
Fixed: Not Neutered
Age: Baby
MISSING 2 HUSKY DOGS BLACK IS MALE TAN IS FEMALE NAMES ARE RILEY AND CHYANNE IF YOU SEE THEM PLEASE GET AHOLD OF ME OR Dakota Dahlberg ASAP. LAST SEEN OUTSIDE OF FORT DODGE BETWEEN DUNCOMBE AND VINCENT. THEY HAVE BEEN GONE WE THINK SINCE ABOUT 4AM. AND DETAILS OR INFORMATION ABOUT OUR BABIES PLEASE CONTACT US. THEY ARE 1 YEAR OLD. THEY WERE CHASING A COYOTE PACK. PLEASE. HELP US FIND OUR BABIES AND BRING THEM HOME SAFE.
Ankeny
Lost: 8/13/2017
ID: 6468
Name: Foxy
Type: Cat
Color: Gray
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
Meows when he hears his name. Neighborhood east of Saylorville Dam.
Des Moines - South
Lost: 8/13/2017
ID: 6467
Name: Unknown
Type: Dog
Color: Black/gray
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Senior
Des Moines - East
Lost: 8/12/2017
ID: 6480
Name: Sophie
Type: Dog
Color: White
Breed: Maltese
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly, didn't have her tag on! Please contact Briar at 515.657.1798
Madrid
Lost: 8/12/2017
ID: 6464
Name: Tucker
Type: Dog
Color: Golden/tan
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Very sweet boy. Will come when you call
Des Moines - East
Lost: 8/11/2017
ID: 6449
Name:
Type: Dog
Color: Blond and Black
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Adult
Found on Hickman across from Broadlawns Hospital
Des Moines - South
Lost: 8/10/2017
ID: 6582
Name: Smokey
Type: Cat
Color: Grey
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
He has an enlarged thumb on his front feet. Declared in the front too
Waukee
Lost: 8/10/2017
ID: 6541
Name: Squarsh
Type: Cat
Color:
Breed: Himalayan
Gender: Female
Fixed: Neutered
Age: Adult
Near Waukee triangle
Hartford
Lost: 8/9/2017
ID: 6536
Name: mcgee
Type: Cat
Color: black and tan
Breed: Burmese
Gender: Male
Fixed: Neutered
Age: Adult
Was spotted at Monalu's in Hartford Iowa the Friday after he was missing
Urbandale
Lost: 8/9/2017
ID: 6445
Name: Cole
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He is a very social cat and very friendly. All black. He went outside overnight and hasn't come home.
West Des Moines
Lost: 8/8/2017
ID: 6515
Name: Arwen
Type: Cat
Color: Orange black white
Breed: Birman
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Arwen got out of the house last Tuesday. She is an indoor cat and has not been declawed.
Des Moines - South
Lost: 8/8/2017
ID: 6442
Name: Kitty
Type: Cat
Color: Grey Tortie
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 8/8/2017
ID: 6434
Name: Calli
Type: Cat
Color: Tri colored
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Senior
60th and EP true Has medical issues
Norwalk
Lost: 8/8/2017
ID: 6420
Name:
Type: Dog
Color: Brown and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Found on Clarke Rd
Ankeny
Lost: 8/7/2017
ID: 9810
Name: Penny
Type: Dog
Color: Mahogany
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Adult
Last Seen: 2501 NW Pleasant St Ankeny IA 50023-9069 Microchip# 4C18387768
Des Moines - East
Lost: 8/7/2017
ID: 6640
Name: Millie
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Pomeroy
Lost: 8/7/2017
ID: 6545
Name: Maximus
Type: Cat
Color: brown/gray &white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He's got a white spot on his back
West Des Moines
Lost: 8/7/2017
ID: 6461
Name: Pumba
Type: Cat
Color: Orange and White
Breed: Abyssinian
Gender: Male
Fixed: Neutered
Age: Adult
He got out of my apartment at Chapel Ridge West.
Des Moines - South
Lost: 8/7/2017
ID: 6426
Name: Ollie
Type: Cat
Color: Tabby and white
Breed: Abyssinian
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Aug,7,2017 . Ollie has a red collar , white prints and a tiny bell.
Des Moines - South
Lost: 8/7/2017
ID: 6424
Name: Ollie
Type: Cat
Color: Tabby and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Aug,7,2017 . Ollie has a red collar , white prints and a tiny bell.