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 = 'found' 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 - Central
Found: 6/24/2017
ID: 5969
Name:
Type: Dog
Color: White and tan
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Found on ramp of freeway at MLK
Johnston
Found: 6/21/2017
ID: 5948
Name: Nellie
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She was found this morning! Please have faith that hours will be found too
Johnston
Found: 6/21/2017
ID: 5945
Name: Nellie
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She was Found This Morning. Thanks for everyones help. And please keep faith that your family member will be found too!
Urbandale
Found: 6/19/2017
ID: 5919
Name:
Type: Dog
Color:
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
62nd and Meredith in urbandale.
Altoona
Found: 6/16/2017
ID: 5890
Name:
Type: Cat
Color:
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
Altoona
Found: 6/16/2017
ID: 5888
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Indianola
Found: 6/16/2017
ID: 5874
Name: Casi
Type: Dog
Color: Black and tan
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Not Applicable
Age: Senior
Casi was found!!
Grimes
Found: 6/14/2017
ID: 5887
Name: Socks
Type: Cat
Color: White feet and chest black/Gray body
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Bondurant
Found: 6/14/2017
ID: 5861
Name: Leo
Type: Dog
Color: Tri black
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Baby
Bondurant
Found: 6/12/2017
ID: 5867
Name: Unknown
Type: Cat
Color: Black and white(black has a hint of brown)
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Its very friendly, found on my back porch. Its really scared and i can tell it was an inside cat. It could be from altoona as i live right on border of altoona/bondurant
West Des Moines
Found: 6/12/2017
ID: 5850
Name:
Type: Cat
Color: Grey and Peach/Green Eyes
Breed: Tortoiseshell
Gender: Male
Fixed: Unknown
Age: Young
Young adult polydactyl kitten, very friendly and loving
Des Moines - South
Found: 6/11/2017
ID: 5835
Name: Unknown
Type: Dog
Color: multi
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
This pup looks to have been very well taken care of. Very Friendly. Nails on pup were painted and the collar is very unique.
Des Moines - East
Found: 6/10/2017
ID: 5830
Name:
Type: Dog
Color: tan and the other brown and white
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Unknown
Age: Adult
they were in the highland/oak park neighborhood if these two are your dogs please call 515-991-2927
Clive
Found: 6/8/2017
ID: 5813
Name: Enzi
Type: Cat
Color: Whire
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Days inn hotel
West Des Moines
Found: 6/8/2017
ID: 5803
Name:
Type: Dog
Color: Burgundy
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Found her running around 25th street in West Des Moines near Fairmeadows park.
Des Moines - East
Found: 6/7/2017
ID: 5799
Name: Unknown
Type: Dog
Color: Black with white
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Call or text 515-707-0507 if you are the owner
Altoona
Found: 6/6/2017
ID: 5791
Name: Gatsby
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Not Neutered
Age: Adult
He doesn't have a collar on. He's friendly and will jump up on you for love. Since he runs around and plays in the dirt and water on our land, his belly can be dirty.
Urbandale
Found: 6/5/2017
ID: 5814
Name: unknown
Type: Bird
Color: black with white tail and head. A spotted purple ring around the neck
Breed: Pigeon
Gender: Unknown
Fixed: Unknown
Age: Adult
It is staying with us free to come and go. It is being fed and has water.
Cumming
Found: 6/4/2017
ID: 5779
Name:
Type: Dog
Color: White w brown head
Breed: Pointer
Gender: Male
Fixed: Neutered
Age: Young
Found with 3 setters
Cumming
Found: 6/4/2017
ID: 5778
Name: Unknown
Type: Dog
Color: White with tan spots
Breed: English Setter
Gender: Male
Fixed: Neutered
Age: Young
Was found with 3 other dogs
Des Moines - North
Found: 6/2/2017
ID: 5758
Name: Milky way
Type: Cat
Color:
Breed: English Setter
Gender: Unknown
Fixed: Unknown
Age: Adult
Ames
Found: 6/2/2017
ID: 5757
Name:
Type: Rabbit
Color: Tan/white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Contact number: 319-430-5648
Ames
Found: 6/2/2017
ID: 5756
Name:
Type: Rabbit
Color: White brown
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Ankeny
Found: 6/2/2017
ID: 5754
Name: Sponge
Type: Cat
Color: Yellow and white with white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen Thursday night, June 1st. If found please return to 3402 SW Fairway Circle in Ankeny, IA 50023 or call any of the following numbers: 515-783-6467, 515-707-2651, 515-783-6481, 515-963-1950.
Des Moines - North
Found: 5/31/2017
ID: 5747
Name: Carl
Type: Cat
Color: Grey
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Baby
Hes a medium size cat but has a big belly. Always comes when he escapes bit got out 5-31-17 at night