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>='1575331200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 11/29/2019
ID: 12949
Name: Lala
Type: Dog
Color: Fawn
Breed: Jack Russell Terrier
Gender: Female
Fixed: Not Applicable
Age: Adult
On e Fleming dm is scared of people has six toes on each back legs. Wh. Chest wh feet
Farragut
Lost: 11/29/2019
ID: 12946
Name: Nova
Type: Dog
Color: Blue Merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen in Farragut, Iowa. Her and her sister escaped fenced yard. Found sister two hours later. No sign of Nova yet. She is a very timid dog and will bark if seen but will not bite. She needs to sniff you to calm down. She does not have a collar on since they just had baths. She is around 50lbs and has thick long fur that is multicolored.
Des Moines - South
Lost: 11/29/2019
ID: 12940
Name: Maggie
Type: Dog
Color: Brown
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Ankeny
Lost: 11/29/2019
ID: 12938
Name: Unknown
Type: Dog
Color: Brindle and white chest&boots
Breed: Akita
Gender: Male
Fixed: Unknown
Age: Adult
Found at Bricktowne at Piper apartments
Ankeny
Lost: 11/29/2019
ID: 12937
Name: Pyper
Type: Dog
Color: Brown/White
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Applicable
Age: Young
Mini Australian Shepherd missing from North Ankeny. Has collar & tags. Very friendly & answers to Pyper. Please call 515-205-7166 if spotted/found.
Ankeny
Lost: 11/29/2019
ID: 12935
Name: Jinxy
Type: Cat
Color: Seal point (cream body with brown face and paws)
Breed: Ragdoll
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen in the Northwest side of Ankeny (Georgetown Neighborhood). He is friendly and declawed.
Des Moines - South
Lost: 11/29/2019
ID: 12932
Name: Tala
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
Hills
Lost: 11/27/2019
ID: 12943
Name: Layla
Type: Dog
Color: Brown, white, black
Breed: Rat Terrier
Gender: Female
Fixed: Neutered
Age: Adult
We were on our way from Hills, Iowa to Clarksville, Tennessee. She got loose at the Metropolis, Illinois rest area.
Des Moines - East
Lost: 11/27/2019
ID: 12942
Name: Ruger
Type: Dog
Color: Tri color brown
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
He’s my companion and he is missed so much. He’s very friendly and likes bye bye. He also bays at squirrels constantly! He has a deafness when he gets his nose onto something. A bad downfall of his.
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