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
Winterset
Lost: 2/5/2016
ID: 2309
Name: Cassie Ann
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Winterset highway 169
Winterset
Lost: 2/5/2016
ID: 2308
Name:
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
Winterset highway 169
Des Moines - East
Lost: 2/4/2016
ID: 2334
Name: KITTY / KIT-KAT
Type: Cat
Color: GRAY WITH BLACK TIGER STRIPES LITTLE BIT OF BROWN & WHITE AROUND MOUTH
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Baby
LAST SEEN AT 4152 E 32ND. ST. SHE'S VERY SKITTISH OF PEOPLE. SHE'S MY BABY VERY IMPORTANT PART OF MY FAMILY. PLEASE CONT TACT ME IF YOU KNOW WHERE SHE IS. (515)991-0566 THANK YOU.
Newton
Lost: 2/4/2016
ID: 2305
Name: Bailey
Type: Dog
Color: Brown & white with blue eyes
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Senior
Bailey is a 9 yr old retired momma. Very friendly. Appoximately 15" at shoulder. Believe she was taken from our front yard. Last seen in our yard approximately 10:00 a.m. on February 4, 2016.
Des Moines - East
Lost: 2/4/2016
ID: 2301
Name: Pooh Bear
Type: Dog
Color: Tri Gray
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
Jumped out of the truck to chase a dog at East 15th and Walnut. Wearing id with contact info and address, rabies and City tag
Des Moines - North
Lost: 2/4/2016
ID: 2297
Name: Molli
Type: Dog
Color: White with brown spots
Breed: Australian Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen was at Hull Ave. She is very friendly and loving and is our world and we just want her home. Call 515-447-3322 or 515-650-7031.
Des Moines - East
Lost: 2/2/2016
ID: 2299
Name: Elliott
Type: Cat
Color: grey tiger
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
At 2912 Dean ave fairground area
Des Moines - East
Lost: 2/2/2016
ID: 2298
Name: Elliott
Type: Cat
Color: grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
On back step at 2912 Dean ave fairgrounds in des Moines is
Oskaloosa
Lost: 2/1/2016
ID: 4623
Name: Myer
Type: Dog
Color: White/Red
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Last seen using the bathroom in the yard off highway 92.
Des Moines - East
Lost: 2/1/2016
ID: 2288
Name: fajita
Type: Cat
Color: orange striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
last seen late 1/31/16. he didn't come in when called like usual. he has all his claws, is fat, and a huge lover cat. he may have been fighting with a coon.
Des Moines - West
Lost: 1/31/2016
ID: 2377
Name: Cookie
Type: Dog
Color: Blackish brown
Breed: Poodle Toy
Gender: Female
Fixed: Not Neutered
Age: Adult
Beaverdale area.
Des Moines - West
Lost: 1/31/2016
ID: 2376
Name: Swagger
Type: Dog
Color: White and brown
Breed: Yorkie Poo
Gender: Male
Fixed: Unknown
Age: Adult
Beaverdale area.
Des Moines - West
Lost: 1/31/2016
ID: 2282
Name: Swagger
Type: Dog
Color: White
Breed: Yorkie Poo
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - West
Lost: 1/31/2016
ID: 2281
Name: Cookie
Type: Dog
Color: Blackish brown
Breed: Poodle
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen in the house. She has four puppies who need her so please help me find my dog. We miss and love her.
Des Moines - Central
Lost: 1/31/2016
ID: 2274
Name: Romeo
Type: Dog
Color: Black
Breed: Poodle
Gender: Male
Fixed: Neutered
Age: Adult
Sherman Hill area. MLK and Woodland/Ingrosoll Ave.
Klemme
Lost: 1/30/2016
ID: 2287
Name: Duke
Type: Dog
Color: Brindle (brown with black stripes)
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
There was a green pickup truck loitering around our farm the morning he didn't come home. I am offering a reward - no questions asked. I just need him back.
Des Moines - East
Lost: 1/30/2016
ID: 2273
Name: Ginger
Type: Dog
Color: Gold/Yellow
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Baby
By 14th and Guthrie, very friendly dog. 15 years old
Mason City
Lost: 1/30/2016
ID: 2272
Name: Garbo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
217 6th street
Mason City
Lost: 1/30/2016
ID: 2271
Name: Garbo
Type: Dog
Color: Black
Breed: Beagle
Gender: Unknown
Fixed: Not Neutered
Age: Adult
217 6th street
Des Moines - East
Lost: 1/30/2016
ID: 2266
Name: Kane
Type: Dog
Color: White
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at E.23rd and Des Moines St.
Des Moines - North
Lost: 1/29/2016
ID: 2264
Name: Jax
Type: Dog
Color: Black and White
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 9pm near Firestone on 2nd Ave, he is a small black and white dog and he should come if you call out his name.
Des Moines - East
Lost: 1/24/2016
ID: 2246
Name: Onyx
Type: Dog
Color: Blue and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 1/23/2016
ID: 2270
Name: Lady
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Senior
16th and Lincoln 5154903517
Des Moines - South
Lost: 1/22/2016
ID: 3136
Name: Russo
Type: Dog
Color: Black with brown
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Young
He is a really nice dog !! He's been gone for a while , if you know where I could find him or have info please contact me !
Des Moines - South
Lost: 1/22/2016
ID: 2602
Name: Russo
Type: Dog
Color: Black and brown in mouth chest legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog ! If you seen him or may know where he is at please call me!