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>='1573084800')) ORDER BY pm1.meta_value DESC, post_date DESC
Donnellson
Found: 6/28/2015
ID: 867
Name:
Type: Dog
Color: white
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Senior
Des Moines - North
Found: 6/26/2015
ID: 831
Name: Unk
Type: Dog
Color: Light brown
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
Not sure if this belongs here, but tonight my wife and I found this beautiful dog, please help us locate her family. Located 2 blocks east of park fair mall. She has recently had pups and I am sure they're missing her
Des Moines - East
Found: 6/25/2015
ID: 824
Name: Unknown (Female) Pitbull Puppy
Type: Dog
Color: must identify
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Followed us home while on a walk on the east side by the fair.
Altoona
Found: 6/24/2015
ID: 819
Name: Murphy
Type: Dog
Color: Murphy white and brown
Breed: English Setter
Gender: Male
Fixed: Neutered
Age: Adult
In adventureland estates neighborhood.
Windsor Heights
Found: 6/18/2015
ID: 787
Name:
Type: Cat
Color: grey and white
Breed: English Setter
Gender: Unknown
Fixed: Unknown
Age: Baby
Windsor Heights
Found: 6/18/2015
ID: 786
Name:
Type: Cat
Color:
Breed: English Setter
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 6/17/2015
ID: 782
Name:
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
found one block east of Hoover High School. Between Aurora and Madison
Des Moines - South
Found: 6/15/2015
ID: 759
Name:
Type: Dog
Color: blonde/brown
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Johnston
Found: 6/12/2015
ID: 749
Name:
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
We found him running on a busy road in northern Johnston, close to Camp Dodge.
Des Moines - Central
Found: 6/12/2015
ID: 736
Name:
Type: Dog
Color: grey and white
Breed: Alaskan Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - East
Found: 6/10/2015
ID: 728
Name: stash
Type: Cat
Color:
Breed: Alaskan Husky
Gender: Female
Fixed: Neutered
Age: Adult
Found her today!!! She is back home with us once again!!!! She has lost all her weight she was 12lbs now she weighs 3!!! We r glad she is safe and back home!!!!
Des Moines - West
Found: 6/2/2015
ID: 672
Name: Unknown
Type: Dog
Color: Auburn
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Baby
Found roaming front lawn at Roosevelt high school. Seems to have poor hearing and vision
Des Moines - North
Found: 6/1/2015
ID: 669
Name: Buddy
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Running loose at Prospect Park right off Hickman. Super friendly! Must be able to tell me his body color and whether he had collar and what is on the collar!
Des Moines - North
Found: 6/1/2015
ID: 668
Name: Buddy
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Running loose at Prospect Park right off Hickman. Super friendly! Must be able to tell me his body color and whether he had collar and what is on the collar!
Ankeny
Found: 6/1/2015
ID: 664
Name: Sarabi
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Not declawed. Terrified of being outside. Answers to Sarabi and Robby.
Des Moines - Central
Found: 5/27/2015
ID: 634
Name: ?
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
Found in Beverdale, very nice.
Des Moines - Central
Found: 5/27/2015
ID: 633
Name:
Type: Dog
Color: white
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
found in Beverdale area.
Des Moines - East
Found: 5/25/2015
ID: 631
Name:
Type: Cat
Color: White with Calico ears, spot on side, tail is grey stripped
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Young
We are trying to catch this cat and take to the ARL on E 14th St. As soon as we catch her she will be there.
Des Moines - South
Found: 5/25/2015
ID: 600
Name:
Type: Dog
Color: Tan and white
Breed: Corgi
Gender: Male
Fixed: Unknown
Age: Adult
Sw 5th pl. Very friendly and not scared at all. Being taken care of.
Ames
Found: 5/23/2015
ID: 606
Name:
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Found near Onion Creek Farm in NW Ames. Vocal and skittish. Call 701 317 2940 to identify.
Carlisle
Found: 5/16/2015
ID: 551
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
This dog came to our house last night.
Carlisle
Found: 5/16/2015
ID: 549
Name:
Type: Dog
Color: Brown and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
Winterset
Found: 5/11/2015
ID: 524
Name:
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
Ankeny
Found: 5/6/2015
ID: 488
Name: William
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Johnston
Found: 5/6/2015
ID: 482
Name: Unknown
Type: Cat
Color: Orange and White
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
I have the cat in a crate to protect it. I have an acreage and a very large raccoon was already chasing the cat when I found it. The cat is very scared of people and appears to be in good health.