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>='1560988800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 7/3/2017
ID: 6078
Name: Tito
Type: Dog
Color: Brown
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Senior
Kenyon & south union
Lacona
Lost: 7/3/2017
ID: 6071
Name: OJ
Type: Dog
Color: Lite brown/black face
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
180 ave. Lacona Iowa Warren/Luca County
Lacona
Lost: 7/3/2017
ID: 6068
Name: OJ
Type: Dog
Color: Lite brown/ black face
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
Lacona area warren/ Lucas county
Bondurant
Lost: 7/3/2017
ID: 6067
Name:
Type: Dog
Color:
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - North
Lost: 7/3/2017
ID: 6064
Name: Mya
Type: Dog
Color: White with reddish brown spine
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
E Holcomb and Cornell. Slipped out of her collar. Very friendly. Reward if found
Des Moines - North
Lost: 7/3/2017
ID: 6063
Name: Mya
Type: Dog
Color: White with reddish brown spine
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
E Holcomb and Cornell. Skipped out of her collar. Very friendly
Des Moines - South
Lost: 7/3/2017
ID: 6059
Name: Star
Type: Dog
Color: White
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
She's a Lab Mix, white, with a ridge down her back-to-back like a Rhodesian Ridgeback. She's afraid of people.
West Des Moines
Lost: 7/3/2017
ID: 6055
Name: ??
Type: Dog
Color: White/Black
Breed: Mix
Gender: Male
Fixed: Not Applicable
Age: Adult
Randall
Lost: 7/2/2017
ID: 6192
Name: Kia
Type: Dog
Color: Tan
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Rockwell City
Lost: 7/2/2017
ID: 6174
Name: Barney
Type: Dog
Color: Black and White
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Senior
Barney is a well cared for very friendly dog. He was not wearing a collar. His owner misses him very much.
Des Moines - Central
Lost: 7/2/2017
ID: 6053
Name: drake
Type: Dog
Color: white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Lost: 7/2/2017
ID: 6051
Name: Precious
Type: Dog
Color: Brown and Black Brindle
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home right off E 14th and Euclid. She is terrified of fireworks and the neighbor let some off, so she took off. She is friendly to humans but timid around other dogs.
Des Moines - Central
Lost: 7/2/2017
ID: 6050
Name: Precious
Type: Dog
Color: Brown and Black Brindle
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home right off E 14th and Euclid. She is terrified of fireworks and the neighbor let some off, so she took off. She is friendly to humans but timid around other dogs.
Carlisle
Lost: 7/2/2017
ID: 6049
Name: Shilo
Type: Dog
Color: Black with tan
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
Last seen 7/1 before fireworks started going crazy...She's very old and very weak...she cannot walk well.
Columbus Junction
Lost: 7/1/2017
ID: 6098
Name: Lilu
Type: Dog
Color: White/ Cream with grey
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Young
Update: Lilu was seen Wednesday heading east from the Thirsty Camel Restaurant in Conesville, IA going over Highway 70. T Ave. in Columbus Junction. $75 REWARD FOR RETURN She is wearing a pink harness. Very shy. Do Not Chase! Likes other dogs and will approach them. She will come to females but not males because they scare her. Please call if you see her!!
Des Moines - South
Lost: 7/1/2017
ID: 6074
Name: Karma
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Young
She will like to be a round people all the time
Farmington
Lost: 7/1/2017
ID: 6062
Name: Pickles
Type: Dog
Color: Red
Breed: Cavalier King Charles Spaniel
Gender: Unknown
Fixed: Neutered
Age: Senior
2700 140 th St Farmington Ia 52626
Panora
Lost: 7/1/2017
ID: 6040
Name: Jack
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Last seen at Lake Panorama near the golf course on East side of the lake. Very friendly, 12 years old.
Melrose
Lost: 7/1/2017
ID: 6039
Name: Frank
Type: Dog
Color: White/brown/gray
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Address is in Melrose, our family is visiting here for 4th of July weekend. He is a very timid dog. He is very sweet. If you're nice to him he will come to you.
Des Moines - North
Lost: 7/1/2017
ID: 6036
Name: Bruno
Type: Dog
Color: White with brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
My backyard in highland park area.
Waukee
Lost: 6/30/2017
ID: 6146
Name: Bailey
Type: Dog
Color: Black
Breed: Mix
Gender: Female
Fixed: Not Applicable
Age: Baby
She ran out of our backyard due to fireworks nearby. We live on SE Florence Dr. (Behind South Middle School) in Waukee.
Des Moines - Central
Lost: 6/30/2017
ID: 6097
Name: Foulan
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
1305 3rd street
West Des Moines
Lost: 6/30/2017
ID: 6083
Name: Adamas
Type: Cat
Color: Striped grey, tan, black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He's very friendly and sweet.
Norway
Lost: 6/30/2017
ID: 6042
Name: Hairlip and Waddles
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Carlisle
Lost: 6/30/2017
ID:
Name: Macie
Type: Dog
Color: White
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult