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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 4/4/2017
ID: 5241
Name: Candy or * Candy bear*
Type: Cat
Color: White with gray patches on head
Breed:
Gender: Female
Fixed: Neutered
Age: Adult
About 11:30 pm. Drake neighborhood 24th St. was pacing outside our front door wanting back in. She bolted when I ran to get her. Shes very shy and timid. Prefers men. Don't run after her if you can throw a blanket on top of her. She has whats called a broken purr box. She can't meow or purr. She might do little what we call bubble purrs. She is fixed and utd on shots please call 5154144928
West Des Moines
Lost: 4/4/2017
ID: 5198
Name: Mike
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last see in our neighborhood on 50th and Raintree Drive. He has a break away collar with our address and phone number, but it may have come off of him.
Des Moines - North
Lost: 4/4/2017
ID: 5188
Name: Spooky
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
Mondamin ave
Des Moines - Central
Lost: 4/3/2017
ID: 5290
Name: Candy aka Candy Bear
Type: Cat
Color: Mostly white grey patches
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Drake neighborhood!! Im moving this weekend i dont want her left behind. She was seen by my front door 3 days ago, but ran when some one tried to get to my door. She is very timid and shy. Please call 5154144928 day or night
Des Moines - Central
Lost: 4/3/2017
ID: 5265
Name: Candy aka Candy Bear
Type: Cat
Color: Mostly white grey patches
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Please call day or night. 5154144928 Was seen by a friend coming up to my door. Was standing at the door but ran as soon as she saw him. She was lost in Drake area 24th and 23rd St. My front door is in the alley. She is very timid and shy. Prefers men. Best way to catch her is put out her favorite food which is albacore tuna when she starts eating throw a big blanket on top of her. She has a medical condition known as a broken purr box. She cant purr or meow.
Des Moines - Central
Lost: 4/3/2017
ID: 5249
Name: Pinto
Type: Dog
Color: Brown with some white
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
31st street between school street .and kingman
Urbandale
Lost: 4/3/2017
ID: 5194
Name: Rozy
Type: Cat
Color: Black with smoky underside
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Baby
Monday. Dawson and 63rd. Headed west. She is a gift for my grandaughter who is devistated. REWARD. Please cal 515 782 4895 .
Urbandale
Lost: 4/3/2017
ID: 5193
Name: Rozy
Type: Cat
Color: Black with smoky underside
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Baby
Monday. Dawson and 63rd. Headed west. She is a gift for my grandaughter who is devistated. REWARD. Please cal 515 782 4895 .
Urbandale
Lost: 4/3/2017
ID: 5190
Name: Rozy
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
She was last seen on DM\urbandale. Reward!
Des Moines - East
Lost: 4/2/2017
ID: 5458
Name: Nova
Type: Dog
Color: White with black spots
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen on the east side of Des Moines by the fourmile area
West Des Moines
Lost: 4/2/2017
ID: 5187
Name: Cotten Ball
Type: Cat
Color: White long hair
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Lost at South Soccer Field, on Park Ave., West Des Moines. Kitten had crawled on engine block, in truck. We saw him in bushes, but didn't realize he was ours until we got home and he wasn't there. Unable to find him when we went back. Back of kitten had been shaved due to hair was tangled and unable to comb out.
Des Moines - Central
Lost: 4/2/2017
ID: 5167
Name: Chilly
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 4/2/2017
ID: 5166
Name: Chilly
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 4/2/2017
ID: 4212
Name: Reggie
Type: Dog
Color: Orange and White
Breed: Brittany Spaniel
Gender: Male
Fixed: Neutered
Age: Young
Lost/ stolen off of cable on our front deck on 9/27/2016, between 1:30 p.m. and 2:30 p.m. About 40 lbs with a tail that looks like a little flag. Very friendly, very hyper. Loves everybody.
Mount Pleasant
Lost: 4/1/2017
ID: 10107
Name: Usher
Type: Cat
Color: Tuxedo
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He should respond to his name, although it has been so long that I am not sure if he would remember it anymore. He knows the word treats.
Des Moines - East
Lost: 4/1/2017
ID: 5389
Name: Marley
Type: Cat
Color: Gray
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
On dubuque st
Iowa City
Lost: 4/1/2017
ID: 5233
Name: Nikolai
Type: Cat
Color: Buff and Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
S. Lucas in Iowa City
Dubuque
Lost: 4/1/2017
ID: 5175
Name: Stella
Type: Dog
Color:
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 4/1/2017
ID: 5173
Name: Stella
Type: Dog
Color: White and brindle
Breed: English Bulldog
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen on nw 48th pl between 2nd and 6th ave
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