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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 3/17/2017
ID: 5034
Name: Benji
Type: Dog
Color: Gold and white
Breed:
Gender: Male
Fixed: Not Neutered
Age: Young
Around 2pm
Des Moines - East
Lost: 3/16/2017
ID: 5028
Name: Whovian aka Who
Type: Dog
Color: White
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Who is a very sweet dog but he may run. He does have anxiety and is on medications so he spins around in circles if he is experiencing anxiety. Loves kids and other animals. Please call or message 515-306-3638 if found day or night.
Dexter
Lost: 3/15/2017
ID: 5133
Name: Haven
Type: Dog
Color: Dark blue and white
Breed: Blue Heeler
Gender: Female
Fixed: Unknown
Age: Baby
On 9th and crocker and she is very afraid of men and she loves hotdogs
Denver
Lost: 3/15/2017
ID: 5022
Name: Thor
Type: Dog
Color: White/gold
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
South of Denver near C57. Unsure if dog has tags on the collar he's wearing. Unfamiliar with area, staying with relatives while owners on vacation.
Chariton
Lost: 3/14/2017
ID: 5043
Name: Hawkeye
Type: Dog
Color: Tri
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
South of Chariton about 4 miles off of Hwy 14
Harris
Lost: 3/11/2017
ID: 5120
Name: Molly
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
No collar, answer by the name of Molly, very friendly dog, last seen near Harris
Des Moines - South
Lost: 3/11/2017
ID: 5006
Name:
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Been hanging around my house near Evergreen and SE 20TH. Safe inside now will take to ARL if not claimed soon.
Des Moines - East
Lost: 3/10/2017
ID: 5012
Name: Larry
Type: Cat
Color: Orange tabby
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Young
Over by Kmart on hubbell
West Des Moines
Lost: 3/9/2017
ID: 5014
Name: Fonzie
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He's a friendly outdoor cat
Des Moines - Central
Lost: 3/8/2017
ID: 5004
Name: Lover
Type: Cat
Color: Black & White
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Young
In vacinity of 13th & University Has a white shaped mustache on upper lip
Des Moines - Central
Lost: 3/8/2017
ID: 5003
Name: Lover
Type: Small or Furry
Color: Black. & white
Breed: Chinchilla
Gender: Male
Fixed: Unknown
Age: Baby
March 8th last seen around his yard He has white on upper lip shaped like a mustache
Des Moines - North
Lost: 3/8/2017
ID: 4979
Name: Sophi
Type: Dog
Color: White and black
Breed: English Pointer
Gender: Female
Fixed: Neutered
Age: Young
Highland park area.
Des Moines - East
Lost: 3/7/2017
ID: 5024
Name: Rusty or Rusty da snowman
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He is indoor outdoor kitty kitty cat. He isn't the prettiest cat but he's ours. We have had him since he was only few weeks old. My kids miss their lil man and so do i...
Urbandale
Lost: 3/7/2017
ID: 4997
Name: Vito
Type: Dog
Color: Brown
Breed: Pekingese
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 3/7/2017
ID: 4981
Name: DOLLY
Type: Dog
Color: Black, brown, white
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Adult
Tuesday night. Very friendly and loving
West Des Moines
Lost: 3/7/2017
ID: 4973
Name:
Type: Dog
Color: White, black, brown
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
We found him playing in our deck with our dog. Put up a pet fence to keep him on the deck
Urbandale
Lost: 3/7/2017
ID: 4971
Name:
Type: Dog
Color: Blonde
Breed: Japanese Chin
Gender: Male
Fixed: Unknown
Age: Adult
Found on the corner of 72nd and Douglas Ave in Urbandale. He's got on a red harness but has no tags. Took him to a vet to see if he had a chip but they could not detect one.
Des Moines - South
Lost: 3/6/2017
ID: 5433
Name: Annie
Type: Dog
Color: Blue merle
Breed: Great Dane
Gender: Unknown
Fixed: Unknown
Age: Young
STILL MISSING! Last seen by DSM airport. SHY GIRL. NOT AGGRESSIVE. We believe someone picked her up and kept her.
Des Moines - South
Lost: 3/6/2017
ID: 5059
Name: Annie
Type: Dog
Color: Blue merle
Breed: Great Dane
Gender: Unknown
Fixed: Not Applicable
Age: Young
Timid but not aggressive. Re-homed from Wyoming. Only in Des Moines two days.
Des Moines - South
Lost: 3/6/2017
ID: 5029
Name: Fluffball
Type: Cat
Color: grey stripe very fluffy
Breed: Great Dane
Gender: Female
Fixed: Not Neutered
Age: Adult
She was very pregnant & was about ready to give birth.She was last seen on se 12th ST in Des Moines. We miss her dearly!!! REWARD!!!! Please call 515-285-7814 if you see her! TY! (Her eyes kind of look crossed).
Des Moines - South
Lost: 3/6/2017
ID: 4976
Name: Annie
Type: Dog
Color: Blue merle
Breed: Great Dane
Gender: Unknown
Fixed: Unknown
Age: Young
She is very timid. Might not go to anyone. She is not mean. Last seen by DM airport on 3/7 am
Des Moines - East
Lost: 3/5/2017
ID: 5010
Name: Lilly
Type: Cat
Color: tortoise shell
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Ran away from East 7th and Hull Ave. Nice and friendly, will not attack. Was in heat. Usually comes home at night, but still is out.
Des Moines - East
Lost: 3/5/2017
ID: 4998
Name: Lilly
Type: Cat
Color: tortoise shell
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Ran away from East 7th and Hull. She is nice and sweet, most likely will not attack.
Des Moines - East
Lost: 3/4/2017
ID: 4960
Name: Tank
Type: Dog
Color: Rednose red and white
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
He was outside in my fenced-in yard.
Northwood
Lost: 3/2/2017
ID: 4948
Name: Dexter
Type: Dog
Color: Gold
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Dexter is the dog standing up in the photo. He weighs about 70 lbs, has big feet. He is about 9 months old and was last seen running with our other Golden Retriever, who has already returned home.