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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 4/1/2017
ID: 5171
Name: Tilly
Type: Dog
Color: Brown & white
Breed: Maltipoo
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen EP True Parkway and Valley West Drive
Dubuque
Lost: 4/1/2017
ID: 5168
Name: Stella
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Broke off her collar. Very friendly.
Duncombe
Lost: 3/31/2017
ID: 5253
Name: Lewis
Type: Dog
Color: White & Black
Breed: English Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Broke his leash and still had about six foot still attached. Went missing on Clausen Drive and Union Avenue. Near Highway 20 and 4 miles from Brushy Creek Has anxiety over storms.
West Des Moines
Lost: 3/30/2017
ID: 5220
Name: Akira
Type: Cat
Color: Black and White
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Neutered
Age: Young
All four paws are declawed and she is very shy. She has never been away from her sister and her sister is wandering room to room meowing.
Des Moines - East
Lost: 3/30/2017
ID: 5180
Name: Peanut
Type: Cat
Color: Orange/White
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Peanut is our loving house cat. She's very shy and is a hermit. We've been moving things out of our house we're renting & had some people pick up our junk we didn't need. We think she got out when they were moving things out to the truck. She's wearing a bright green collar with a bell on it & is declawed.
Perry
Lost: 3/30/2017
ID: 5178
Name: Sadie
Type: Dog
Color:
Breed: Vizsla
Gender: Unknown
Fixed: Not Applicable
Age: Senior
Des Moines - Central
Lost: 3/30/2017
ID: 5172
Name: Blackie
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Norwalk
Lost: 3/29/2017
ID: 5148
Name: Willie
Type: Dog
Color: Silver
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 3/29/2017
ID: 5140
Name: Fluffball
Type: Cat
Color: Grey,black & white stripes
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
RE-POST! She was very pregnant & I think she ran off to have her babies around the 5th of March. This is a re-post. She kind of looks cross-eyed. REWARD! Please call 515-285-7814 if you have seen her! Thank You!!!! She may be skittish!
Norwalk
Lost: 3/28/2017
ID: 5143
Name: Willy
Type: Dog
Color: Silver
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 3/27/2017
ID: 5191
Name: Juno
Type: Cat
Color: gray/orange
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Adult
Last seen Monday morning, March 27. She is a gray & orange calico with some orange on her face. She has a pink Harley Davidson collar with a pink circular bell. She is very shy if she does not know you. Please call 515-478-4299 if you see her.
Des Moines - Central
Lost: 3/27/2017
ID: 5170
Name: Walter “Walt”
Type: Cat
Color: Gray/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Still missing. Very sweet cat, scared to be outside as he was a rescue :( Greets with kisses, answers to Walt. He is bigger than the picture now. We are all missing him terribly and need him home. Call day or night 515-306-3616. Thanks <3
Des Moines - Central
Lost: 3/27/2017
ID: 5155
Name: Abby
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Last seen the night before. She is inside/outside cat that doesn't wander too far from home. She can be skittish around strangers. She has all her claws. She is all black except her belly is white. She has green/yellow eyes. Her hair is medium length and she has a bushy tail.
Des Moines - Central
Lost: 3/27/2017
ID: 5135
Name: Walter aka Walt
Type: Cat
Color: gray and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Ran away during move to 3000 Grand apartments. last seen by Unity Church and parking lot area. Very friendly. Was a rescue found outside so he does NOT like to be outdoors. Likes every human he meets and greets with kisses. We are devastated and heartbroken, autistic children are missing him badly. He will likely come if called by name. Please call ASAP if seen or located 515-306-3616
Des Moines - Central
Lost: 3/27/2017
ID: 5134
Name: Oliver aka Fat Fat
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
may be scared of other people, gentle cat. May be traveling with his brother Walter (chunky friendly gray and white cat) as they escaped at 3000 Grand Apartments during a move, not familiar with the area (Terrace Hill/DSM University). Likely scared. Call me ASAP if seen or located. 515-306-3616
Dallas Center
Lost: 3/26/2017
ID: 5142
Name: Burt
Type: Cat
Color: yellow/orange striped
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
last seen by the woman next door he came back to the house the morning of 3/27/2017 but I was out running errands and just missed him, han't been home since. he's aprox. 12lbs. has his claws but very friendly
Des Moines - North
Lost: 3/26/2017
ID: 5129
Name:
Type: Dog
Color: tan black white
Breed: Russian Blue
Gender: Female
Fixed: Unknown
Age: Adult
Found by shop n save on mlk and hickman. Overweight friendly definitely someone's pet.
Urbandale
Lost: 3/26/2017
ID: 5126
Name: Jenny
Type: Dog
Color: Black and White with spots
Breed: English Pointer
Gender: Female
Fixed: Neutered
Age: Young
On 67th Street between Airline and Madison. Please help us bring her home, my kids are devastated.
Des Moines - North
Lost: 3/26/2017
ID: 5121
Name: Rocky
Type: Dog
Color: Brown
Breed: English Pointer
Gender: Male
Fixed: Neutered
Age: Young
Last seen near Hickman & 31st
Ankeny
Lost: 3/25/2017
ID: 5147
Name: Crow
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Baby
Lost near kirkendall library but was also spotted near the new hyvee
Altoona
Lost: 3/25/2017
ID: 5131
Name: Girl
Type: Dog
Color: Red / orange
Breed: Golden Retriever
Gender: Female
Fixed: Unknown
Age: Senior
She has not been spotted!
Altoona
Lost: 3/25/2017
ID: 5130
Name: Girl
Type: Dog
Color: Red / orange
Breed: Golden Retriever
Gender: Female
Fixed: Unknown
Age: Senior
Has not been spotted!
Des Moines - South
Lost: 3/25/2017
ID: 5114
Name: Buddy
Type: Dog
Color: Black
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Adult
He's from south Des Moines but could be anywhere. May not have his collar very friendly.
Des Moines - West
Lost: 3/23/2017
ID: 5099
Name: Anakin
Type: Cat
Color: Brown w white stomach
Breed: Ragamuffin
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 5419 aurora ave (village at westchester apts). He is very fluffy with big eyes and w big striped tail. He also has big white paws with white tufts on the pad. Very talkative.
Pleasant Hill
Lost: 3/23/2017
ID: 5091
Name: Sir Charles
Type: Dog
Color: Black and White
Breed: Papillon
Gender: Male
Fixed: Unknown
Age: Young
Last seen on Burr Oak Blvd. He is scared of big dogs. Please contact me soon if you do see him! 515-724-1357