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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - East
Lost: 2/23/2017
ID: 4927
Name: Gizmo
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Cleveland Ave
Williamsburg
Lost: 2/22/2017
ID: 4908
Name: Stevie
Type: Dog
Color: Blonde / yellow
Breed: Labradoodle
Gender: Unknown
Fixed: Not Neutered
Age: Young
She ran away near the ranger outlet mall in Williamsburg Iowa, she is my life please if you know anything contact me.
Johnston
Lost: 2/22/2017
ID:
Name: Hallow
Type: Cat
Color: Tortie
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Baby
Lost around green meadows area village circle
Des Moines - East
Lost: 2/21/2017
ID: 4910
Name: Bentley
Type: Dog
Color: White and cream
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Last seen outside on a runner he had a shirt on he's friendly
Urbandale
Lost: 2/21/2017
ID: 3661
Name: Zoey
Type: Dog
Color: Tan and white
Breed: Australian Cattle Dog
Gender: Female
Fixed: Neutered
Age: Senior
Near soccer complexes