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>='1568505600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Found: 11/23/2015
ID: 1962
Name:
Type: Dog
Color:
Breed:
Gender: Female
Fixed: Unknown
Age: Young
Pleasant Hill
Found: 11/21/2015
ID: 1948
Name:
Type: Dog
Color: black, brown, white
Breed:
Gender: Female
Fixed: Unknown
Age: Adult
She was last seen walking around Orchard Drive in Pleasant Hill (just sound of the HyVee in Pleasant Hill). We have her here with us at home...she is safe and warm for the night, but is clearly loved and wanting to get back to her family!
St. Charles
Found: 11/20/2015
ID: 1932
Name:
Type: Dog
Color: She is White with black and gray markings
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Baby
She was found just south of Bevington and North of St.Charles. She is about 4 months old? Maybe. She was with a Labradoodle, male intact .. They are both wearing collars no tags.
West Des Moines
Found: 11/19/2015
ID: 1928
Name:
Type: Cat
Color: Brown striped tabby
Breed: Australian Shepherd
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on S52nd street. Unsure if male or female. Very sweet cat. Please call/text with description of cat so I can ensure it gets back to it's proper owner!
Des Moines - South
Found: 11/14/2015
ID: 1898
Name: Unknown
Type: Dog
Color:
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - East
Found: 11/12/2015
ID: 1872
Name: Tasha
Type: Dog
Color: yellow and white
Breed: Collie
Gender: Unknown
Fixed: Neutered
Age: Senior
Fence blew down in storm and she got out around 4 am.
Norwalk
Found: 11/11/2015
ID: 1865
Name:
Type: Dog
Color: black with white chest
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Afton
Found: 11/11/2015
ID: 1861
Name: Unknown
Type: Dog
Color: Blonde with white strip between eyes
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Found at Afton Caseys. Please call 516-423-8159 if missing this sweet boy.
Altoona
Found: 11/10/2015
ID: 1886
Name: Unknown
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Very affectionate! Comes to see us a couple times a day.
Norwalk
Found: 11/9/2015
ID: 1853
Name:
Type: Cat
Color: Black/brown
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 11/8/2015
ID:
Name:
Type: Dog
Color: Blue
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
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