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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 7/20/2018
ID: 9209
Name: Trone
Type: Dog
Color: brindle
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Adult
broke his cable, he's very friendly, but does not like dogs...
Altoona
Lost: 7/20/2018
ID: 9206
Name: Paisley
Type: Cat
Color:
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
If seen please contact 5152055092
Lorimor
Lost: 7/20/2018
ID: 9203
Name: Tiger
Type: Dog
Color: White with brown and gray spots
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Got loose in the am hasnt been back yet looked all over town. He is deeply missed!
Nevada
Lost: 7/20/2018
ID: 9200
Name: Leia
Type: Dog
Color: Champagne and white
Breed: Boston Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
5pm in our backyard at 820 4th st. Nevada
Des Moines - South
Lost: 7/20/2018
ID: 9199
Name:
Type: Dog
Color: Black and white
Breed: Dalmatian
Gender: Male
Fixed: Unknown
Age: Baby
Found by Ewing park.
Des Moines - South
Lost: 7/20/2018
ID: 9197
Name: Savannah
Type: Dog
Color: white
Breed: Maltese
Gender: Female
Fixed: Not Neutered
Age: Senior
Last seen outside of home on E. Emma Avenue on the south side of DSM, near Donna's Lounge (now Donna's Garage). She is a senior dog with missing teeth, so her tongue hangs out. She is very sweet but probably won't respond to her name as she is mostly deaf. She is very small- 7 lbs max.
Nevada
Lost: 7/19/2018
ID: 9192
Name: Rosco
Type: Cat
Color: Black & tan stripped
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Jodie Hoover-Jasper 2 hrs Roscoe, our DSH stripped kitty, got out in the night & has disappeared. He's never been outside before. We live on S27 / 650th Ave, south of Fernauld. He's very friendly, a year old, neutered & has a chip that is not activated. Please call 5I5 2I5 2585 if you even think you've seen him. Thank you.
Urbandale
Lost: 7/18/2018
ID: 9279
Name:
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
We have tried to catch him several times but he runs away. He looks very well taken care of.
Des Moines - South
Lost: 7/18/2018
ID: 9213
Name: None
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
We found this cat and are trying to find owners. Very friendly, good with people and dogs, no collar or tag
Polk City
Lost: 7/18/2018
ID: 9205
Name: Oscar
Type: Reptile
Color: Brown & gold
Breed: Turtle
Gender: Male
Fixed: Not Neutered
Age: Adult
Morning of 7/18/2018 Escaped from his outdoor enclosure. Leopard TORTOISE, not turtle. Very tame and friendly
Des Moines - East
Lost: 7/18/2018
ID: 9193
Name: Suki
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 7/18/2018
ID: 9191
Name: Yogi Bear
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by neighbor in front lawn and heading down the street.
Des Moines - West
Lost: 7/17/2018
ID: 9235
Name: Shada
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Tuesday
Iowa Falls
Lost: 7/17/2018
ID: 9189
Name: Beannie
Type: Dog
Color: Red
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 5.29pm 2 miles S of Alden iowa. Very friendly. Please help.
Alden
Lost: 7/17/2018
ID: 9187
Name: Beanie
Type: Dog
Color: Red
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Baby
8 year old. White mark on chest. Gray collar with no tags. Comes to Beanie, Bubba, or Fennie. 100 lbs. Loves car rides but hates getting into the car. Last seen south of Alden on s27.
Des Moines - East
Lost: 7/17/2018
ID: 9184
Name: Leo
Type: Cat
Color: Grey with black stripes. Some white on feet
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Leo is the cat in front of pic
West Des Moines
Lost: 7/17/2018
ID: 9181
Name: Luna
Type: Dog
Color: Gold
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 7/17/2018
ID: 9177
Name: WonTon
Type: Dog
Color: White with brown spotting
Breed: Chinese Crested Dog
Gender: Male
Fixed: Neutered
Age: Senior
In neighborhood around stow elementary school. Very skittish and scared of most people Please call 515-249-9275
Des Moines - Central
Lost: 7/17/2018
ID: 9176
Name: Jia
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen at 3124 Glenarm Ct. by the VA hospital in Des Moines. Very friendly but may be a little shy when approaching her.
Altoona
Lost: 7/16/2018
ID: 9196
Name: Chloe
Type: Cat
Color: Orange and white
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen in a chair outside our house please contact 5157780235 or 5157780233 and our home phone is9672565 Our Andress is 409 6th street
Des Moines - South
Lost: 7/16/2018
ID: 9186
Name: Katniss Kitty Queen
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Young
Ankeny
Lost: 7/16/2018
ID: 9180
Name: Luna
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Near Crocker Elementary Ankeny
Norwalk
Lost: 7/16/2018
ID: 9169
Name: Graham
Type: Dog
Color: Brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Applicable
Age: Young
Last seen on Lewis Ave. Has a black colar on and loves people.
Des Moines - North
Lost: 7/15/2018
ID: 9162
Name: emma
Type: Dog
Color: Black/white
Breed: Whippet
Gender: Female
Fixed: Not Applicable
Age: Senior
emma is 14 years old we love her very much
Des Moines - East
Lost: 7/15/2018
ID: 9160
Name: Loki
Type: Dog
Color: Chocolate Brown
Breed: Dachshund-Miniature
Gender: Male
Fixed: Not Neutered
Age: Adult
He went across the street on E 42nd and a Mother and daughter picked him up. They told the neighbor their intention was to take him to the Animal Rescue League.