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
Clive
Found: 11/7/2015
ID: 1836
Name:
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
152nd and Hickman road
Des Moines - South
Found: 11/3/2015
ID: 1798
Name:
Type: Dog
Color: Black
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
Travels around the SW17th and SW16th neighborhood by army post and fleur.
Des Moines - Central
Found: 10/30/2015
ID: 1786
Name: we call him October
Type: Cat
Color: tiger striped, black grey white and brown
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
Found in West Des Moines on Grand Avenue, by a Valvoline. Took him to the vet when we found him, they said he was about 6 months old, a little under weight from being outside for who knows how long. Not declawed, not neutered, but so lovey, come right up to a stranger and didn't hiss or scratch, very calm kitten. He's got one little black dot on each sides of his nose. Don't know if he even has had an owner, but we are looking for a good home for him, we don't really have the money to take care of him but we didn't want to leave him a stray.
Collins
Found: 10/28/2015
ID: 1764
Name:
Type: Dog
Color: Yellow
Breed: Retriever, Labrador
Gender: Male
Fixed: Unknown
Age: Adult
Found him approximately 2 miles North of Collins. No tags, only a collar on him.
Boone
Found: 10/27/2015
ID: 1761
Name: Lilly
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Between Benton & 15th St
Adel
Found: 10/26/2015
ID: 1777
Name: ??
Type: Cat
Color: Gray and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
He is still here! On our deck. He is beautiful and looks to be Siamese mix with bright blue eyes. He has claws but seems to be from a home as he is super sweet. We have been giving him food and water. Just worried about him when ot gets colder.
Clive
Found: 10/26/2015
ID: 1750
Name:
Type: Dog
Color: White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
One block south of Campbell Park with a UK collar- no tags
Perry
Found: 10/24/2015
ID: 1740
Name: unknown
Type: Dog
Color: black and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
found on 7th and warford almost got hit by a car.
Urbandale
Found: 10/24/2015
ID: 1738
Name:
Type: Dog
Color: Yellow/White
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Altoona
Found: 10/23/2015
ID: 1730
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Found: 10/22/2015
ID: 1725
Name: ? no name
Type: Dog
Color: black and tan
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Unknown
Age: Young
Found running on waterbury rd. yesterday and today. Currently in my possession. Move the marker to the pet's last known location/location it was found (optional):
Grimes
Found: 10/21/2015
ID: 1724
Name:
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 10/21/2015
ID: 1720
Name:
Type: Cat
Color: Calico (orange, black, white)
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
Found by Drake Diner
Des Moines - East
Found: 10/20/2015
ID: 1708
Name:
Type: Dog
Color: cream and whitel
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Young
found on east 26th and east university ave
Des Moines - Central
Found: 10/12/2015
ID: 1653
Name:
Type: Dog
Color: Black & Tan
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
Sleeping at my house. He seems lost but hes very well behaved.
Des Moines - Central
Found: 10/12/2015
ID: 1652
Name:
Type: Dog
Color: Mostly white, with silver and a little tan
Breed: Siberian Husky
Gender: Female
Fixed: Unknown
Age: Young
Still at my house, sleeping.
Ankeny
Found: 10/8/2015
ID: 1634
Name:
Type: Cat
Color: he's about 12weeks kind of cross eyes! tiny little feet. striped and spotted belly
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Found: 9/30/2015
ID: 1563
Name:
Type: Dog
Color: white and brown
Breed: Bengal
Gender: Female
Fixed: Not Applicable
Age: Adult
Urbandale
Found: 9/29/2015
ID: 1555
Name: Unknown
Type: Dog
Color: Black
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Young
Found this little guy on side of road he is very friendly and affectionate. He is a very good boy
Urbandale
Found: 9/29/2015
ID: 1554
Name: Unknown
Type: Dog
Color: Black
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Young
I have the puppy! Will keep him safe till we can find his family
Des Moines - Central
Found: 9/27/2015
ID: 1529
Name: Yorkie Dog
Type: Dog
Color:
Breed: Yorkie Poo
Gender: Male
Fixed: Unknown
Age: Adult
SE14th and I235
Altoona
Found: 9/26/2015
ID: 1532
Name: Cairn Terrier
Type: Dog
Color: black
Breed: Cairn Terrier
Gender: Male
Fixed: Unknown
Age: Adult
found running on hwy. near 141 exit @ Hubble rd off 80 E. Taken to IVRC (Iowa Veterinary Referral center) 515-727-4872 Does have Rabies tag.
Des Moines - East
Found: 9/26/2015
ID: 1518
Name:
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Young
Friendly
Ankeny
Found: 9/26/2015
ID: 1515
Name: Angie
Type: Dog
Color: White with Brown spots
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Adult female dog, white with brown spots, possibly a pointer mix. Found near the Bandana's parking lot at 301 East 1st street in Ankeny. Is being held at the Ankeny Police Department at 411 SW Ordnance Rd. Must show proof of ownership to pick up.
Des Moines - East
Found: 9/26/2015
ID: 1511
Name: Colline
Type: Dog
Color: White with brown spots
Breed: Border Collie
Gender: Female
Fixed: Not Neutered
Age: Young