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>='1579478400')) ORDER BY pm1.meta_value DESC, post_date DESC
Dexter
Lost: 3/28/2019
ID: 11010
Name: Felix
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly. He likes to get into vehicles which is probably why he's gone
Des Moines - Central
Lost: 3/28/2019
ID: 10868
Name: Tinks
Type: Cat
Color: White with brown and gray stripes
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
We miss him badly. He is probably scared as he is an inside cat. He has a collar with name address and phone but it is a quick release. He was set up for nurturing on Monday.
Des Moines - South
Lost: 3/28/2019
ID: 10856
Name: KeKe
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
We live near Scandia Avenue and SE 5th. The cat is a rescue so she’s a little intimidated but always nice.
Des Moines - Central
Lost: 3/28/2019
ID: 10850
Name: Dave
Type: Cat
Color: White Grey Brown
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - West
Lost: 3/28/2019
ID: 10846
Name: Harley
Type: Dog
Color: Black white with Black and Tan spots
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Baby
Very timid just 12 weeks and not use to people but our family!
Des Moines - South
Lost: 3/27/2019
ID: 10859
Name: Cocoa
Type: Dog
Color: Black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen Thursday afternoon. She is very friendly. Is wearing a purple and gold University of Northern Iowa collar.
Corydon
Lost: 3/27/2019
ID: 10854
Name: Gizmo
Type: Dog
Color: Blonde and brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
Was in my parents yard and then gone. My mom older dog was left. I offering a reward for the safe return
Des Moines - Central
Lost: 3/27/2019
ID: 10851
Name: Bear
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
27th
Des Moines - South
Lost: 3/27/2019
ID: 10845
Name: Pete
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
My puppy got out last night and we can’t find find him. Golden retriever about 4 months old. South union by pleasant st. Please let me know if any one has him. His name is Pete. He has a black collar on with silver studs.
Bondurant
Lost: 3/27/2019
ID: 10842
Name: C3PO
Type: Dog
Color: Fawn
Breed: Greyhound
Gender: Male
Fixed: Neutered
Age: Young
C3PO is a greyhound who goes by the name C. He was last seen in the cornfields on the northwest side of Bondurant at around 6:00 PM. We had him in our sights for a long time but he slipped us and headed northwest. He is probably hiding somewhere as he is exhausted, mud coated and wet. C is EXTREMELY skittish of everything. Please DO NOT approach him. If you see him please call me (Natasha) at 515-720-6071 or Heartland Greyhound Adoption at 515-967-6564 -- anytime day or night!
Mount Pleasant
Lost: 3/27/2019
ID: 10840
Name: Ruby
Type: Dog
Color: Black and brown
Breed: Greyhound
Gender: Male
Fixed: Not Neutered
Age: Baby
Mount Pleasant
Lost: 3/27/2019
ID: 10839
Name: Ruby
Type: Dog
Color: Black and brown
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Baby
Perry
Lost: 3/26/2019
ID: 10940
Name: Jasmine
Type: Cat
Color: Tiger stripes with white and brown
Breed: Bengal
Gender: Female
Fixed: Neutered
Age: Young
Last seen in Perry fleeing her home. She got out thru the garage and fled after the car started and scared her.
West Des Moines
Lost: 3/26/2019
ID: 10878
Name: Nikka
Type: Cat
Color: Tan
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Senior
By woodland avenue by valley high school
Hamilton
Lost: 3/26/2019
ID: 10857
Name: Azra
Type: Cat
Color: Grey and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Baby
Des Moines - South
Lost: 3/26/2019
ID: 10834
Name: Hunter lee
Type: Dog
Color: Mostly black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around south union and park ave.
Des Moines - South
Lost: 3/26/2019
ID: 10833
Name: Wallie
Type: Dog
Color: Brown/gray
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Got out at around 6pm.
Des Moines - South
Lost: 3/26/2019
ID: 10832
Name: Wallie
Type: Dog
Color: Brown/gray
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Pacific Junction
Lost: 3/25/2019
ID: 10925
Name: Lucy
Type: Cat
Color:
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
My friends dad was trying to get him before the food hit and he ran off
Ankeny
Lost: 3/25/2019
ID: 10887
Name: Verona
Type: Cat
Color: Charcoal Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
Waukee
Lost: 3/25/2019
ID: 10844
Name: Violet
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Ankeny
Lost: 3/25/2019
ID: 10838
Name: Verona
Type: Cat
Color: Charcoal Gray
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Senior
Verona is mostly charcoal gray with small amount of tan on her feet and under her chin. She got out of our patio door Monday 3/26/19 evening. We live in NW Ankeny off of 1st street and need our baby home. Please let us know if you have seen her.
Ankeny
Lost: 3/25/2019
ID: 10829
Name: Lola
Type: Cat
Color: Tortoise shell
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
She’s a very shy and timid kitty.
Des Moines - East
Lost: 3/25/2019
ID: 10826
Name: Binx
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 3/25/2019
ID: 10825
Name: Bella
Type: Dog
Color: Brown Black White
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Young
Seen around 1917 10th des moines, iowa 50314