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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Found: 10/22/2017
ID: 7187
Name:
Type: Dog
Color: Black
Breed:
Gender: Unknown
Fixed: Unknown
Age: Young
64th st and Madison Avenue by Merle Hay mall in Urbandale Iowa
Urbandale
Found: 10/22/2017
ID: 7185
Name:
Type: Dog
Color: Black
Breed: Norfolk Terrier
Gender: Unknown
Fixed: Unknown
Age: Young
64th st in Urbandale Iowa
West Des Moines
Found: 10/22/2017
ID: 7178
Name: Unknown
Type: Dog
Color:
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Senior
Found at The Picker Knows
Des Moines - South
Found: 10/21/2017
ID: 7195
Name: Unknown
Type: Dog
Color: Red and white
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Unknown
Age: Senior
Found Sw 8th and Virginia ave.
Des Moines - East
Found: 10/21/2017
ID: 7170
Name:
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Exceptionally friendly. Walked right up when I went to check on her. She is safe in my bathroom at the moment. I had the ARL post her in the system, as well. She eats hard food and appears litter trained.
Colfax
Found: 10/21/2017
ID: 7108
Name: Loki
Type: Cat
Color: Brown white
Breed: Oriental Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Shellsburg
Found: 10/20/2017
ID: 7167
Name: Molly
Type: Dog
Color: black
Breed: Pomeranian
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Found: 10/20/2017
ID: 7166
Name:
Type: Dog
Color: Tan
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Found: 10/19/2017
ID: 7149
Name: Esco
Type: Dog
Color: Black/brown/ white
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
E Lacona Ave
West Des Moines
Found: 10/18/2017
ID: 7157
Name: Bender
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
He is extremely friendly and loving towards people and females dogs but he can be picky about liking other male dogs
Des Moines - West
Found: 10/18/2017
ID: 7151
Name: Unknown
Type: Dog
Color: Black back, white belly and paws, brown eyes
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Senior
Found this happy little girl in my neighborhood darting across Forest Street. She is very friendly, evidently house-trained, comes when called, quiet, and easy to care for. Someone must be missing her terribly. I would love to get her back to her owner before passing her onto a shelter. Contact me ASAP!!
Des Moines - East
Found: 10/18/2017
ID: 7143
Name:
Type: Cat
Color: Orange tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He is out on my porch eating some food. I can't let him in having a dog and cats myself. I'll keep food out there so he'll come back.
Des Moines - North
Found: 10/17/2017
ID: 7138
Name:
Type: Cat
Color: Gray striped
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
This tabby kitty with gold eyes has been visiting my yard near 37th st and franklin in beaverdale for awhile now and I was finally able to coax her (I think a female but dont want to stress too much by investigating closer) to me and I have her settled in for the night in the garage. Taking for chip check tomorrow. Seems to be front declawed and possibly back also. Friendly and likes to rub head on my chin. Hopefully she is missed and I can help reunite her with her family.
Cumming
Found: 10/17/2017
ID: 7132
Name: Scotch
Type: Dog
Color: Red
Breed: Irish Setter
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 3:30 this afternoon off of Cumming ave and 34th st. We miss him dearly and want him home!! Please call 515-326-2195 if you see him!!
Des Moines - Central
Found: 10/16/2017
ID: 7139
Name: Gringo
Type: Cat
Color: Orange
Breed: Irish Setter
Gender: Male
Fixed: Unknown
Age: Young
We found this adorable and very friendly orange kitten ( about a year or a little less old) out in the storm the other night. His back and neck are shaved. He is microchipped but HomeAgain microchip company has been unable to contact the family.
Des Moines - Central
Found: 10/16/2017
ID: 7135
Name:
Type: Cat
Color: ALL black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Found by Science Center in downtown Des Moines
Grimes
Found: 10/16/2017
ID: 7122
Name: Unknown
Type: Dog
Color: Brown
Breed: Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
Was on Highway 141 near Grimes, Iowa. Will be taking to the vet tomorrow to check for microchip status.
Chariton
Found: 10/16/2017
ID: 7121
Name:
Type: Dog
Color: Gold
Breed: Boxer
Gender: Unknown
Fixed: Unknown
Age: Young
Very friendly looks like it had a collar on at one point- found off hwy 34
Des Moines - East
Found: 10/16/2017
ID: 7120
Name: Moe
Type: Dog
Color: black grey and white
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Adult
He has been found
Des Moines - North
Found: 10/16/2017
ID: 7118
Name:
Type: Dog
Color:
Breed: Dachshund
Gender: Male
Fixed: Unknown
Age: Adult
5th and Arthur
Des Moines - South
Found: 10/16/2017
ID: 7115
Name:
Type: Dog
Color: Multi - Brown, Tan, Black, Grey
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
Found near Park Avenue and SW 34th/ SW 42nd Street in Des Moines. He is not microchipped and doesn't have any tags.
Des Moines - Central
Found: 10/15/2017
ID: 7106
Name: Unknown
Type: Dog
Color: black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Last seen in front of Samuelson Elementary in Des Moines. Please call 515-314-6155
Stuart
Found: 10/15/2017
ID: 7101
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
3097 285th street, stuat, iowa 50250 accompanied with a smaller toto dog.
Des Moines - East
Found: 10/13/2017
ID: 7097
Name:
Type: Dog
Color: Black with white down chest and white back paws
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Found on east 37 by 4 mile get ahold of me at 515-776-2469
Des Moines - South
Found: 10/13/2017
ID: 7091
Name:
Type: Bird
Color:
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on southside outside our home. Is a Indian Ringneck Parakeet Call 491-8180