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
Des Moines - Central
Found: 3/21/2019
ID: 10778
Name: Unknown
Type: Dog
Color: Black/white/brown
Breed: Australian Terrier
Gender: Male
Fixed: Unknown
Age: Young
On Indianola ave and 1st street running around in street animal control did pick u the dog
Norwalk
Found: 3/21/2019
ID: 10776
Name: Cash
Type: Dog
Color: White with brown ear
Breed: Jack Russell Terrier (Parson Russell Terrier)
Gender: Male
Fixed: Neutered
Age: Adult
He ran out the door from our house. 1 mile north of PROLE. West side of HWY 28 on 5190 FULTON Street
Des Moines - South
Found: 3/17/2019
ID: 10775
Name: Priest
Type: Dog
Color: Tan, and white
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Reward is $200. I just need my little man home.
West Des Moines
Found: 3/17/2019
ID: 10752
Name: Lola
Type: Dog
Color: Brown
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/17/2019
ID: 10751
Name: Lola
Type: Dog
Color: Brown
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Adult
Ankeny
Found: 3/17/2019
ID: 10750
Name:
Type: Cat
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Not Applicable
Age: Baby
Des Moines - South
Found: 3/16/2019
ID: 10741
Name:
Type: Dog
Color: Black and white
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Baby
In my mother’s backyard waiting for arl
Grimes
Found: 3/15/2019
ID: 10740
Name: Kaiser
Type: Dog
Color: blenheim
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Neutered
Age: Young
1400 block of NW Mockingbird Lane near highway 141
Des Moines - East
Found: 3/15/2019
ID: 10734
Name: Unknown
Type: Dog
Color: Tan/white
Breed: Cavalier King Charles Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Didn't want this lil fella getting hit by a car, found at East 25CT and Maple St.
Runnells
Found: 3/14/2019
ID: 10777
Name:
Type: Cat
Color: Yellow tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Urbandale
Found: 3/12/2019
ID: 10713
Name: Angus
Type: Dog
Color: Black and white
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Typically friendly... may be timid to strangers and other dogs. Angus is on medication for seizures. He did get his dose in Monday evening. After 2-3 days without meds, his back legs will start giving out.
Corydon
Found: 3/11/2019
ID: 10716
Name:
Type: Dog
Color: White and black
Breed: Blue Heeler
Gender: Male
Fixed: Unknown
Age: Baby
Running with a smaller lab/retriever mix brought to Corydon vet clinic
Corydon
Found: 3/11/2019
ID: 10715
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Running across hwy 2 near liberty drive with a white heeler, very friendly
Gilman
Found: 3/10/2019
ID: 10704
Name: No tags
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Sweet and energetic girl was at our front door/circling the property beginning on the afternoon of 3/10. She has a rainbow-patterned collar and a white flea collar but no tags. Appears to be a year old or younger. She was picked up by Jasper County Animal Rescue League (641-792-5407) on the morning of 3/11 and will be available for ID/pickup for seven days before moving onto their adoption list.
Urbandale
Found: 3/7/2019
ID: 10695
Name: Humpfree
Type: Dog
Color: Tan & White
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Adult
5200 block of 72nd St.. Johnston/ Urbandale area.
Des Moines - West
Found: 3/6/2019
ID: 10690
Name: Unknown
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
He’s been hanging around the house all day. I’ve never seen him in the neighborhood before. Just the sweetest thing! He’s in our guest bedroom for now.
Des Moines - Central
Found: 3/3/2019
ID: 10679
Name: Unknown
Type: Cat
Color: gray,
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
Im not sure if its stray or has a owner since it doesnt have a collar, The cat seems to have a bit of a limp, maybe hurt or because of the cold
West Des Moines
Found: 3/3/2019
ID: 10678
Name: Dante
Type: Dog
Color: White/black/brown
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Mitchellville
Found: 2/26/2019
ID: 10665
Name: UNknown
Type: Dog
Color: Yellow
Breed: Greyhound
Gender: Unknown
Fixed: Unknown
Age: Young
Ankeny
Found: 2/23/2019
ID: 10650
Name: Griffin
Type: Dog
Color: White Tan
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Baby
last seen using bathroom in our front yard. He never came back to the door like he always does. He is nowhere to be found we are led to believe he was stolen.
Ames
Found: 2/21/2019
ID: 10644
Name: Bear
Type: Cat
Color: Grey/Black/White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Bear went missing around noon on February 21st at my apartment on Mortensen Rd and Poe Ave. I thought he was sleeping in a hiding spot, but he’s nowhere to be found. He can be shy and flighty sometimes so if you see him, it’s important to not be loud and fast.
Des Moines - Central
Found: 2/21/2019
ID: 10643
Name: Unknown
Type: Dog
Color: white
Breed: Poodle
Gender: Male
Fixed: Neutered
Age: Senior
Ingersoll and Polk running in the street
Des Moines - West
Found: 2/20/2019
ID: 10640
Name: Kiko
Type: Dog
Color: Brownish/White
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 2524 61st St in Des Moines.
Urbandale
Found: 2/18/2019
ID: 10636
Name:
Type: Cat
Color: Brown and black stripe
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
At furry friends west Des Moines
Nevada
Found: 2/17/2019
ID: 10647
Name:
Type: Dog
Color: Tri
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Young