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
Madrid
Lost: 9/22/2017
ID: 7197
Name: Tyson
Type: Dog
Color: brown wht. chest, brown, wht. & black face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
7 yrs. old very friendly. Last seen 6 mi. North of Madrid. Any information could be helpful. Call of text 515-205-0691.
Madrid
Lost: 9/22/2017
ID: 7196
Name: Tyson
Type: Dog
Color: brown wht. chest, brown, wht. & black face
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
7 yrs. old very friendly. Last seen 6 mi. North of Madrid. Any information could be helpful. Call of text 515-205-0691.
Madrid
Lost: 9/22/2017
ID: 7173
Name: TYSON
Type: Dog
Color: brown, white chest & stomach, tri-colored face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
N. of Madrid Very friendly, deep bark 7 yrs. old Please help him find his way home, greatly missed. call 515-205-0691 Any info. will be appreciated!
Madrid
Lost: 9/22/2017
ID: 7123
Name: Tyson
Type: Dog
Color: Tri-colored reddish-brown, wht. chest, Blk. wht. brown face
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
N. of Madrid, 290th St. & V Ave. Very friendly, deep bark, Service dog for family. Any info. would be appreciated!
Madrid
Lost: 9/22/2017
ID: 7117
Name: Tyson
Type: Dog
Color: Reddish-brown, face is tri-colored
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen 6 mi. N. of Madrid, Iowa. Very friendly, happy boy w/deep voice. Please help him find his way home. Family member, missed.
Des Moines - South
Lost: 9/22/2017
ID: 6878
Name: Princess has been found but I don’t know how to delete this post
Type: Cat
Color: Gray, black, and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
She has leopard spots on her belly that are gray and black triangle / diamonds on her tail. She has a slender build.
Pleasant Plain
Lost: 9/21/2017
ID: 7604
Name: Chuck
Type: Dog
Color: Silver grey tan
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
3:56 pm on 9-21-17 He is very shy and timid, hates car rides.
Pleasant Plain
Lost: 9/21/2017
ID: 7244
Name: Chuck
Type: Dog
Color: grey tan white
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
Midway st and penn Pleasant plain Iowa. Ice blue eyes, Tan coloring around eyes. Is skittish of people. Doesn't like car rides. Will hide and pretend you aren't there. IS NOT AGGRESSIVE. Probably won't come when called.
Des Moines - West
Lost: 9/21/2017
ID: 6945
Name: Baby girl
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Adult
09/28/2017 across the street in a neighbors bushes
Des Moines - South
Lost: 9/21/2017
ID: 6893
Name: Leonardo
Type: Cat
Color: Orange Tabby with white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
200 block of E. Jackson Ave
Des Moines - South
Lost: 9/21/2017
ID: 6863
Name: Kyia(key-uh)
Type: Cat
Color: Brown and Tan Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She must have snuck out when a door was open. Did not notice her missing, she likes to hide.
Colfax
Lost: 9/21/2017
ID: 6862
Name: Koda
Type: Dog
Color: Brown
Breed: Shar Pei
Gender: Male
Fixed: Unknown
Age: Young
He broke off his chain we think early in the morning and haven’t been back since WE HAVE A CASH REWARD IF FOUND!!! He’s our baby and we hope he’s okay.
Des Moines - South
Lost: 9/21/2017
ID: 6853
Name:
Type: Dog
Color: 1 black & brown & 1 tan
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Running in Pioneer park & my yard for 2 day's
Adel
Lost: 9/20/2017
ID: 6854
Name: Pretty princess
Type: Dog
Color: Reverse bridle
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Senior
We let her outside at 7 am and called for her a half hour later but she never returned.. we've searched all around our area without any luck. She's a small breed terrier mix believed to be pregnant.. She also has seizures so we really need to find her. This it totally unlike her to run off. She's a very loyal, Sweet, loving little girl. Our family misses her so much and we are all worried sick about her. Any help would be appriciated. Please call day or night with any information 515-669-4986
Carlisle
Lost: 9/20/2017
ID: 6848
Name:
Type: Cat
Color: Orange/white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around the apartments by east casey's in carlisle.
West Des Moines
Lost: 9/20/2017
ID: 6843
Name: Trouble
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
White Oak Town homes 2259 Grand Ave WDM
Ackley
Lost: 9/19/2017
ID: 6879
Name: Cocoa and Rosie
Type: Dog
Color: Chocolate labs
Breed: Labrador Retriever
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Our dogs are 7-year old litter mates. They were last home Monday evening. They are chocolate labs. One dog is heavier both good natured and loving.
Des Moines - Central
Lost: 9/18/2017
ID: 6846
Name: Sammie
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Baby
He was last seen in the 28th and cottage grove area. He is 9wks old and was with his mother who is also brindle and 11 years old. There is a $$REWARD$$$$. UDATE : mother has been found and Sammie male is still missing.
Des Moines - West
Lost: 9/18/2017
ID: 6842
Name: Sammie
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Baby
Unclipped tail white tip, all four paws are white as well
Des Moines - West
Lost: 9/18/2017
ID: 6841
Name: Bella
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Unknown
Fixed: Not Neutered
Age: Senior
West Des Moines
Lost: 9/18/2017
ID: 6832
Name: Lilly
Type: Cat
Color: Black
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Young
Escaped from Turtle Creek apartments in West Des Moines
Des Moines - East
Lost: 9/17/2017
ID: 6839
Name: Red
Type: Cat
Color: Red calico orange and white
Breed: Tortoiseshell
Gender: Male
Fixed: Not Neutered
Age: Adult
On east 15th and vine
Des Moines - East
Lost: 9/17/2017
ID: 6838
Name: Red
Type: Cat
Color: Red calico orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
On east 15th and vine
Ankeny
Lost: 9/17/2017
ID: 6825
Name: Opie/Simba
Type: Dog
Color: Charcoal grey
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Young
Lost at rest stop north of Ankeny on I-35. PLEASE dont mistake his fear as aggression.
Des Moines - South
Lost: 9/17/2017
ID: 6821
Name: Besos
Type: Dog
Color: White
Breed: Great Dane
Gender: Male
Fixed: Neutered
Age: Adult