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
Des Moines - Central
Lost: 11/3/2017
ID: 7321
Name: Oeanut
Type: Cat
Color: Orange tabby
Breed:
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - East
Lost: 11/2/2017
ID: 7302
Name: Buddy
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen by east high school, He jumped out of my car. He is very scared of people
Des Moines - South
Lost: 11/2/2017
ID: 7299
Name: Otis
Type: Dog
Color: Black & white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Madrid
Lost: 11/2/2017
ID: 7298
Name: Tyson
Type: Dog
Color: brown, white chest, brown, tri-colored face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Ty is 7yrs. old, friendly attitude, he wants home & needs help to find his way. Please call with any information.
Chariton
Lost: 11/1/2017
ID: 7320
Name: Cricket
Type: Dog
Color: Red merle
Breed: Australian Shepherd
Gender: Unknown
Fixed: Neutered
Age: Adult
Altoona
Lost: 11/1/2017
ID: 7300
Name: Trouble
Type: Cat
Color: Gray and white
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
Mom and her kitty just moved in with us and he got out Please help us find him lost 5 blocks south of Medicap Pharmacy on 8th street in Altoona
Des Moines - West
Lost: 11/1/2017
ID: 7296
Name: Gilbie
Type: Cat
Color: Black and white
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
58th and Grand Ave.
Des Moines - East
Lost: 10/31/2017
ID: 7781
Name: Baby
Type: Dog
Color: White brindle
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
my dog was took from my back yard and I have not seen her I am so scared where she is or what has happened please i heard a rumor she was at a apt on seneca ave white bldg behind homeplate diner my x took her as i got that answer a few weeks ago please i can prove she is my dog i miss her...called police they cant do anything unless i know where shes located. The girlfriend lives in those apts behind home plate diner off of e14th white bldg his sister lives at 802 county line rd trk242 but my dog hasnt been seen anywhere i hope shes ok and alive. He served restraining order on me so i cant look for her and he stated in it that my dog was his he has no paper work on her i do. I raised her i paid for her vet bills well being he was in prison or living with other people she was at home with me. Shes my dog. Last seen 5 weeks ago michelles bar on e 14th sitting in a white toyota 4 runner misouri plates. Im just sock about it we miss her please someone call if you see my dog
Indianola
Lost: 10/31/2017
ID: 7338
Name: Sparkie
Type: Cat
Color: Orange and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Indianola
Lost: 10/31/2017
ID: 7337
Name: Sparkie
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Altoona
Lost: 10/31/2017
ID: 7295
Name: Shadow
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Senior
2301 8th St Ct SW, Altoona, very friendly, will show signs of hip problems
Des Moines - Central
Lost: 10/31/2017
ID: 7293
Name: Chloe
Type: Dog
Color: White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Last seen around 7th and MLK. Downtown.
Des Moines - East
Lost: 10/31/2017
ID: 7288
Name: Polo
Type: Dog
Color: Golden Brown
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Baby
Last Seen on 24th and Maury Street. He is very active as he is only a few months old.
Urbandale
Lost: 10/29/2017
ID: 7278
Name: Angel / Zoomy
Type: Dog
Color: Back/tan
Breed: Dachshund-Miniature
Gender: Female
Fixed: Neutered
Age: Adult
Ran out open door at new adopter's home. 8000 block of Greenbelt Dr in Urbandale.
Seymour
Lost: 10/29/2017
ID: 7274
Name: Gunner/ Athena
Type: Dog
Color: Black/White Red/White
Breed: Alaskan Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Both are together very friendly last seen in Seymour in my back yard. No other person has seen them and its a small town. Good chance they were stolen.
Dubuque
Lost: 10/29/2017
ID: 7270
Name: Samson
Type: Dog
Color: Sabl and black
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
Between Hidden Valley and Hichory Acres off Olde Davenport Road
Des Moines - Central
Lost: 10/28/2017
ID: 7357
Name: Lady
Type: Cat
Color: White long fur with light tan and gray
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at York and Cleveland, possible sighting the following Thursday or Friday morning @ e13th/ Washington
Des Moines - South
Lost: 10/28/2017
ID: 7266
Name: Bo
Type: Dog
Color: Black an brownish
Breed: Shih Tzu
Gender: Unknown
Fixed: Neutered
Age: Senior
Windsor Heights
Lost: 10/27/2017
ID: 7271
Name: Sheba
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
64th and Sunset Terrace in Windsor Heights
Johnston
Lost: 10/27/2017
ID: 7263
Name: Gus
Type: Dog
Color: Brown with white wirehairs
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on 95th Ct running north
Des Moines - East
Lost: 10/27/2017
ID: 7258
Name: Ace
Type: Dog
Color: Tri-color
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
East side of Des Moines. Does not have a collar on.
Mason City
Lost: 10/27/2017
ID: 7254
Name: Bo
Type: Dog
Color: Agouti
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Cedar Rapids
Lost: 10/26/2017
ID: 7311
Name: Kerrigan
Type: Dog
Color: Black Brindle
Breed: French Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
Escaped from backyard. Is shy but very friendly. Reward given with no questions asked!
Des Moines - North
Lost: 10/26/2017
ID: 7249
Name: Max
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
he was lost near the v.a. hospital near douglas and euclid
Des Moines - South
Lost: 10/26/2017
ID: 7246
Name: Sadie
Type: Dog
Color: Black/brown with white patch's
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Adult
1865 Se Crest on ave 50302