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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
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
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