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
Cumming
Lost: 4/9/2017
ID: 5256
Name: Panther
Type: Dog
Color: Black Lab
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen on 155th street heading north into timber with our beagle who is also missing.
Cumming
Lost: 4/9/2017
ID: 5255
Name: Echo
Type: Dog
Color: Tri color
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on 155th Street going North into timber.
Ankeny
Lost: 4/9/2017
ID: 5227
Name: Chandler
Type: Cat
Color: all black with white patch on chest
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Has long tail with distinctive "kink" in end, cannot be seen only felt. Answers to Chandler. Last seen early Sunday morning near Prairie Lakes Sports Complex in Ankeny.
Marion
Lost: 4/9/2017
ID: 5226
Name: Blu
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Baby
Last seen at home, she is very lovable and responds to Blu or Baby Blu
St. Marys
Lost: 4/7/2017
ID: 5236
Name: Thor
Type: Dog
Color: Brown and black
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Adult
1 mile east of St Marys
Des Moines - East
Lost: 4/7/2017
ID: 5224
Name: Simone
Type: Cat
Color: Multiple colors
Breed: Torbie
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in east des monies she has a pink collar and she is very soft
Des Moines - West
Lost: 4/7/2017
ID: 5223
Name: Nina
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
Merle Hay Rd. and Madison Ave in Des Moines, shes been walked as far as Hoover high school.
Bondurant
Lost: 4/7/2017
ID: 5210
Name: Luna
Type: Cat
Color: Gray with white
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
LAST SEEN BY FOUNDERS IN BONDURANT
Bondurant
Lost: 4/7/2017
ID: 5209
Name: Luna
Type: Cat
Color: Gray with white
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
LAST SEEN BY FOUNDERS IN BONDURANT
Bondurant
Lost: 4/7/2017
ID: 5208
Name: Luna
Type: Cat
Color: Gray with white
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen by Founders in bondurant
Des Moines - South
Lost: 4/6/2017
ID: 5214
Name: Lovely
Type: Dog
Color: Black brown one white leg
Breed: Siberian Husky
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen park ave. And sw 13th pl.
Urbandale
Lost: 4/5/2017
ID: 5219
Name: Alvira
Type: Cat
Color: Black with a some white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Please help me find 515 745 3093
Urbandale
Lost: 4/5/2017
ID: 5218
Name: Alvira
Type: Cat
Color: Black with a some white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Senior
Urbandale 82nd st very friendly she is over weight
Urbandale
Lost: 4/5/2017
ID: 5217
Name: Alvira
Type: Cat
Color: Black with a some white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Urbandale Very friendly and she is over weight
Des Moines - South
Lost: 4/5/2017
ID: 5201
Name: Herky
Type: Dog
Color: Black and tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Young
Creston St at 10am
Des Moines - Central
Lost: 4/5/2017
ID: 5200
Name: Bella
Type: Dog
Color: Gold
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Senior
Probably with another gold and white German Shepard looking dog
Des Moines - Central
Lost: 4/5/2017
ID: 5199
Name: Rapunzle
Type: Dog
Color: Yellow and white
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
She's supper sweet and probably with a lab
Des Moines - Central
Lost: 4/4/2017
ID: 5241
Name: Candy or * Candy bear*
Type: Cat
Color: White with gray patches on head
Breed: Labrador Retriever
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 .