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>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Pleasant Hill
Found: 5/31/2017
ID: 5743
Name: Callie
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
She has a short tail
Adel
Found: 5/30/2017
ID: 5741
Name:
Type: Cat
Color: White and Gray
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Young
Has been hanging out in my backyard
Des Moines - East
Found: 5/30/2017
ID: 5722
Name:
Type: Dog
Color:
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Baby
Over on east 14th by radio city he was picked up very friendly need proof that he's urs
Des Moines - East
Found: 5/29/2017
ID: 5714
Name: Benji
Type: Dog
Color: Buffy tannish
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Adult
East 9th and douglas
Des Moines - East
Found: 5/29/2017
ID: 5710
Name: Unknown
Type: Dog
Color: Black, brown" and white
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
In the area of E 16th and University. Very well trained and amazing with kids.
Des Moines - North
Found: 5/28/2017
ID: 5701
Name:
Type: Dog
Color: tan
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
Found between Guthrie and 13th Street - NE Des Moines. Union Park neighborhood
Ankeny
Found: 5/27/2017
ID: 5691
Name: Carl
Type: Dog
Color: Tan
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on the SE side of Ankeny
Des Moines - East
Found: 5/26/2017
ID: 5688
Name: Capone
Type: Dog
Color: Brindle
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Senior
He doesn't like other dogs! Lost close to E 13th & University Ave, Des Moines IA