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>='1573257600')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 4/3/2017
ID: 5194
Name: Rozy
Type: Cat
Color: Black with smoky underside
Breed:
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
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