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>='1427241600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 3/29/2015
ID: 205
Name: Bella
Type: Dog
Color: Gold
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
On oak park av with a smaller goldish while lab German Shepard mix. Love a lot please help
Des Moines - Central
Lost: 3/29/2015
ID: 198
Name: Cheif
Type: Dog
Color: white with brown tail
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a very friendly dog looks kind of mean but he's really not. He has little black dots on his ears. Bad thing about him is he will jump in anyone's car. If you do find him please text or call I got him as a gift from my deceased grandfather and he is the last thing I got. He means a lot to my family. My number is 515-745-4093
Des Moines - Central
Lost: 3/29/2015
ID: 197
Name: Cheif
Type: Dog
Color: white with brown tail
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a very friendly dog looks kind of mean but he's really not. He has little black dots on his ears. Bad thing about him is he will jump in anyone's car. If you do find him please text or call I got him as a gift from my deceased grandfather and he is the last thing I got. He means a lot to my family. My number is 515-745-4093
Des Moines - Central
Lost: 3/29/2015
ID: 196
Name: Cheif
Type: Dog
Color: white with brown tail
Breed: Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a very friendly dog looks kind of mean but he's really not. He has little black dots on his ears. Bad thing about him is he will jump in anyone's car. If you do find him please text or call I got him as a gift from my deceased grandfather and he is the last thing I got. He means a lot to my family. My number is 515-745-4093
Des Moines - Central
Lost: 3/28/2015
ID: 204
Name: Punzle
Type: Dog
Color: Gold and white
Breed: Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
With a gold lab named bella last seen on oak park av. We love and miss them please help Shepard and lab
Des Moines - Central
Lost: 3/28/2015
ID: 203
Name: Punzle
Type: Dog
Color: Goldish white
Breed: Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
By a park with a slightly larger gold lab named bella. We love them so much please help she's lab and German Shepard
Des Moines - Central
Lost: 3/28/2015
ID: 202
Name: Bella
Type: Dog
Color: Gold
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Running past a park with another slightly smaller goldish white female dog
Westphalia
Lost: 3/28/2015
ID: 199
Name: Gus
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Gus is a black lab mix with wavy back hair around his neck. He has white around his snout. He was last seeing on Saturday outside of Westphalia heading towards Harlan, IA. If found please call 712-579-8991 or 816-305-4943.
Des Moines - South
Lost: 3/27/2015
ID: 191
Name: Willie
Type: Dog
Color: White brown spots
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Young
920 hartford ave went acrossed to pioneer estate apartments. One of the tenants saw a young boy / man came up to my dog. Please return him to me. There will be a reward in returning my dog. Please if you see him please call me. Thank you.
Des Moines - South
Lost: 3/27/2015
ID: 190
Name: Willie
Type: Dog
Color: White and Brown Spots
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Young
Was last seen in our backyard after giving him a bath. We live on the S/SE side of Des Moines. May be lost or stolen.