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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Ankeny
Lost: 3/2/2017
ID: 4946
Name: Noni
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Senior
Around 3:00 in NW Ankeny. NW Scott and 4th. She isn't a wanderer and a nervous dog but generally friendly.
Des Moines - West
Lost: 2/28/2017
ID: 4942
Name: Mitty kitty mccudden
Type: Cat
Color: Dark grey with lighter colored stripes
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Senior
Last seen Tuesday late afternoon; in the Urbandale Ave. / 56th street area; has injury to head; goes by "mitty".
Altoona
Lost: 2/28/2017
ID: 4938
Name: Tylee
Type: Dog
Color: White
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Altoona
Lost: 2/28/2017
ID: 4937
Name: Tylee
Type: Dog
Color: White
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 2/27/2017
ID: 4939
Name: Bucky
Type: Cat
Color: Brown/white/black
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Baby
Last seen in the Ankeny development of Centennial Pointe West - directly west of Centennial High School. Is an indoor cat that somehow got out.
Johnston
Lost: 2/26/2017
ID: 4931
Name: Chance
Type: Dog
Color: Cream
Breed: Lhasa Apso
Gender: Male
Fixed: Neutered
Age: Young
Very nice, scares easy. Iffy around kids. Is probably scared out of his mind and will probably go to just about anyone
Clive
Lost: 2/25/2017
ID: 4925
Name:
Type: Dog
Color: Yellow and chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 2/24/2017
ID: 4915
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Baby
Currently at Downtown Doggy Daycare. 724 Scott ave. 515-288-0957