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>='1618444800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 1/29/2021
ID: 15962
Name: Charlie
Type: Dog
Color: White
Breed: Poodle
Gender: Male
Fixed: Not Applicable
Age: Senior
Charlie is blind He was last seen in the area of 42nd in the beaverdale area
Des Moines - Central
Lost: 1/29/2021
ID: 15959
Name: CONWAY
Type: Cat
Color: solid grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
last seen at 3407 Grand Ave, Des Moines, IA 50312
Des Moines - Central
Lost: 1/29/2021
ID: 15958
Name: Conway
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Not Neutered
Age: Young
His collar has little fish on it
Eldora
Lost: 1/28/2021
ID: 15954
Name: Dodge
Type: Dog
Color: Black/White
Breed: Coonhound
Gender: Male
Fixed: Unknown
Age: Adult
Southeast of Eldora, IA on our property in the country l
Eldora
Lost: 1/28/2021
ID: 15953
Name: Briggs
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on our property Southeast of Eldora, IA
Des Moines - East
Lost: 1/28/2021
ID: 15950
Name:
Type: Rabbit
Color:
Breed: Great Dane
Gender: Unknown
Fixed: Unknown
Age: Adult
I found them in my garage. I'm going to put in my dog kennel inside over night.
Ankeny
Lost: 1/28/2021
ID: 15949
Name: Rory
Type: Dog
Color: Black and white
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Young
NW 8th street area in Ankeny
Des Moines - West
Lost: 1/27/2021
ID: 15946
Name: Oso
Type: Dog
Color: Brow and black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Unknown
Age: Baby
Went to use restroom and never saw him again, lost around 59th St around Merl hay area
Clive
Lost: 1/26/2021
ID: 15945
Name: Barbeque
Type: Cat
Color: Black and Brown
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Clive Dec. 6th 2019.
Waterloo
Lost: 1/25/2021
ID: 15960
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Black cat found during the storm on Monday night on Knollview Dr. in Waterloo.
Berwick
Lost: 1/25/2021
ID: 15944
Name: Lucy
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Lucy was last seen running around with a black long hair stray male at the sunnybrook trailer park. Haven’t seen her since the snow storm. She is very friendly but is likely very scared and under a porch or in a shed as she’s never been outside before.
West Des Moines
Lost: 1/24/2021
ID: 15967
Name: Soka
Type: Cat
Color: Grey
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
West des Moines near from maple grove elementary school.
Altoona
Lost: 1/24/2021
ID: 15952
Name: Oliver
Type: Cat
Color: White with a grey tail and grey mark on his head
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Sunday, Jan. 24
Waterloo
Lost: 1/24/2021
ID: 15948
Name: Diesel
Type: Dog
Color: Black and Rust
Breed: Doberman Pinscher
Gender: Male
Fixed: Not Neutered
Age: Young
Irwin
Lost: 1/24/2021
ID: 15947
Name: Loki
Type: Dog
Color: Red and White
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Adult
Got out of kennel and we live in the country.
Urbandale
Lost: 1/23/2021
ID: 15934
Name: Unknown
Type: Cat
Color: Gray and Black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Baby
Found in a garage in Urbandale.
Stuart
Lost: 1/23/2021
ID: 15929
Name: Tyson
Type: Cat
Color: Charcoal gray
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen around West Central Valley High School in Stuart
Des Moines - North
Lost: 1/23/2021
ID: 15928
Name: Sarge
Type: Dog
Color: Black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Senior
By north nigh school he’s on medication an is an older boy loves people and everything plz it’s cold and snowing I want him home
Des Moines - South
Lost: 1/23/2021
ID: 15926
Name: Brianna
Type: Dog
Color: White/Blond
Breed: Lhasa Apso
Gender: Female
Fixed: Neutered
Age: Senior
She was last seen on Rose Ave on South side of Des Moines. Ourside of Wakonda Golf and Country Club. She is 14 years old and blind. Please call 515-554-0107
Des Moines - East
Lost: 1/22/2021
ID: 15914
Name: Teddy
Type: Dog
Color: Copper and white
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Senior
Let him out at 7:40am and noticed he was gone by 8am from our house near Easton and 29th. He’s most deaf and blind.
Hull
Lost: 1/21/2021
ID: 16050
Name: Turbo/ Champ
Type: Dog
Color: Black and black with white chest
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 1/21/2021
ID: 15930
Name: Unknown
Type: Cat
Color: Orange/cinnamon
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Kitty was found wandering river woods neighborhood.
Johnston
Lost: 1/21/2021
ID: 15915
Name: Barnes
Type: Cat
Color: Tiger short hair
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Galleria Dr And NW 94th will pay a reward of 100 for his safe return.
Berwick
Lost: 1/21/2021
ID: 15913
Name: Tootsie
Type: Dog
Color: White/black
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Senior
Sunny brook mobile homes
Collins
Lost: 1/21/2021
ID: 15911
Name: Whisp
Type: Dog
Color: White
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Young
He was at home and most likely chased a small animal like a rabbit or squirrel. And then before he knew it, was too far gone.