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>='1594252800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 11/27/2019
ID: 12934
Name: Ruger
Type: Dog
Color: Brown and white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
Lost from our fenced yard, gate was accidentally left open. Corner of E40th Ct and Easton special needs dog for my daughter
Des Moines - North
Lost: 11/27/2019
ID: 12933
Name: Yukon
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - East
Lost: 11/27/2019
ID: 12931
Name: Rose
Type: Dog
Color: Brown and cream
Breed: Husky
Gender: Female
Fixed: Neutered
Age: Adult
Peosta
Lost: 11/27/2019
ID: 12930
Name: Hannigan
Type: Dog
Color: Light brown
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Neutered
Age: Baby
Des Moines - North
Lost: 11/27/2019
ID: 12926
Name: Benny
Type: Cat
Color: Grey
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Neutered
Age: Baby
He slipped out of the house. Super friendly and loves food (good way to bribe him to you)
Cumming
Lost: 11/27/2019
ID: 12924
Name: Indy and nala
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Neutered
Age: Adult
Two dogs. One is a Pyrenees 3 year old female other is a 8 month white German Shepherd. The female has a purple collar
Des Moines - East
Lost: 11/26/2019
ID: 12919
Name: Bear
Type: Dog
Color: Black/brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen in the back yard of my house
Terril
Lost: 11/25/2019
ID: 12990
Name: Boots
Type: Cat
Color: Grey/Black/White/Tiger Striped
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Warner & 1st Street in South Terril, IA
Osceola
Lost: 11/25/2019
ID: 12951
Name: Ruby
Type: Dog
Color: red
Breed: Coonhound
Gender: Female
Fixed: Unknown
Age: Young
last seen Nov 25th at 5pm west of Osceola
Osceola
Lost: 11/25/2019
ID: 12950
Name: Rowdy
Type: Dog
Color: red
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
last seen West of Osceola at 5 pm
Des Moines - East
Lost: 11/25/2019
ID: 12948
Name: smokey
Type: Cat
Color: gray and white
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
decrewled front feet house cat
Altoona
Lost: 11/25/2019
ID: 12915
Name: Ralph
Type: Cat
Color: Orange
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
He’s afraid of people. He likes Temptations treats and pate’ wet food. Responds to his name or Ralphie. Last seen in ALTOONA, Wyatt Wood development, 11th St NW.
Des Moines - South
Lost: 11/25/2019
ID: 12912
Name: Chica
Type: Dog
Color: Tan, white & black
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
Around the 802 E. County line Rd. Southridge Estate area
Newton
Lost: 11/24/2019
ID: 12905
Name: Z
Type: Dog
Color: Grey/wht
Breed: American Staffordshire Terrier
Gender: Unknown
Fixed: Neutered
Age: Senior
Walmart parking lot
Des Moines - East
Lost: 11/24/2019
ID: 12904
Name: Diamond
Type: Dog
Color:
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - South
Lost: 11/24/2019
ID: 12901
Name: Kody
Type: Dog
Color: Blue merel
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Senior
Escaped back yard
Johnston
Lost: 11/23/2019
ID: 12918
Name: Gizmo
Type: Cat
Color: Gold/Yellow
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Hampton
Lost: 11/23/2019
ID: 12910
Name: Maggie
Type: Dog
Color: White with dark markings
Breed: English Setter
Gender: Female
Fixed: Not Applicable
Age: Senior
Last seen 5 miles south of Hampton, Iowa. May have been spotted 6 miles south of Coulter on Sunday morning. Reward. Please help!
Des Moines - Central
Lost: 11/23/2019
ID: 12900
Name: Itty Bitty
Type: Cat
Color: Cream, brown and black
Breed: Snowshoe
Gender: Female
Fixed: Neutered
Age: Adult
She lives near 37th Street and Kingman Blvd Call 641-425-0154
West Des Moines
Lost: 11/23/2019
ID: 12898
Name: Monty
Type: Cat
Color: Black and white
Breed: Snowshoe
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Lost: 11/23/2019
ID: 12897
Name: Monty
Type: Cat
Color: Black and white
Breed: Snowshoe
Gender: Male
Fixed: Unknown
Age: Young
Wellington Apartments
West Des Moines
Lost: 11/23/2019
ID: 12895
Name: Monty
Type: Cat
Color: Black and white
Breed: Snowshoe
Gender: Male
Fixed: Unknown
Age: Young
Wellington Apartments
Des Moines - South
Lost: 11/22/2019
ID: 12925
Name: DG
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Se 8th and park ave
Packwood
Lost: 11/22/2019
ID: 12921
Name: Savage
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
He enjoys chasing birds, mice, bunnies and squirrels. He has no interest in other cats at all. He has the purest green eyes and is a huge sweetheart who craves attention.
Altoona
Lost: 11/22/2019
ID: 12888
Name: Avery
Type: Cat
Color: Black, gray, white stripes
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
I think she may have snuck out this morning. She has all 4 paws declawed.