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>='1555113600')) ORDER BY pm1.meta_value DESC, post_date DESC
Altoona
Found: 4/19/2016
ID: 2705
Name:
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
Altoona
Found: 4/17/2016
ID: 2708
Name:
Type: Dog
Color: Golden
Breed: Pomeranian Toy
Gender: Male
Fixed: Not Neutered
Age: Adult
Urbandale
Found: 4/15/2016
ID: 2682
Name: Abby
Type: Dog
Color: White/apricot
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Senior
90th and Iltis heading east
Des Moines - North
Found: 4/14/2016
ID: 2672
Name: No name tag
Type: Dog
Color: Black and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Found him on Aurora Ave on Lower Beaver in Des Moines.
West Des Moines
Found: 4/13/2016
ID: 2668
Name: Punkin
Type: Cat
Color: Black, orange, yellow
Breed: Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near western hills elementary school
Pleasant Hill
Found: 4/12/2016
ID: 2685
Name: Patches
Type: Cat
Color: gray
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Large gray Maine Coon cat. He loves to hunt and we suspect he may have wandered too far. He has very large golden eyes that melt one's heart. Went missing from his home in Pleasant Hill Tuesday, April 12, 2016. UPDATE: after missing several days, he just walked in the house. :) God hears prayers about our fury family members too! :)
Des Moines - East
Found: 4/11/2016
ID: 2645
Name:
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Unknown
Fixed: Unknown
Age: Young
E. 41st Ct. & Easton Blvd.
Mitchellville
Found: 4/5/2016
ID: 2617
Name:
Type: Dog
Color: White and brown
Breed: Maine Coon
Gender: Male
Fixed: Unknown
Age: Baby
Glenwood
Found: 4/3/2016
ID: 2906
Name: Buddy
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
found in Glenwood Ia
Ankeny
Found: 4/1/2016
ID: 2591
Name: Moo
Type: Cat
Color: Calico/tortie
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is skittish and likely hiding
Ankeny
Found: 4/1/2016
ID: 2590
Name: Moo
Type: Cat
Color: Calico/tortie
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She is skittish and likely hiding
Bondurant
Found: 3/30/2016
ID: 2571
Name:
Type: Dog
Color: brown
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 3/29/2016
ID: 2564
Name:
Type: Dog
Color:
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Found with collar. Will relates him to the person that correctly identifies the collar. Just want this guy to find his family.
Des Moines - East
Found: 3/27/2016
ID: 2539
Name: Unknown
Type: Dog
Color: Mostly black, some tan
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Adult
He's very friendly, large dog. Looks to be a rott mix. I found him and have him safe at my house. Must provide proof he is yours before I release him. Please call or email me if he is yours. 5156816948
Des Moines - West
Found: 3/26/2016
ID: 2536
Name:
Type: Dog
Color: White
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - West
Found: 3/26/2016
ID: 2535
Name:
Type: Dog
Color: White
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 3/19/2016
ID: 2494
Name:
Type: Dog
Color: Black & White
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Adult
Found between 2nd ave & cornell st at Euclid Call 515-771-4538
Des Moines - Central
Found: 3/18/2016
ID: 2506
Name: Inknown
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Senior
Chocolate lab must describe to claim
Des Moines - South
Found: 3/18/2016
ID: 2488
Name:
Type: Dog
Color: Black mix
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Unknown
Age: Adult
Has chain collar possibly with tags. Walking near Fareway on SE 22nd between Fareway abd Hartford Rd. around 7:20 pm tonight. Thinking dog. Mainly black with some lighter color.
Des Moines - North
Found: 3/18/2016
ID: 2487
Name: Princess?
Type: Dog
Color: White and Brindle
Breed: American Bulldog
Gender: Female
Fixed: Unknown
Age: Young
Upper Beaverdale area. Currently holding due to busy roads. Please call with any information about the owner!
Cedar Rapids
Found: 3/16/2016
ID: 2480
Name: Jackson
Type: Cat
Color: White
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
House cat. Never been outside. More than likely very scared.
Des Moines - North
Found: 3/16/2016
ID: 2479
Name:
Type: Dog
Color:
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Found: 3/12/2016
ID: 2456
Name: Unknown
Type: Dog
Color: Brown
Breed: American Bulldog
Gender: Male
Fixed: Unknown
Age: Young
30th and Grand
Des Moines - North
Found: 3/11/2016
ID: 2446
Name:
Type: Dog
Color: Black/brown or tan
Breed: Pinscher-Miniature
Gender: Female
Fixed: Unknown
Age: Adult
Found Union Park/Birdland Park/North High School area. Cornell & E. Sheridan Ave. Might be nursing mom
Des Moines - East
Found: 3/10/2016
ID: 2453
Name: Unknown
Type: Dog
Color: Orange and White
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Standing in yard of 3212 E. 43rd Ct., Des Moines (near Brook Run and Brubaker/Hoyt Schools).